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.

Reporting on the positions colleagues are working in (factoring in secondments)

edited Apr 20, 2021 9:04AM in Reporting and Analytics for HCM 9 comments

Content

Im looking to report through OTBI on where colleagues are currently working, factoring in secondments. For example I only want 1 row to appear for each colleague. This is fine for those with just a primary assignment but for those in a secondment and statuses of both 'Active - Temporary - No Payroll' and 'Active - Payroll Eligible' it would return both roles and we would just want to return the job they are in (i.e the 'Active - Temporary - No Payroll' ). 

I've looked at using the 'worker assignment real time' subject area using the 'assignment count' with a union but the 'assignment count' isn't reliable and seems to be counting 'Inactive - Payroll Eligible' assignments which won't work. The only way round this I can see is to have a union with one part just colleagues with  'Active - Temporary - No Payroll' and the other with 'Active - Payroll Eligible' colleagues where they don't exist based off the results of another analysis (i.e a list of 'Active - Temporary - No Payroll' colleagues). 

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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