Oracle Transactional Business Intelligence

Home› Oracle Analytics› Oracle Analytics Forums› More Solutions› Oracle Transactional Business Intelligence

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Why is the termination report creating duplicates ?

Received Response
1
Views
1
Comments
Trupti Khodke
Trupti Khodke Rank 1 - Community Starter
in Oracle Transactional Business Intelligence

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

Answers

  • Rajasekhar Bandaru-Oracle
    Rajasekhar Bandaru-Oracle Rank 6 - Analytics Lead

    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