Spawn Multiple Autoinvoice Import Programs with Single Autoinvoice Master Program

If you want to spawn multiple autoinvoice import programs with only one Autoinvoice Master program then You need to setup the below profile.Spawn Multiple Autoinvoice Import Programs with Single Autoinvoice Master Program.


Profile name :- AR:Maximum lines per AutoInvoice worker

The value for this profile will be maximum number of lines will be processed by single import program. If the number goes beyond the profile value then new child request(Import) will be fired.

i.e.

No of lines in interface table :-  1000
Value setup for the Profile    :-    100

In the above case 10 Autoinvoice Import program will be triggered.

each will process 100 records from interface table.

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.