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

    Need help with using EXISTS in logical sql

    edited Jan 30, 2021 11:39PM in Reporting and Analytics for HCM 3 comments

    Summary

    Exclude INACTIVE records created due to legal entity transfer in OTBI analysis

    Content

    Hi Experts, 

    I am trying to create an analysis to report both active and terminated person in an analysis, but want to avoid the termination/inactive assignment records created due to internal legal entity transfers. I am trying to write a logical sql that checks and ignores INACTIVE assignment records if an ACTIVE assignment record exists for the same duration. that way I don't see multiple rows (Active and Inactive) for a person in the analysis.

    I am trying to put together a simple logical SQL but no luck. Can you please advise what am I doing wrong or is there a better way to do it?

    Tagged:

    Howdy, Stranger!

    Log In

    To view full details, sign in.

    Register

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