OBIA796 AR Balance Report-Aging Report is not showing data

(Doc ID 1996000.1)

Last updated on JANUARY 31, 2017

Applies to:

Business Intelligence Applications Consumer - Version [AN 1900] and later
Information in this document applies to any platform.


OBIA (this uses informatica for ETL loads).

In the Dashboard for Financial Analytics:
Dashboard: Receivables Page:AR Balance Report: Aging Report.

when the query for the above report is comparing an entry in the W_DAY_D against the W_MCAL_QTR_D the query should be that the W_DAY_D entry is less than or equal to the W_MCAL_QTR_D.MCAL_QTR_END_DT_WID and greater than or equal to the W_MCAL_QTR_D.MCAL_QTR_START_DT_WID.
But the query has only the = and is missing the > part when doing the comparison to the W_MCAL_QTR_D.MCAL_QTR_END_DT_WID.
The end result is the query is checking if the W_DAY_D entry is equal to W_MCAL_QTR_D.MCAL_QTR_END_DT_WID and less than or equal to W_MCAL_QTR_D.MCAL_QTR_START_DT_WID
Because of this the report query is not returning the data. ( Note: In the query if we fix this the query itself returns data.


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