Submitting Autoinvoice from PL/SQL Procedure using fnd_request.submit_request hangs - FND_CONCURRENT
Submitting Autoinvoice from PL/SQL Procedure using fnd_request.submit_request hangs - Phase_Code=P, Status_Code=Q/Z
Using following script to invoke Autoinvoice from PL/SQL Procedure but Concurrent Manager appears to place request to Pending Waiting Status per FND_CONCURRENT_REQUESTS table. What is causing the request to go to Pending Waiting Status? Cannot check the generated request id from View Request screen but FND_CONCURRENT_REQUESTS table is populated with Phase_Code=P (Pending) , Status_Code=Q/Z (Standby/Waiting).
DECLARE
l_system_date DATE;
l_req_id3 NUMBER;
BEGIN
-- 1) Set the applications context
Using following script to invoke Autoinvoice from PL/SQL Procedure but Concurrent Manager appears to place request to Pending Waiting Status per FND_CONCURRENT_REQUESTS table. What is causing the request to go to Pending Waiting Status? Cannot check the generated request id from View Request screen but FND_CONCURRENT_REQUESTS table is populated with Phase_Code=P (Pending) , Status_Code=Q/Z (Standby/Waiting).
DECLARE
l_system_date DATE;
l_req_id3 NUMBER;
BEGIN
-- 1) Set the applications context
1