Get Started with Redwood for Oracle Cloud HCM Begin Now
To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
Need help with using EXISTS in logical sql
Summary
Exclude INACTIVE records created due to legal entity transfer in OTBI analysisContent
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:
0