I need Begin balance of some specific account. like begining_balance, Total_db,Total_cr, begining_balance+Total_db. I am not getting data of Begining_balance from GL_BALANCES.
Are you using a standard report in oracle gl or do you want to query directly on the database.
I have a query for you if you want to check if there is indeed an amount stored in the database for the ccid.