I have an unclear area on the General Ledger cube in APPS9. When we have an opening balance for any year it will insert under the 0th accounting period key. And If we want to take the value for the opening balance from the “Dm_FACT_GL_BALANCE” table we will have to use the 'BALANCE_OB' field instead of the 'BALANCE' field.
Assume we have an opening balance for a company in 2019, My question is when I need to get the GL balance for the 2019 year what is the measure I need to be used? It seems the balance measure gives the wrong value.
If you have any information regarding this matter please let me know.