Understanding .properties file for ERP Bulk Import Jobs in Oracle Integration Cloud (OIC)

 

In this post, we will understand how to import FBDI files using OIC and how to create .properties file for the process.

• To import FBDI file using OIC we need two files: 
• FBDI zip file
• .properties file
• While working with ERP Adapter in OIC, we select the below option to Import FBDI in Oracle Fusion Cloud.

• Then we select the Bulk Import Process name

Here we selected Import Journals process. Make a note of Import Job Name and Package Name.

/oracle/apps/ess/financials/generalLedger/programs/common, JournalImportLauncher

• Now to create .properties we need to create a file with below details:

<Job Package Name>,<Import Job Definition Name>, <ZIP file prefix>,<Param1>,....<ParamN>

Now to get param details for Import Journals we follow the below steps:

• Go to Setup and Maintenance. Search for Manage Enterprise Job...

Click to Open Manage Enterprise Scheduler Job Definition and Job Sets for Financial, Supply Chain Management and Related Applications

• Search with Import Job Name and click on the Edit button.

• In User Properties, numberOfArgs shows the total number of arguments for this job

• Parameters tab shows all parameters

• Now we scheduled Processes we will get to know the parameter names and their sequence. We need to analyze these three details to get the exact sequence of parameters to be used. Now we know that there are 7 parameters and the below can be the sequence of those parameters. Sometimes we need to check the previous runs of the job to know the parameters, as there are cases in which parameters are not visible in the Scheduled Processes screen as those are hidden by default: 

• So, looking at this information we can construct the .properties file with the below comma-separated values

Related Posts:

Properties file for Import Journals, Import Payables Invoices, Import Requisitions