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?
Tagged:
0