My Oracle Support Banner

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.

Symptoms

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

Cause

To view full details, 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 a vibrant support community of peers and Oracle experts.