Parent and child concurrent request ...Chlld program goes into Inactive and No manager state
I have a concurrent program which is a pl/sql Stored procedure and this file internally calls another concurrent program (Oracle report program) using FND_Submit.request. The child report program has over 10 reports.When i run the parent program,the parent(pl/sql) program goes into Running and Normal and the child program (report program), goes into Inactive and No Manager state.
I have given the child program to be submitted using the below code:
v_request_id := fnd_request.submit_request (application => v_prg_app_name,
program => v_report_name,
description => 'Child requests for OU Setup Report',
start_time => NULL,
0