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

Extract the ID of a department (going active on 01 october) from Fusion

Accepted answer


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. 

Howdy, Stranger!

Log In

To view full details, sign in.


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