Unable to find an Output Post Processor service to post-process request

Unable to find an Output Post Processor service to post-process request

Error:

Concurrent Requests fail during Post Processing with the following errors:

'Unable to find an Output Post Processor service to post-process request 123456.

Check that the Output Post Processor service is running'

Solution:

1. Find the active processes for OPP:

SELECT fcp.concurrent_process_id

FROM fnd_concurrent_queues fcq, fnd_concurrent_processes fcp

WHERE fcq.manager_type in (select service_id from FND_CP_SERVICES WHERE service_handle='FNDOPP')

AND fcq.concurrent_queue_id = fcp.concurrent_queue_id

AND fcq.application_id = fcp.queue_application_id

AND fcp.process_status_code = 'A';

Output example:

CONCURRENT_PROCESS_ID

---------------------

83557

83558

2. Find the OPP subscribers:

select name from APPLSYS.AQ$FND_CP_GSM_OPP_AQTBL_S;

The name in the table is the concurrent_process_id prefixed with 'OPP'.

The output should normally correspond to the output of first query: have the same number of records and have as name the concurrent_process_id of the running OPP processes prefixed by OPP

Output example:

NAME

------------------------------

OPP83558

OPP83557

OPP88933

OPP92625

3. If there are extra subscribers which are left from previous runs of OPP processes, unsubscribe them via the following command:

  exec fnd_cp_opp_ipc.unsubscribe('<concurrent_process_id>');

 Example:

  exec fnd_cp_opp_ipc.unsubscribe('88933');

  exec fnd_cp_opp_ipc.unsubscribe('92625');

4. Retest some concurrent requests 

If you like please follow and comment