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
Skip to content
  • Register
    • Get Started: AI Resources for Oracle Cloud HCM – Go Here

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

    HCM Extract with PER_EXT_SEC_ASSIGNMENT_RANGE UE fetching all assignment rows

    in HCM Extract 7 comments

    Summary:

    I am have issue with PER_EXT_SEC_ASSIGNMENT_RANGE_UE where it is pulling all historical assignment rows when only one row has changed,

    I have the following structure in the extract

    PER_EXT_SEC_PERSON_UE - Root ( with threading DBI as Person ID)

    — PER_EXT_WORK_RELATIONSHIP_UE

    — PER_EXT_SEC_ASSIGNMENT_RANGE_UE.

    Requirement is pull historical rows if they have changed.

    As an example, If a promotion happens followed by manager change then the requirement is to get both the rows in the out with their effective dates.

    How to get avoid rows which have not changed ?

    Tagged:

    Howdy, Stranger!

    Log In

    To view full details, sign in.

    Register

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