Get Started with Redwood for Oracle Cloud HCM Begin Now
To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
Organization Structure on HCM Extract
Summary
Organization Structure on HCM ExtractContent
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.
2