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
    • Learn about the new Oracle AI Agent Studio for Fusion Applications: Watch Now

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

    Assignment Changes L-SQL Query Issue

    in Reporting and Analytics for HCM 1 comment

    Hi all,

    I've been using and adapting Julian's L-SQL query posted here:

    to try and return previous roles for employees.

    It all works great until we have someone who has two assignment changes in one change, see screenshot below:

    This individual does not show on the report at all.

    Does anyone have any ideas on how we can show employees with more than one Assignment Change in one change, so to speak?

    Attached is the L-SQL I'm using.

    Thanks!

    Tagged:

    Howdy, Stranger!

    Log In

    To view full details, sign in.

    Register

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