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 7.9.6.3 [AN 1900] and later
Information in this document applies to any platform.

Symptoms

OBIA 7.9.6.3 (this uses informatica for ETL loads).
OBIEE 11.1.1.7.131017

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.

Cause

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