OBIA 7.9.6.4 Financial Analytics Is Not Loading Day Wise Balances In W_GL_Balance_F (Doc ID 1992094.1)

Last updated on AUGUST 09, 2016

Applies to:

Business Intelligence Applications Consumer - Version 7.9.6.4 and later
Information in this document applies to any platform.

Goal

It is observed that we have month end balances stored in W_GL_Balance_F. When we join W_MCAL_DAY_D table with balance_dt_wid of W_GL_Balance_F you can only see the balances of the last day of the month.
Why it is not showing loading day wise balances in the table ? Is there any other table available in the Database to view day wise balances?
 

Solution

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