Orphan Records In Payment Tables - CN_PAYMENT_WORKSHEETS_ALL and CN_PAYMENT_TRANSACTIONS_ALL
(Doc ID 952080.1)
Last updated on MARCH 01, 2021
Applies to:Oracle Incentive Compensation - Version 12.1.0 and later
Information in this document applies to any platform.
The tables CN_PAYMENT_WORKSHEETS_ALL and CN_PAYMENT_TRANSACTIONS_ALL have some additional records which is not in sync with the table CN_PAYRUNS_ALL
The issue can be reproduced at will with the following steps:
1) Create a payment batch. Choose All resources in the pay group
2) Click on apply. A concurrent request is created.
3) Wait for concurrent request to start running
4) Before the request completes. Delete the payment batch
5) Orphan records will be created
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!