Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
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

in General Ledger & Intercompany 4 comments

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 .

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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