My Oracle Support Banner

E1: 03B: FAQ- Frequently Asked Questions about AR Statistical History (R03B16, R03B16A, R03B161, R03B163) (Doc ID 664021.1)

Last updated on SEPTEMBER 24, 2020

Applies to:

JD Edwards EnterpriseOne Accounts Receivable - Version XE and later
Information in this document applies to any platform.

Purpose

This document provides answers to frequently asked questions about AR Statistical History (R03B16(A)).

Questions and Answers

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Purpose
Questions and Answers
 General Questions
 Question 1. Why are there only two records in the F03B16 table for Address Number 00000000, after the Statistics History Update (R03B16(A)) is run?
 Question 2: Why is the Statistics History Update not updating information for specific customers?
 Question 3. Why does the Statistics History Update take so long to run?
 Question 4. Can data selection be used for the Statistics History Update (R03B16(A))?
 Question 5. How does the 'Number of Days to Balance' processing option work, and what happens when the number is exceeded?
 Question 6. Why is the Days Sales Outstanding (DSO) field not updated correctly, when Stats History Refresh (R03B16(A)) is run?
 Question 7: How can the F03B16 and F03B16S statistical tables be rebuilt/refreshed; for an example going back 5 years of data with current year = 2013?
 Question 8. Why have the stats in the Account Balance Inquiry (P03B218), on form 'Periodic Statistics' not been updated since we did our year end?
 Question 9: If the Statistical History Refresh (R03B16(A)) has not been run since, for example 2008, would the Statistics Annual Close program (R03B161) need to be run multiple times, once for each fiscal year?  Is there a sequence of events to correct the data?
 Question 10: Is it possible to run Statistical History report R03B16A by company CO or KCO?
 Question 11: Is it possible to change the processing options of Stats History Refresh (R03B16A)? I have heard that it is recommended not to change them. Would you please clarify why? 
 Question 12: In which currency are values shown in the A/R History (F03B16) and A/R History Summary (F03B16S) tables?
 Question 13: The second processing option on the Summary Record tab of Statistical History Refresh (R03B16A)’s processing options is set to the last date of our current fiscal year for the R03B16A version we run daily. For the new fiscal year it needs to be set to the last date of this new fiscal year. Should we change the current version or create a new one from scratch?
 Question 14: Why is it not recommended to use data selection when running Stats History Refresh (R03B16A)? Does the UBE not read it?
 Question 16: What are the criteria used by Stats History Refresh (R03B16A) to update or group the records in the A/R Statistical Summary (F03B16S) table based on the records in the A/R Statistical History (F03B16) table?
 Question 17: Does Stats History Refresh (R03B16A) include nonstandard invoice document types in its calculations?
 Question 18: Why is the R03B16A running for extended time without giving any errors?
 Question 19: What might cause the R03B16A to run for a much longer time than it has in the past, ultimately erroring out with memory allocation failure errors shown in the jde.log?
 Calculations
 Question 1. How and when is the Ending Balance (ENBL) field calculated?
 Question 2. We currently use the Avg Sales method. If we change to Count back, will the system automatically recalculate the DSO statistic for previous periods as well using the count back method? If not automatically, if we run Statistic History update, will that change historical DSO information based on new calculation method?
 Question 3. How is the Customer Master by Line of Business (F03012) ''Average Days Late' (AVD) calculated?
 Question 4. How are the fields 'Weighted Average Days Late' and 'Percent of Amt Paid Late' calculated?
 Question 5. What is the difference between Average Days Late (AVD) and Weighted Average Days Late (AVDL), and how do these get calculated?
 Question 6: How is the High Balance (AHB) calculated?
 Question 7: Why isn't the R03B16A calculating any fields for any of the customers on a new install with newly created data?
 Question 8: Why does the calculated High Balance appear to only be for each particular period and not for all open records from previous periods?
 Question 9: How is the value for the Days Sales Outstanding (DSO) field calculated in the A/R Statistical History Table (F03B16) using the Average Balance Method?
 Question 10: How is the value for the Best DSO (BDSO) field calculated in the A/R Statistical History Table (F03B16) using the Average Balance Method?
 Question 11: How is the value for the Delinquent DSO (DDSO) field calculated in the A/R Statistical History Table (F03B16)?
 Question 12: How is the Delinquent Balance (DLBL) field calculated in the A/R Statistical History Table (F03B16) / displayed in the Periodic Statistics application (P03B16)?
 Purge
 Question 1. How can I manually purge statistical history data?
References

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