You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Unable to fetch GL Budget Balances from GL_BALANCES table even though the documentation states it

Need to develop an Oracle BIP report to include the three types of GL Balances (Actual, Budget, Encumbrance).
Although Actual Balances are available in GL_BALANCES table with ACTUAL_FLAG='A', Budget Balances when loaded are not loaded to GL_BALANCES table. They are available in a separate table GL_BUDGET_BALANCES.
In the documentation for GL_BALANCES table, it shows that all three types of Balances will be stored in GL_BALANCES with ACTUAL_FLAGS as 'A', 'B', 'E'.

Kindly let me know if there is a process that Budget Balances can be moved to the GL_BALANCES table or they stay there in its entirety?

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!