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

Oracle HCM BIP Report - Employee Hierarchy query

edited Apr 19, 2024 8:56AM in Human Capital Management 1 comment

I have a BIP requirement to display the employee details in the report where I need to show the employee details like tree structure.

Eg: Manager A has 2 reportees called B and C

Again Manager B have 2 reportees D and E

Again Manager D have 2 reportees F and G

Let's say if Manager A runs the report, he should able to see the records of B, C , D, E , F and G.

If Manager D runs the report, he should able to see the records of F and G

Here the challenge is, I can get 1 branch of hierarchy eg: B, D, F and not multiple branch B,C, D, E, F and G of employees as requested above using Connect by query. Please let me know if someone achieved it earlier.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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