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: AI Resources for Oracle Cloud HCM – Go Here

Progress with Redwood: Redwood Resources for Oracle Cloud HCM -  Go Here

Navigating through department tree in a Value Set

Summary:

Hello again, Customer Connect!

I am creating an HCM Extract and I need to get the name and the ID of a department in a department tree that have one flexfield value as "yes". The PER_EXT_DEPARTMENT_TREE_UE are returning 0 rows for me but I have a query that list the threes and the department that have the flexfield as "yes". How can I use this query to create a Value Set for getting the department id and name that have this value ? In the query I'm gonna put in here, I need to get the Division_Name and Division_ID. How can I get to

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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