Autoinvoice Mater Program Does not spawn Import Program

There could be various reasons why Autoinvoice Master Program does not spawn Autoinvoice Import program, I have listed down all of them below.

1. Order number doesnt exist in ra_interface_lines_all.

2. Batch source name passed in the Autoinvoice Master Program Doesnt belong to the order you are expecting to be invoiced.

3. If the above points are ok then Check the request_id column in ra_interface_lines_All and if its not NULL then query the request_id in fnd_concurrent_Requests.

Query :-

Select * from fnd_concurrent_requests
where request_id = :p_request_id;

Check the stats of concurrent request. If its running then ok if its cancelled or terminated then you need to Nullify the request_id from ra_interface_lines_all and run the Autoinvoice master Program again.

For more about concurrent request status check this link:-
https://oracleapplicationstechfunc.blogspot.in/2017/03/status-code-and-phase-code-in.html


4. Check the parameters passed are correct in Autoinvoice Master Program.