Requests stuck in Pending Standby

Posted by VinodN on Apr 18, 2024; 2:07pm
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/Requests-stuck-in-Pending-Standby-tp12435.html

Hi Erman,

Faced a weird problem yesterday. In a test instance a user's requests were going into Pending Standby. Also, at the same time the requests were seen in Standard Manager, Custom Mgr (which we had created) and CRM queue in the Administer form.

I found this note - Concurrent Requests Stuck In Pending Status In Conflict Resolution Manager (Doc ID 2604091.1) and executed the query from it:

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='Program Name'))
and
(s.to_run_concurrent_program_id in (select concurrent_program_id from fnd_concurrent_programs_tl where user_concurrent_program_name='Program Name'))
and s.running_concurrent_program_id=p.concurrent_program_id)
and phase_code <> 'C';

The query returned 3 rows. One of them was our user's request and other two were requets from Nov 2023. I updated their status to completed and immediately the user's request ran and completed.
Could you please help me understand what happened here?