Subject Area 'Financials - AR Aging' to be included under data validation tool in FAW(FDI)

User_TJ9RH

In FAW(FDI) Data Validation Tool, we don't have any option to validate the metrics present under 'Financials - AR Aging' subject area. We are unable to properly establish that the source data(Fusion OTBI) matches with the data present in the 'Financials - AR Aging' subject area. It would be helpful if the subject area is included with the others as currently we don't have any method to completely validate the total data for the metrics.

Shobana Kapyarath-Oracle

ReceivablesAgingByGLAccountReport_v1.pdf

Data Validation currently validates FDI data with OTBI. For the AR Aging subject area, we do not have an equivalent subject area in OTBI that we can use to create Data Validation.

The AR Aging subject area has snapshots by fiscal month end, and the activities included are based on the accounting date. The equivalent report in Fusion would be "Receivables Aging by General Ledger Account Report." This can be run from the Schedule Processes in Fusion.

For Receipts at Risk, the Risk Indicator identifies Receipts at Risk and the Risk amount shows the Receipt amount at Risk. FDI Aging does not age the Risk Receipts by GL Account.

Currently, On Account and Unapplied receipts are combined and aged with Unapplied accounts.