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

    Iterate Assignment History based on Effective start date and maximum of effective sequence

    edited Nov 29, 2024 1:29PM in Workforce Management 1 comment

    Summary:

    Hi All,

    I have a requirement to iterate the assignment history records for an employee and I am able to use to DBI to get the iteration list for the assignment records but not able to get the records orderly (Effective start date, Effective sequence)

    As one of the scenarios is failing, when we have 2 assignment records on same day, and it's not returned the effective start date by order in the DBI.

    Effective Start Date…....Effective Sequence……Changes

    02/30/2024……………..2…………….Job Change

    02/30/2024……………..1…………….Manager Change

    01/10/2024……………..1…………….Department Change

    12/10/2023……………..1…………….Hire Record-Created

    I need to fetch the assignment records orderly based on Effective start date, Effective sequence as I mentioned in the above example.

    Tagged:

    Howdy, Stranger!

    Log In

    To view full details, sign in.

    Register

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