Get Started: AI Resources for Oracle Cloud HCM – Go Here
Progress with Redwood: Redwood 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
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.
Tagged:
0