Thursday, September 23, 2021

How to create ESS Job Set in Oracle Fusion

We've seen the definition and structure of a custom ESS Job in Oracle Fusion here

Now let's see how to create a job set comprising of multiple ESS jobs.

ESS Job Set is useful when there's a need to run multiple ESS jobs for any activity (in sequence or parallel) in Oracle Cloud. Basically, the traditional Concurrent Request Set from EBS has been replaced with an ESS Job Set in Oracle ERP Cloud. 

Let's see how to define an ESS Job Set.

Below example will create a job set which will run two HCM jobs shown below. Read Only initial parameter values come from the job set but  non-read only parameters come from the job definition.

1. Identify the jobs to be included in ESS Job Set -
    a. Generate Cloud Usage Metrics (seeded job)
    b. XX HCM Job (custom job)

2. Run these jobs individually. This will ensure that the jobs are running without issues and users will be able to collect  runtime information about the ESS jobs.

3. Create Job Set

- Navigate to the product specific task. In this example "Manage Custom Enterprise Scheduler Jobs for HCM Core Processes"

- Click on Manage Job Sets tab.

- Enter the new job set details.

- Press on the Add Job Set Step button to add the first job details.

- Give a name for Step ID.

- Search for first Job. For example search by Name CloudMetricsNumberOfNamedUsers.

- Click on the Add Job Set Step button to add the second job details

- It should look like this -

- Under the System Properties add the SYS_effectiveApplication as the value of the application identified in the second SQL from Step 3. In this case EarHcmEss

- Save the Job Set


Friday, September 3, 2021

Default BU Specific Templates for Receivables Transactions in Oracle Fusion

Under Bill Presentment Architecture in ERP Cloud, we can create custom templates for AR Invoices, Debit Memos and Credit Memos. But what if we want BU specific templates for these receivables transactions 

We are going to take a look at the setups to default Business Unit specific Templates in Print Receivables Transactions.

- First, create custom templates in BI for each Business Unit

- Now, navigate to Task: 'Manage Standard Lookups'

    - Create Lookup type “ARBPA_SELECT_INV_TEMPLATE”

    - Module: Receivables

    - Create Lookup Code : <Business Unit Name>

    - Meaning: <Custom Template name>

    - Description: <Default Output format>

- Save and Close.

- Now, navigate to Scheduled Processes and select ESS Job: 'Print Receivables Transactions'

- Provide Business Unit Name in the parameter. You'll see that the corresponding Custom Template Name defined in the Lookup will appear in the parameter -