Calculation Processing for Previous Periods When There Are No New Transactions Or Adjustments Is Recreating New EARNING_ID (Doc ID 2921801.1)

Last updated on JUNE 21, 2024

Applies to:

Symptoms

With Intelligent mode for Calculation,  when reprocessing for prior periods and there's no new transactions or adjustments to be processed , user is expecting that the calculation records are not recreated ( ie. new EARNING_ID value ). This will cause a lot of reversing entries to be pick up by Paysheet creation or refresh.

Noticed when user extend the end-dates of the performance measures ( ie.  from 12/31/2022 to 12/31/2023 ) and calculation was resubmitted for December 2022, the earning_ids were regenerated.  This is causing lots of extra records to be created and picked up by payment process.

STEPS
1. Calculate commission for December 2022 period
2. Create payment batch for DEC-22 period and pay
3. Extend the [ End Date ] to 31-DEC-2023 on a performance measure that is associated to multiple plan components. Each of these plan components assigned to different comp plan.
4. Run Deploy Compensation Plan
5. Rerun Calculation for DEC-22
6. Create payment batch for JAN-23 period and see the reversing entries for commission in DEC-22.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.