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

Organization Structure on HCM Extract

Received Response
edited Dec 7, 2017 7:06AM in HCM Integrations 4 comments


Organization Structure on HCM Extract


Hi Expert,

I am trying to extract Organizational Structure in Oracle Fusion HCM,My requirements are such that I need to Extract 

Organization_ID,Organization_Name,Node_Level,Parent_Organization_ID,Parent_Organization_Name,how ever the seems to be no DBI for parent organization id this makes it impossible to extract a parent child data  in this regard.

I have attached an SQL code that I created for BIP with the exact data that I need for your better understanding.


Kindly assist on how to achieve this in HCM Extract.


Howdy, Stranger!

Log In

To view full details, sign in.


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