select distinct user_concurrent_program_name, responsibility_name, user_name, request_date, argument_text, request_id, requested_by, phase_code, status_code, a.concurrent_program_id, a.responsibility_id, logfile_name, outfile_name from fnd_concurrent_requests a, fnd_concurrent_programs_tl b, fnd_responsibility_tl c, fnd_user d where a.CONCURRENT_PROGRAM_ID = b.concurrent_program_id and a.responsibility_id = c.responsibility_id and a.requested_by = d.user_id and user_name like 'sonu'
Find from which responsibility user has ran the concurrent program
Subscribe to:
Post Comments (Atom)
Manage Inactive session in Oracle 23AI Database.
# CONNECT WITH PDB DATABASE(ORACLE 23AI) [oracle@prd-23ai ~]$ sqlplus / as sysdba SQL*Plus: Release 23.0.0.0.0 - for Oracle Cloud and Engin...
-
Application version : R12.2.10 DB version : 19.17.0 ERROR APP-FND-01388: Cannot read value for profile option CONC_KEEP_BLANK_FILES in rout...
-
How to clean FND_NODES table in R12.2.4 Step 1: Always apply the latest cloning patches to avoid all the bugs and fixes Step 2: ...
-
CONCURRENT MANAGER ISSUES IN APPS R12 Status code and Phase code for Concurrent requests Here is what the abbreviation for ...
No comments:
Post a Comment