OPP unsubscribe

 

 

Part 1:  - Please find the troubleshooting/solution for resolving the issues specific to OPP. Please find the symptoms, troubleshooting and solution for resolving the OPP issues.

 

 

1.     Gather the concurrent target processes ID’s

SELECT fcp.concurrent_process_id

FROM apps.fnd_concurrent_queues fcq, apps.fnd_concurrent_processes fcp

WHERE concurrent_queue_name = 'FNDCPOPP'

AND fcq.concurrent_queue_id = fcp.concurrent_queue_id

AND fcq.application_id = fcp.queue_application_id

AND fcp.process_status_code = 'A'

 

 

2.     Validate the concurrent target processes ID’s from the queue

select name

from applsys.AQ$FND_CP_GSM_OPP_AQTBL_S

order by name

 

Solution:

If there is any discrepancy between the rows, we need to unsubscribe the processes from the OPP queue. The right and active processes are from query#1.

 

exec fnd_cp_opp_ipc.unsubscribe(‘Concurrent target processes ID’);

 

exec fnd_cp_opp_ipc.unsubscribe(‘824721’);

 

exec fnd_cp_opp_ipc.unsubscribe(‘824722’);