Details of concurrent request with user and period SELECT req.request_id, DECODE (prg.user_concurrent_program_name, 'Report Set', 'Report Set:' || req.description, prg.user_concurrent_program_name) AS name, argument_text AS parameters, req.resubmit_interval, NVL2 (req.resubmit_interval, 'Periodically', NVL2 (req.release_class_id,...

During the debug of form user face issue to find out the trace file of the activity. Below script make it easy to find trace file through concurrent request id....

Full details of blocking session SELECT s.inst_id, NVL (s.username, 'Internal') database_user, s.SID, s.event, s.p1, s.serial#, p.spid, m.TYPE, DECODE (m.lmode, 0, 'None', 1, 'Null', 2, 'Row Share', 3, 'Row Excl.', 4,...

Easily identify executable file name of concurrent request. SELECT fcpv.user_concurrent_program_name concurrent_program_name, fe.execution_file_name source_name, fl.meaning program_type FROM apps.fnd_concurrent_programs_vl fcpv, apps.fnd_executables fe, apps.fnd_lookups fl WHERE fe.executable_id = fcpv.executable_id AND fl.lookup_type = 'CP_EXECUTION_METHOD_CODE'...

Get log file & output file location of concurrent request with all the details. SELECT DISTINCT fcp.user_concurrent_program_name, fcp.concurrent_program_name, fcr.request_id, fcr.request_date, flv.meaning status, fcr.status_code, fcr.completion_text, fcr.logfile_name, fcr.outfile_name, fcr.argument_text FROM apps.fnd_concurrent_programs_vl fcp,...

Discover concurrent request run in which concurrent manager SELECT a.include_flag, a.queue_application_id, c.user_concurrent_queue_name, d.user_concurrent_program_name FROM applsys.fnd_concurrent_queue_content a, applsys.fnd_concurrent_programs b, apps.fnd_concurrent_queues_vl c, fnd_concurrent_programs_tl d WHERE type_id = b.concurrent_program_id AND c.concurrent_queue_id = a.concurrent_queue_id...

Once applied the patch DBA can examine if any table is modified with the column name. SELECT table_name, column_name FROM dba_tab_columns WHERE table_name IN ('AP_INVOICES_INTERFACE', 'AP_INVOICE_LINES_INTERFACE', 'AP_INVOICES_ALL', 'AP_INVOICE_DISTRIBUTIONS_ALL', 'AP_INVOICE_LINES_ALL', 'AP_INVOICE_PAYMENTS_ALL',...

Find out value of profile option at any level from backend.  User have to enter the name of profile during the execution of script. SELECT b.user_profile_option_name "Long Name", a.profile_option_name "Short...