Why is the termination report creating duplicates ?

Question

The term report is creating duplicates. As an Eg it looks like this in the report. I think it is due to manager Id, Manager Name, seniority date or assignment number field. Can anyone help fix the issue.

EMP ID

Term Reason

Term Date

12

Background Check Fail

14-Nov-2023

12

Career Opportunities

14-Nov-2023

12

Background Check Fail

16-Jan-2025

12

Career Opportunities

16-Jan-2025

Termination xml.txt

Rajasekhar Bandaru-Oracle · Answer

Please create analysis using single subject area column after that add one by one column from second subject area and identify by

adding which column duplicate data appears

Also, Please review the given OTBI help center documentation link and ensure to include recommended column

https://docs.oracle.com/en/cloud/saas/human-resources/24d/faohb/Workforce-Management--Worker-Assignment-Event-Real-SA-4.html#Workforce_Management__Worker_Assignment_Event_Real_SA_4_d1e20594

https://docs.oracle.com/en/cloud/saas/human-resources/24d/faohb/Workforce-Management--Work-Relationship-Real-Time-SA-5.html

https://docs.oracle.com/en/cloud/saas/human-resources/24d/faohb/Compensation--Workforce-Assignment-Salary-History--SA-119.html#Compensation__Workforce_Assignment_Salary_History__SA_119_d1e8370