You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Table to get Natural Account segment hierarchy in Oracle Fusion

Summary:

Looking for Table to get Natural Account segment hierarchy in Oracle Fusion

Content (required):

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')

GL_SEG_VAL_HIERARCHIES

fnd_tree_node G

GL_SEG_VAL_HIER_RF


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 .

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!