Beginning Balances for a few Entities (Segment1 from GL) is not there in FA_BALANCES_EXTRACT Table
Beginning Balances for a few Entities (Segment1 from GL_CODE_COMBINATIONS) is not there in FA_BALANCES_EXTRACT Table when we filter on basis on those entities we aren't able to get Beginning Balance for those Entities for different account types like 'Depriciation Reserve','Cost Accounts','Expense Accounts'
we are devloping a report that is FA to GL Reconciliation Report in that for FA Cost we are using FA_BALANCES_EXTRACT to get the Beginning Balance of Each period also we have a parameter of Entities (Segment1 from GL_CODE_COMBINATIONS) , But for books where we have accounts having multiple Entities linked to it , all the Beginning Balance is flowing to only one entity that is '1111' in FA_BALANCES_EXTRACT and Code_Combination_Id for the Accounts having entities other than '1111' aren't Existing in FA_BALANCES_EXTRACTS where source_distribution_type in ('BEGINNING_BALANCE') as we need to fetch beginning balance for each one of the Entity