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

    Oracle SQL - Position at a point in time

    edited Mar 5, 2025 8:49AM in Reporting and Analytics for HCM

    Summary:

    Hi,
    I am just writing a query to get any employees that are on secondments, leave, etc at a given point in time.
    One of the key requirements is to get all the additional data (position record, manager assignment, ect) as of the day when they went on secondment or leave.
    For instance, if x goes on leave on 1/01/2025, i want the record for the position or manager as of 01/01/25. I dont want to look at any records that are created after that.

    The issue i am facing is that i get future dated records when i join my main query (updated_assignments) to other query (position), but when I investigate position query, I only get one record. I am not too sure what is the reason for that.

    Tagged:

    Howdy, Stranger!

    Log In

    To view full details, sign in.

    Register

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