OBIA796 AR Balance Report-Aging Report is not showing data
Last updated on JANUARY 31, 2017
Applies to:Business Intelligence Applications Consumer - Version 126.96.36.199 [AN 1900] and later
Information in this document applies to any platform.
OBIA 188.8.131.52 (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