Oracle ACE Pro
Oracle Solution Architect
Oracle E-Business Suite
Oracle Cloud Infrastructure
Oracle Fusion Middleware
Oracle Database Administration
Oracle Weblogic Administration
Oracle ACE Pro
Oracle Solution Architect
Oracle E-Business Suite
Oracle Cloud Infrastructure
Oracle Fusion Middleware
Oracle Database Administration
Oracle Weblogic Administration
SELECT rg.application_id
“Request Group Application ID”,
rg.request_group_id
“Request Group – Group ID”,
rg.request_group_name,
rg.description,
rgu.unit_application_id,
rgu.request_group_id
“Request Group Unit – Group ID”,
rgu.request_unit_id,
cp.concurrent_program_id,
cp.concurrent_program_name,
cpt.user_concurrent_program_name,
Decode(rgu.request_unit_type, ‘P’, ‘Program’,
‘S’, ‘Set’,
rgu.request_unit_type) “Unit Type”
FROM fnd_request_groups rg,
fnd_request_group_units rgu,
fnd_concurrent_programs cp,
fnd_concurrent_programs_tl cpt
WHERE rg.request_group_id = rgu.request_group_id
AND rgu.request_unit_id = cp.concurrent_program_id
AND cp.concurrent_program_id = cpt.concurrent_program_id
AND cpt.user_concurrent_program_name = ‘Program Name’;
Below Query will Fetch all the details for a scheduled concurrent program.
SELECT a.requested_by,
a.status_code,
a.phase_code,
a.request_id,
b.user_concurrent_program_name,
c.concurrent_program_name,
a.requested_start_date,
c.execution_method_code,
d.execution_file_name,
d.execution_file_path
FROM apps.fnd_concurrent_requests a,
apps.fnd_concurrent_programs_tl b,
apps.fnd_concurrent_programs c,
apps.fnd_executables d
WHERE a.status_code IN ( ‘Q’, ‘I’ )
AND a.concurrent_program_id = b.concurrent_program_id
AND b.concurrent_program_id = c.concurrent_program_id
AND c.application_id = d.application_id
AND c.executable_id = d.executable_id
AND a.requested_start_date > SYSDATE
AND a.hold_flag = ‘N’
ORDER BY 1;
Query For Finding schedules for a particular program
SELECT a.requested_by,
a.status_code,
a.phase_code,
a.request_id,
b.user_concurrent_program_name,
c.concurrent_program_name,
a.requested_start_date,
c.execution_method_code,
d.execution_file_name,
d.execution_file_path
FROM apps.fnd_concurrent_requests a,
apps.fnd_concurrent_programs_tl b,
apps.fnd_concurrent_programs c,
apps.fnd_executables d
WHERE a.status_code IN ( ‘Q’, ‘I’ )
AND a.concurrent_program_id = b.concurrent_program_id
AND b.concurrent_program_id = c.concurrent_program_id
AND c.application_id = d.application_id
AND c.executable_id = d.executable_id
AND a.requested_start_date > SYSDATE
AND a.hold_flag = ‘N’
AND b.user_concurrent_program_name = ‘&Program_Full_Name’
ORDER BY 1;
Disabled – Program to run request is not enabled. We need to Contact System Administrator.
On Hold – Pending request is placed on hold forcefully by choosing the Hold Request button in the Concurrent Requests window.
No Manager – No manager is defined to run the request or the manager needed to run the request is down. We need to Contact System Administrator. A status of No Manager is also given when all managers are locked by run-alone requests.
Step 1. Go to Oracle Application Scripts Home
$cd /apps/ebs/inst/apps/PROD_apps/admin/scripts
Step 2. Stop Concurrent Manager with the following script
$adcmctl.sh stop <appsusername/password>
Step 3. Check the Processes for Concurrent Manager, is it still running.
$ps -ef |grep FNDLIBR
Step 4. If there are processes running the we can manually kill the processes.
All Rights Reserved