Oracle Transactional Business Intelligence

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

Report with Workforce Compensation Real Time Subject area returns duplicate results

Received Response
1
Views
1
Comments

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

  • Adam_Cantwell
    Adam_Cantwell Rank 1 - Community Starter

    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