E1: 03B: Incorrect Values Updated In F03012 When A/R Statistical History (R03B16A) Is Run (Doc ID 3027596.1)

Last updated on JUNE 07, 2024

Applies to:

Symptoms

When A/R Statistical History Refresh (R03B16A) is executed certain values are updated incorrectly in Customer Master Line of Business (F03012).
Example :"Last Invoice date","Invoiced This Year" "Last Applied Amount" etc.

Steps:

1.  Activate Line of Business in AR Constants.
2.  Create two customers.
3.  Enter one invoice for customer 1 using Customer Ledger Inquiry (P03B2022).
4.  Save it
5.  Post it Using GL Posting (R09801).
6.  Enter an invoice for customer 2 using Customer Ledger Inquiry (P03B2022).
7.  Save it
8.  Post it Using GL Posting (R09801).
9.  Now Run A/R Statistical History Refresh(R03B16A).
10. Now advance the FY in Work With Credit/Collection Date Patterns(P03208 as shown below to FY-25.
11. Now enter one invoice for customer one Using Customer Ledger Inquiry (P03B2022) in FY-25
12. Post it Using GL Posting (R09801).
13. Now Run A/R Statistical History Refresh(R03B16A).

Note: There is no Invoice entered for Second customer in FY-25

Cause

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