Change Concurrent manager for a Program

How to change a concurrent manager for a program.

Ex:-
1) exclude the program from the standard manager:
SYSADMIN--> Concurrent --> Manger -->Define


 

--> Specialization rules:




Exclude the Program:



Now go to the customer Manager and include the program:

Ensure Load Balancing Of Concurrent Manager Processes In PCP-RAC Configuration

How to make sure whether the conc process are getting load balanced or not?

SQL> conn apps/appspwdhere
Connected.
SQL> set linesize 1000
SQL> select inst_id, count(*)
from gv$session
where process in
(select os_process_id from fnd_concurrent_processes
where process_status_code = 'A')
group by inst_id;  2    3    4    5    6

   INST_ID   COUNT(*)
---------- ----------
         1         89
         2         92

If they are load balanced then.

1.Set the profile option "Concurrent: PCP Instance Check" to "OFF"
2.Set the context variable s_cp_twotask to ''  ( RAC service name which you created to load balance on the specific nodes/instances.

Run Autoconfig.

Concurrent program run times

SELECT v.REQUEST_ID,to_char(v.ACTUAL_START_DATE,'dd-mm-yy hh24:mi:ss') "Started at",to_char(v.ACTUAL_COMPLETION_DATE,'dd-mm-yy hh24:mi:ss') "Completed at",
decode(v.PHASE_CODE,'C','Completed','I','Inactive','P','Pending','R','Running',v.PHASE_CODE) phasecode,
decode(v.STATUS_CODE, 'A','Waiting', 'B','Resuming', 'C','Normal', 'D','Cancelled', 'E','Error', 'F','Scheduled', 'G','Warning', 'H','On Hold', 'I','Normal', 'M','No Manager',
'Q','Standby', 'R','Normal', 'S','Suspended', 'T','Terminating', 'U','Disabled', 'W','Paused', 'X','Terminated', 'Z','Waiting') "Status",
round(((nvl(v.actual_completion_date,sysdate)-v.actual_start_date)*24*60)) Etime, substr(v.argument_text,1,45) param
FROM apps.fnd_conc_req_summary_v v
WHERE nvl(v.actual_start_date,sysdate) >= (sysdate- 10 ) <=== change this as needed
and v.user_concurrent_program_name like 'XXTWC: Nightly Calcuation for Prior Period'
order by request_id desc ;

Add new concurrent program

Some concurrent Programs may not be added to the SYSADMIN responsibility and you cannot submit/schedule the request until the concurrent program is added to the user security group that you want to run from.

Here I am taking the FNDDLTMP conc program. which purges the Inactive session data.

So in order to submit/schedule the above program follow the below procedure.

Login as SYSADMIN user:

Then :

Then search for “System Administrator Reports” and application as “Application Object Library”:

Then add the program that you want to run from the SYSADMIN user, here “Purge Inactive Sessions”

Go to bottom or where you like.

Then search for the desired program:

Now verify if you can see the request now in your responsibility: go to concurrent requests and submit the program to run.

Search for the request:

Submit it:

Now verify whether it deleted the data or not:

Before the Job ran:

After the execution of the program.