Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 14 Oracle Analytics Lounge
- 211 Oracle Analytics News
- 42 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 78 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Report with Workforce Compensation Real Time Subject area returns duplicate results

I have a report that I've created using the Workforce Compensation Real Time Subject area, in the report I have the fields:
Person Number
Assignment Number
Assignment Status Type Code
Market Group (DFF on the Department Table)
Internal Segment (DFF on the Department Table)
Business Code (DFF on the Department Table)
HR Division (DFF on the Department Table)
Compensation Plan Name
Cycle Name
Component Name
Eligibility Status
Target Compensation Amount
Manager Person Number
Grade Name
Legislation
I have the Plan name filtered, the cycle name filtered, the component name filtered and the Person Number filtered. The employee I'm using only has one Assignment and is eligible for the plan I'm filtering for, along with 2 other plans as well.
When I run the report, I get the data back but it duplicates the Employee's data 11 times and I'm not sure why, is there something specific in this SA you need to do to only get one row back?
Answers
-
Issue was pretty obvious after posting, we had the unsecured manager person number in the report, that should not have been in the report, only the direct line manager should have been. After removing the unsecured manager person number we're only getting one row per EE
0