Tuesday, May 11, 2021

OIC - ERP - How to get the Job parameters for bulk import job

There are two ways to see the job 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:

Way 1:

Steps:

  • From Fusion Apps main page, Click the Navigator, and others then click Setup and Maintenance.
  • 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 "%Invoice%" in display name.
  • Select "Import Payables Invoices" row and click edit (please do not change anything as our goal is to get job package and name):
  • From user properties tab, we can see the number of arguments to send. And from paramters tab we can see the parameters. For example imvoice, it has 14 arguments so send 1st 14 params as mentioned in the parameters tab.
Steps with screenshots:










Way 2:

Steps:

  • From Fusion Apps main page, Click the Navigator, and then click Scheduled Processes in Tools.
  • Click on "Schedule New Process" button and search (and select) for "Import Journals". It will display the list of parameters as shown below:

Steps with Screenshots:






Few Instances of content  of .properties file

Journal Import Launcher:

/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

Import Payables Invoices:

<ATTIBUTE1><ATTRIBUTE2><ATTRIBUTE3><AccountingDate><Hold><Hold Reason><ATTRIBUTE7><Source><Import Set><Purge><SUmmarize Report><ATTIBUTE12><Invoice Group><Number of parallel processes>

Default value:

<><><N><><><><1000><><><><><><><1>

#NULL,$BusinesUnitId,N,#NULL,#NULL,#NULL,1000, Source,#NULL,N,N,LedgerId,#NULL,1

Note: Check User properties tab to know the number of parameters to be sent via bulk import. for Import Payables Invoices it is showing 14 parameters.

No comments:

Post a Comment

Featured Post

OIC - "Dynamically Configuring Relative URLs for REST API Invocations in Oracle Integration Cloud" | Dynamically invoke local integration

Use Case: In Oracle Integration Cloud (OIC), there is often a need to dynamically determine the Relative URI while invoking REST APIs. This ...