Tuesday, September 17, 2013

Concurrent Request Currently Running

--------------------------------------
-Concurrent Requests Currently Running
-File Name : crs.sql
-Usage : crs
--------------------------------------

col USER_CONCURRENT_PROGRAM_NAME for a50
col ARGUMENT_TEXT  for a50
set line 200
alter session set nls_date_format='dd-Mon-RR hh24:mi:ss';
select request_id,USER_CONCURRENT_PROGRAM_NAME,requested_by,ACTUAL_START_DATE,ARGUMENT_TEXT from apps.fnd_concurrent_worker_requests where status_code='R'
/

No comments:

Post a Comment

NLS boot file not found or invalid opmnctl ping – EBS 12.2 ADCFGCLONE FAIL

Error: adcfgclone.pl failed while performing clone of EBS 12.2 instance. This occurred while ohsT2PApply is in progress. INST_TOP/adm...