Table to get Natural Account segment hierarchy in Oracle Fusion
Looking for Table to get Natural Account segment hierarchy in Oracle Fusion
I am trying to retrieve GL balances using SQL query in data model by natural account segment per period.
To get the natural account hierarchy I tried using following records but cannot get the data as required/expected( ex: to get balance where natural account segment level 22 is 'ASSETS')
In FAW DW_NATURAL_ACCOUNT_DH gives account hierarchy information , Do we have similar table in Oracle Finance ERP , or any alternative approch create sql to get balance by account .