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: AI Resources for Oracle Cloud HCM – Go Here

Progress with Redwood: Redwood Resources for Oracle Cloud HCM -  Go Here

Person, Assignment, Payroll data for Employees with Multiple Work Relationships and Assignments

edited Jan 24, 2022 7:48PM in HCM Extract 1 comment

Summary

The following definition will extract basic person, assignment, payroll and element entries data for active employees.

Content

It is assumed that employee has multiple Work relationship, multiple Assignments, and employee person type is ‘EMP’ for active employees. This extract is driven by Person and Work Relationship User Entities.

Sample Criteria:

i) If you want INACTIVE Persons, you need to change Person Level Data Group Filter accordingly.

  • Extract Person System Person Type in ('EMP', 'EX_EMP')

ii) If you want ACTIVE Persons, you need to change Person Level Data Group Filter accordingly.

  • Extract Person System Person Type = 'EMP'

                    iii) At Assignment Level criteria to get Only Active Assignments:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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