Syed Saad Ali

Oracle ACE Pro

Oracle Solution Architect

Oracle E-Business Suite

Oracle Cloud Infrastructure

Oracle Fusion Middleware

Oracle Database Administration

Oracle Weblogic Administration

Syed Saad Ali

Oracle ACE Pro

Oracle Solution Architect

Oracle E-Business Suite

Oracle Cloud Infrastructure

Oracle Fusion Middleware

Oracle Database Administration

Oracle Weblogic Administration

Month: November 2017

November 9, 2017 How to Find Request Group associated for a Program
AppsDBA ScriptsScripts

How to Find Request Group associated for a Program

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’; 

November 9, 2017 How to Find Scheduled Concurrent Program
AppsDBA ScriptsScripts

How to Find Scheduled Concurrent Program

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; 

November 8, 2017 Different Statuses of Concurrent Manager
APPS DBAInstallations/Configurations-Applications

Different Statuses of Concurrent Manager

 

PENDING STATUS

Normal – Request is waiting for the next available manager. Currently all manager are running other requests.
Standby – Program to run request is incompatible with other program(s) currently running. The requests will be in the Conflict Resolution Manager’s queue. Once the other request with which the request is incompatible gets completed then the  request will be executed.
Scheduled Request is scheduled to start at a future time or date.  
Waiting A child request is waiting for its Parent request to mark it ready to run Request which runs sequentially will wait for a prior request to complete.

RUNNING STATUS 

Normal Request is running normally.
Paused Parent request pauses for all its child requests to finish.
Resuming All requests submitted by the same parent request (i.e. child requests) have completed running. The Parent request resumes running.
Terminating – Request is terminated forcefully by choosing the Cancel Request button in Concurrent Request window from front end.

COMPLETED STATUS

Normal Request completed successfully.
Error Request failed to complete successfully.
Warning Request completed with warnings.
Cancelled Pending or Inactive request is cancelled by choosing the  Cancel  Request button in the Concurrent Requests window from front end.
Terminated Request is terminated by choosing the Cancel Request button in the Concurrent Requests window from front end. This states comes after Running-Terminating state.

INACTIVE STATUS

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.

 

 

November 8, 2017 How to Stop Concurrent Manager Properly
APPS DBAInstallations/Configurations-Applications

How to Stop Concurrent Manager Properly

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.

$kill -9 `ps -ef|grep FNDLIBR|awk ‘{print $2}’`
or
$ps -ef|grep FNDLIBR|awk ‘{print $2}’|xargs kill -9