Human Capital Management - EBS (MOSC)

MOSC Banner

SQL for creating organisation hierarchy in a tabular view

edited May 19, 2015 12:59PM in Human Capital Management - EBS (MOSC) 2 commentsAnswered


Hi,

Im looking for some help in creating a SQL Script that flattens the Organisation Hierarchy in Oracle EBS, the tables that store the information are  HR_ALL_ORGANIZATION_UNITS & PER_ORG_STRUCTURE_ELEMENTS

Im trying to retrieve the organization and its subsequent levels from 1-12 within the hierarchy, i would tell the query which org to start with (top org)

Eg

OrgName,      Org_Level1,      Org_Level2,      Org_Level3,      Org_Level4,           Org_Level5,      Org_Level6 ..........

HR                  Vision PLC        Corporate          HR                    Pay & Benefits       Payroll               International Payroll

Currently the Org data is stored like...

Child_Org               Parent_Org

Vision PLC              <NULL>

Corporate               Vision PLC

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center