CN_TP_PAYSHEETS_ALL Table Is Not Removing Records Related To Deleted Plan Components (Doc ID 2978116.1)

Last updated on OCTOBER 02, 2023

Applies to:

Symptoms

Paysheet shows payment amounts for delete plan components.
The compensation plan was updated recently to update calculation logic.
New plan components were created and replaced old components with these new components.
After running calculation, user can see that the CN_TP_PAYSHEETS_ALL has payment records from the new component as well as the old component which was removed from the plan.
This is causing the wrong "Paid Amount" to show in custom statement report, which is higher than what was actually paid, and in turn showing the participants owe money.


EXPECTED BEHAVIOR
There should be no transactions to be these delete plan components to show in the paysheets.

STEPS
The issue can be reproduced at will with the following steps:
1. Calculate commission
2. Create paysheets on 2023-07-24 16:24:00
3. Remove the plan components from the comp plans, replace with the new plan components, deploy on 2023-07-29 04:37:52
4. Rerun calculation
5. Refresh paysheet on 2023-07-29 14:55:16 and see the new plan components ... and see the old plan components on the paysheet

Cause

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