Customer Statements Contain Incorrect Data When Run for a Complete Cycle - (Doc ID 1528872.1)

Last updated on MAY 19, 2016

Applies to:

Oracle Receivables - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

Attempting to run the standard Customer Statement Generation process for a complete cycle (No Customer Name range or Customer Number range used) and the system produces a large number of incorrect data.

The incorrect transactions may need to be on a customer's statement, but are showing on the WRONG statement.

Transactions are also appearing on more than one statement in the same run.

As each Transaction can only have a single CUST_TRX_ID, this is clearly incorrect.

1. Certain customers not getting any statements, when they have outstanding non-disputed transactions;
2. Certain customers are showing incorrect statements (with different figures in two Statement runs, despite data not having changed)

Cause

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 hundreds of Community platforms