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.
Query for extract Hierarchy Manager
Hi there ,
we need to reconstruct the hierarchy of a user's managers via a query in BI.
The real problem we encounter when a manager then has several active assignments and therefore there are several managers linked.
We would need to have a sort of hierarchical tree for the users. Is there a table in which the hierarchy is saved, i.e. the one we see through the interface? Or has anyone already created a query of this kind and could help us?
To make myself understood, I would need to create the hierarchy that you find in the example image below.
Tagged:
0