My Oracle Support Banner

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:

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


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.

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

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


To view full details, sign in with your My Oracle Support account.

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

In this Document

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