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

Find parent value in CoA hierarchy for balancing segment in OTBI

edited Jun 3, 2020 7:30AM in Reporting and Analytics for ERP 8 comments

Content

As an investment fund manager , my company closes the periods per FUND which is defined in the hierarchy of the Balancing Segment Chart of Accounts. As per Oracle's best practice we have a ledger setup per country.

The business is requireing the AP dashboard I'm creating to assist with period close to be filtered based on the CoA hierarchy on the top level (below T).

Is there any way to do this? Our CoA is BI enabled and I can find some of the fields in OTBI, but not the parent(s).

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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