Child Concurrent Request goes to Inactive/No Manager
Hi,
Oracle EBS R12.1.3 and DB 11.2.0.4
Child Request goes into Inactive / No manager state while launching a child request from parent concurrent request
using FND_REQUEST.SUBMIT_REQUEST with clause sub_request => TRUE .
Below command I am used to fire the concurrent request thru PL/SQL stored Procedure.
l_request_id := FND_REQUEST.SUBMIT_REQUEST
(
application => 'QP',
program => 'QPXVBLK',
description => 'ELECON/BENZLERS BULK IMPORT PRICE LIST',
start_time => SYSDATE,
sub_request => TRUE,
argument1 => 'PRL', -- Entity
argument2 => l_pri_list_name , -- Entity Name
argument3 => NULL, -- Process ID
argument4 => NULL, -- Process Type
argument5 => NULL, -- Processed Parent
argument6 => 1, -- No of Threads