Organization Structure on HCM Extract — 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
Get Started with Redwood: Oracle Cloud SCM and Purchasing

Organization Structure on HCM Extract

edited Dec 7, 2017 7:06AM in HCM Integrations 5 comments

Summary

Organization Structure on HCM Extract

Content

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.

Register

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