Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
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
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.

Cannot find Department field from Offer table within Recruiting RT SA

edited May 1, 2020 6:53PM in Recruiting, Opportunity Marketplace 3 comments

Summary

It does not currently seem possible to report on the Department Name from the Offer section of the Recruiting Real Time SA

Content

I have an analysis built to report on new hires. Occasionally, we will have a req which is opened for one department but for whatever reason (recruiter error, req realignment, etc) the department is switched during the offer creation process.

To account for this, we need to report on the department as listed in the offer section. However, the only department field in that section is Department ID ("Job Offer - Assignment Details"."Department Id"). This is a 15-digit string of numbers that does not provide any value for our needs.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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