Re: Pending OPP issue with custom program

Posted by ErmanArslansOracleBlog on Oct 10, 2023; 9:37am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/Pending-OPP-issue-with-custom-program-tp12083p12096.html

Hi,

1)Send me the OPP logfile

2)Send me a screenshot of those conc request. I need to see the phase and status of them.

3)Send me the output of the following query:
 SELECT service_id, service_handle, developer_parameters
                       FROM fnd_cp_services
                  WHERE service_id = (SELECT manager_type
                                                          FROM fnd_concurrent_queues
                                                   WHERE concurrent_queue_name = 'FNDCPOPP');

4)What is the Actual and Target count of OPP processes? - at any given time and at the problematic time.

5)Are there any conflicting requests in the confict resolution manager's queue during the problematic time interval?

Any blocking request that you can find using the below query;
select * from fnd_concurrent_requests where concurrent_program_id in
(SELECT p.concurrent_program_id FROM FND_CONCURRENT_PROGRAM_SERIAL s, fnd_concurrent_programs_tl p WHERE
(s.to_run_application_id in (select application_id from fnd_concurrent_programs_tl where user_concurrent_program_name='<Your Program Name>'))
and
(s.to_run_concurrent_program_id in (select concurrent_program_id from fnd_concurrent_programs_tl where user_concurrent_program_name='<Your Program Name>'))
and s.running_concurrent_program_id=p.concurrent_program_id)
and phase_code <> 'C';

6).Using the conc request form.. View the details of the pending request and Click Diagnostics button. What do you see as the diag message?