Why is the termination report creating duplicates ?

Trupti Khodke

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

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