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.
Extract the ID of a department (going active on 01 october) from Fusion
Hello,
In Fusion we have created a department that will become active on the 1st of October.
For our integration with Taleo I need the Department ID of this department already now, to ensure newcomers can be created in this department.
What I want to do:
In Oracle BI, I want to use a SQL query to extract a list of all department names with their department IDs.
Can you help me to extract this please? I don't know how to write such a query.
Of course if there is an easier way to find the ID let me know.
Tagged:
0