X

An Oracle blog about Oracle Integration Cloud(OIC)

  • January 28, 2019

Oracle Integration and ERP Cloud - How to get Job Name and Parameters of ERP Bulk Import Jobs

Introduction

Oracle Enterprise Resource Planning (ERP) Cloud provides a comprehensive set of modern cloud tools and services for integrating with third party applications to cover various scenarios. One of the patterns is the bulk import integration (also known as File-Based Data Integration - FBDI) to load data into the ERP cloud.

The bulk import is a powerful tool for loading data from any source into Oracle ERP Cloud.  It supports one-time data migration and incremental load for replacing legacy ERP or hybrid solution with external applications. Please refer to this for more information on ERP Bulk Imports.

This post focuses on how to generate a property (or manifest) file that requires job package and name including list of job parameters when submitting respective bulk import job. In Oracle Integration (OI), please use the ERP Adapter (out-of-the-box simplified) feature to implement bulk import that automates the uploading of data/property zip file to Content Manager (UCM) followed by invoking ERP Integration service. For callback implementation, please refer to this blog. 

 

Import Job Property File Format

The property file submitted with importBulkData operation includes the job definition and package names as well as the job parameters of the object being imported. You must generate and add the Job Properties File as part of the data ZIP file.

The job property file is in CSV format as follows:

<job package name>,<job definition name>, <ZIP file prefix>,<Param1>,....<ParamN>

The name could be anything, but the extension must be ".properties". 

Please refer "How to get Job Package and Name" section to derive package and definition name of the import job. The third column (ZIP File Prefix) is the name of the zip file that contains the data file. The fourth to N columns are lists of parameters that are required to load and import the data into ERP Cloud.

Example:

Your zip file name is GL_BU_ABC_12345678.zip and contains GlInterface.csv and jobDetails.properties. The value of the third column in jobDetails.properties could be  GL_BU_ABC.

 

How to get Job Package and Name

From Fusion Apps main page,

  1. Click the Navigator, and then click Setup and Maintenance.
  2. On the Setup page, select your setup offering such as Financials

Click on right icon as shown above to search for "Manage Enterprise Scheduler Job Definition and Job Sets for Financial, Supply Chain Management and Related Applications":

Select and Click "Manage Enterprise Scheduler Job Definition and Job Sets for Financial, Supply Chain Management and Related Applications" and search for "%Journal%" as shown below:

Select "Import Journals" row and click edit (please do not change anything as our goal is to get job package and name):

From above image, the job package is the PATH and job name is the NAME. These will be the first two columns in your property file for "Import Journals" with third column the sample prefix name of the zip file as suggested earlier: 

oracle/apps/ess/financials/generalLedger/programs/common/,JournalImportLauncher,GL_BU_ABC, <list of parameter separated by comma>

 

How to get list of parameters

Once we have job package and name, the next step is to determine the list of parameters for "Import Journals" job. Please follow these instructions:

From Fusion Apps main page,

  1. Click the Navigator, and then click Scheduled Processes in Tools.

  2. Click on "Schedule New Process" button and search (and select) for "Import Journals". It will display the list of parameters as shown below:

 

Final content in .properties file

/oracle/apps/ess/financials/generalLedger/programs/common/,JournalImportLauncher,GL_BU_ABC,<Data Access Set>,<source>,<Ledger>,<Group ID>,<Post Account Errors to Suspense>,<Create Summary Journals>,<Import Decriptive Flexfields>

Example: /oracle/apps/ess/financials/generalLedger/programs/common/,JournalImportLauncher,GL_BU_ABC,1061,Balance Transfer,1,ALL,Y,Y,N

 

Another Sample - Import Payables Invoices

Be the first to comment

Comments ( 0 )
Please enter your name.Please provide a valid email address.Please enter a comment.CAPTCHA challenge response provided was incorrect. Please try again.