Creating Implementation Project in Fusion Financials Login to application with user name and password. Select Setup and Maintenance Select Implementation Projects Select create to create implementation project Enter required details and then select “Next” Select […]
How to Create Implementation User and assign roles to the user Login to Fusion Application using userid(fin_impl) and password Dashboard Select Settings and Actions → Administration → Setup and Maintenance Select Financial offering and then select “Setup” […]
Source: http://shaikoracleappsdba.blogspot.in/2013/09/long-running-concurrent-requests.html 1.How to Determine Which Manager Ran a Specific Concurrent Request? col USER_CONCURRENT_QUEUE_NAME for a100 select b.USER_CONCURRENT_QUEUE_NAME from fnd_concurrent_processes a, fnd_concurrent_queues_vl b, fnd_concurrent_requests c where a.CONCURRENT_QUEUE_ID = b.CONCURRENT_QUEUE_ID and a.CONCURRENT_PROCESS_ID = c.controlling_manager and c.request_id […]
——————————————————————————- — Query to find all responsibilities of a user ——————————————————————————- SELECT fu.user_name “User Name”, frt.responsibility_name “Responsibility Name”, fu.start_date “User Access Start Date”, fu.end_date “User Access End Date”, furg.start_date “Resp Access Start Date”, furg.end_date “Resp […]
a) 1.Run the script for any concurrent request which is going into pending/running status and upload the output to SR. Note 134033.1 ANALYZEPENDING.sql Script for Analyzing all Pending Requests or Note 134035.1 ANALYZEREQ.SQL – Detailed […]
How to Alter Database Sequence or How to increment or decrements sequence. select * from all_sequences where sequence_name like ‘RA_TRX_NUMBER%’; SELECT last_number FROM all_sequences WHERE sequence_name = ‘RA_TRX_NUMBER_N1_81_S’; SELECT last_number FROM all_sequences WHERE sequence_name = […]
Use following query to find the accounting package is being used select * from all_objects where object_name in (select ‘XLA_’||LPAD(application_id ,5 ,0) || ‘_AAD_’||product_rule_type_code || ‘_’||LPAD(product_rule_hash_id,6 ,0) || ‘_PKG’ from xla.XLA_PRODUCT_RULES_B where (application_id, product_rule_type_code, product_rule_code, […]
