While implementing projects with big clients we often get huge volume of data for conversion in Fusion using FBDI.
We will take example of AR invoice Data conversion.
If we look at the Oracle FBDI template then, we will see that to import the data " Import AutoInvoice" job is mentioned.
If we have data volume of 40-50k then this process would complete in about 15-20 mins.
But if we have data in Lacs(For example 2lacs) then below are some of the possible options to load the data in Fusion:
- Break the data into different file with smaller sets of records and load.
- Use "Import Receivables Transactions Using AutoInvoice" Master program
We will see how to use "Import Receivables Transactions Using AutoInvoice" program and how it works.
When we run "Import AutoInvoice" program directly then only one worker/resource is assigned.
For large volume of data it would cause performance issues, it would keep on running for hours to complete or sometimes it would result in error with message "“ORA-01555:
snapshot too old: rollback segment number 47 with name
"_SYSSMU47_1753382011$" too small”
So to avoid that and speed up the process to complete quickly even for large volume Oracle has provided functionality to add more workers through "Import Receivables Transactions Using AutoInvoice" master program.
When we submit this program with multiple workers(for ex 5 workers/resource) then Oracle splits the data from interface table( Suppose count of records is 1 lac) into 5 parts (20k each) and spawns 5 different instances of "Import AutoInvoice" under "Import Receivables Transactions Using AutoInvoice" parent program.
We will take another example when there are 10 records in interface table and if we assign 15 workers then Oracle program would split data from interface table into 10 parts and would spawn only 10 instances , hence 5 resources/worker will be freed up.
Now we will see example of running this job in Detail.
- Load the data to interface table
Follow the below screenshots to load data into interface table for AR Invoice
Login to Oracle Fusion application -> Navigator -> Scheduled Processes -> Schedule New Process
Search for "Load Interface File for Import" and click ok
Now in the next window search and select "Import AutoInvoice" and browse the data file from loacl system or use the file which is already uploaded in UCM.
here e will browse from local system.
After this click on Submit and close he window.
After the Load to interface program Succeeds. we need to search and Run the Autoinvoice Master program.
- Run Autoinvoice Master Program
Search for "Import Receivables Transactions Using AutoInvoice" and click on "Ok"
Provide the Parameters. Here we have assigned 15 Workers/Resource. After Providing the Parameter Click on Submit and close the window.
Now select the "Hierarchy" View.
In the below screenshots we can see that the Parent Job has spawned 15 instances of "Import AutoInvoice" jobs.
Every instance of "Import AutoInvoice" will have its own execution report.
So using the "Import Receivables Transactions Using AutoInvoice" master program with multiple workers we can speed up our AR Invoice Data conversion and save lot of time.
We can use this in Integrations as well when the integration is having huge volume. we will discuss about how to use this program in AutoInvoice integration in another Post.
