Extract the ID of a department (going active on 01 october) from Fusion
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.