Learn about the new Oracle AI Agent Studio for Fusion Applications: Watch Now
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
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.
SQL query fetching Duplicate rows for terminated employees with pending worker records
Summary
SQL query fetching Duplicate rows for terminated employees with pending worker recordsContent
I created a SQL BI Publisher report to fetch all active employees and terminated employees along with their Manager person numbers in the system. While I am getting the results as expected, there are five terminated records who have duplicate rows due to different managers assigned to the pending worker record and employee record.
I am unable to exclude the duplicate records of the pending workers. I tried all the primary flags, system person types, Max Row, R count but nothing seems to be working.
Tagged:
0