Fusion Compensation: DynamicCalculation ESS After Plan Start Or Refresh Should Be Sub-Requests (Doc ID 1988005.1)

Last updated on MARCH 11, 2015

Applies to:

Oracle Fusion Compensation - Version 11.1.7.0.0 and later
Oracle Fusion Workforce Compensation Cloud Service - Version 11.1.7.0.0 and later
Information in this document applies to any platform.

Goal

Dynamic Calculation ESS after Plan Start or Refresh Should be Sub-Requests

We are using Workforce Compensation with 8 plans in production. These plans are refreshed every day to keep the plan data in sync with Core HR. The refresh process consists of multiple steps as per our business process. The key steps are:

1. Run the start plan process to bring newly eligible employees each day
2. Run the Refresh process as of the "Process Run Date" to refresh eligibility as some people can become ineligible due to HR actions
3. Run the Refresh process one more time as of the "Plan Cycle Dates" to refresh Core HR data

We want to create a JOB SET to sequence these in order and guarantee that they never run in parallel. However, we find that each of these steps spawns multiple Dynamic Calculation processes. The main step shows completed with "Succeeded" status even though the Dynamic Calculation is still running.

This causes the job set to start the next process creating and then the jobs overrun each other causing data corruption. We want the next step to be start only after all sub-requests of the first step are also completed.

Even in the Monitor Batch Processes UI, it is not possible to see the master process for each of the Dynamic Calculations. So we cannot even determine manually when a step is entirely complete.
 

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms