E1: 03B: Incorrect Last Invoice Date (DLIJ) and Date Last Paid (DLP) Calculated by A/R Statistical History (R03B16A) (Doc ID 3033476.1)

Last updated on NOVEMBER 27, 2024

Applies to:

Symptoms

The Last Invoice Date (DLIJ) and Date Last Paid (DLP) are miscalculated by R03B16A. After running the A/R Statistical History Purge/Repost (R03B163) and the A/R Statistical History Refresh (R03B16A) to re-calculate the DLIJ and DLP are not correct.

Steps:

1. One customer was found where the R03B16A calculated incorrect Last Invoice Date (DLIJ) and Date Last Paid (DLP). The error was verified by checking Customer Master (P03013) -> Additional Customer Information against Customer Ledger Inquiry (P03B2002) for Posted transactions and Receipts Inquiry (P03B102).
2. Run the A/R Statistical History Purge/Repost (R03B163) for an interval that includes the transactions and then re-run the A/R Statistical History Refresh (R03B16A) to re-calculate the AR statistics.
3. Notice the issue is still there after running R03B16A.
4. The same issue can be observed in the Credit Check (P42050).
   

Upon further research it was discovered that the Customer Master Last Invoice Date (DLIJ) and Date Last Paid (DLP) were not updated properly because they had values further into the future than existing transactions.

Changes

Cause

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