About Me

Software engineer Technical Consultant Passion for writing editorials. Part time blogging. Journalism My Book Dreams

Friday, November 16, 2012

Actuals and Budgets in the GL_BALANCES table.

Dt :17 Nov 2012

The Oracle EBS table stores the actuals and budgets amounts.Any given record in the GL_BALANCES table is classsifed as either a budget or an Actual by the ACTUAL_FLAG column .

The ACTUAL FLAG column has two values 'A' for actuals and 'B' for budgets.This flag has been exploited in the Oracle warehouse to divide the actuals and budgets into two differenet tables.

So in case you are using the OLAP table W_GL_BALANCE_F  table(assuming that its a replica of GL_BALANCES table ) to get a OBIEE report out and you are expecting to get both the budgets and the actuals information from this table then you may be in for a surprise.
Coz the budgets are not available in the W_GL_BALANCE_F table.This can be verified using the BALANCE_TYPE flag in this table.

You will have to either modify the prebuilt  Informatica map to get budgets information into this table
or the other option that you have is to use the budgets data filtered into the W_ACCT_BUDGET_F table.

Hope this piece of info suits you well for your Finance reports.

Happy reporting :-)

10 comments:

Popular Posts