Child Concurrent Program Goes To Inactive / No Manager Mode
Hi All,
I'm facing a problem, googled a lot but didnt get the required answer.
Issue:
- Created 2 concurrent program of PL/SQL type executable.
- Assigned both to a responsibility.
- Assigned both to Standard Manager.
- Submitted Parent concurrent program from SRS window.
- Parent program submitted child program ( 2 in number).
- Parent program gets in to Running mode and fires two child programs.
- The above fired 2 child programs remain in Inactive / No Manager Mode for days, never completes.
- If I submit child program as parent program from SRS window it completes normally.
Parent program partial code:
FOR r_cust IN c_cust
LOOP
0