Your UX is waiting ...interact, engage, explore in Las Vegas at CloudWorld 2023

Learn more
Need help on a query with Account hierarchies — Cloud Customer Connect
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

Need help on a query with Account hierarchies

Received Response


I need to retrieve GL balances based on the account hierarchies and I am not able to get it for the 2nd level child. I am able to do it for one level. In the query below, the parent value 80000 has a couple of parents in it and I need to get to the lowest level child value. Can you pelase help?

select pk1_value from GL_SEG_VAL_HIER_RF

where tree_code = 'Account SPWR US CORPORATE'

and distance = 1

and ANCESTOR_PK1_VALUE in ('80000', '85000') 

and tree_version_id = 'BEF811F07D6DC7F8E0534461500A0B3F'

Howdy, Stranger!

Log In

To view full details, sign in.


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