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

Advanced Filter for HCM Extract

edited Apr 12, 2020 4:03PM in HCM Integrations 13 comments

Summary

How to determine table alias for R13 20A

Content

Hi,

I am hoping someone may have an idea to help resolve a problem I am trying to tackle.  I have an HCM Extract using Entity PER_EXT_PAY_EMPLOYEES_UE as the Parent Data Group and supplies the majority of attributes for the output.  I have a recent requirement to modify the extract to exclude users from the output that are a specific person type id, but DO include a subset of those with that person type id based on an Organization Attribute value which is an attribute in the output from PER_EXT_PAY_EMPLOYEE_US.  However, neither the Assignment Person Type ID or the Organization Attribute1 are available in the

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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