Categories
- All Categories
- 75 Oracle Analytics News
- 7 Oracle Analytics Videos
- 14K Oracle Analytics Forums
- 5.2K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 40 Oracle Analytics Trainings
- 59 Oracle Analytics Data Visualizations
- 2 Oracle Analytics Data Visualizations Challenge
- 3 Oracle Analytics Career
- 4 Oracle Analytics Industry
- Find Partners
- For Partners
Duplicate rows in Active Employees Report
When running the Active Employees Report I am getting duplicate rows for only a few of the employees. What is the best workaround for this?
Best Answer
-
Hi,
I am not sure what content you refer to. Maybe you can post what work area selected form the navigation menu you are using to view this? Is this a report or an analysis? What is the path to this content in the catalog in OTBI?
What is status "Active". I will make a guess that this is a list of workforce person assignments not persons.
PER_ALL_ASSIGNMENTS_M
So it is not the person who is Active. It is each of their assignment(s) of worker type "Employee Worker" that are status Active or not. Select Navigator, select Show More, in group Me select work area Personal Information. Select Employment Info. View primary assignment. A person can have multiple work relationships with different legal entity of type legal employer. And for each work relationship a person may have multiple assignments at the same points in time. And for each of those assignments multiple versions of each of those assignments over time. So a person can have multiple status because they have multiple assignments?
What is the workaround. If you need 1 assignment per person then you will have to filter/rank them for example using flags like "Primary" which is the primary assignment for the primary work relationship.
1