My Oracle Support Banner

Element Value Doubled Up For Employees Whose Salary Changed Mid Month In OTBI (Doc ID 2609586.1)

Last updated on MAY 25, 2020

Applies to:

Oracle Fusion Global Payroll Cloud Service - Version 11.13.19.04.0 and later
Oracle Fusion Application Toolkit Cloud Service - Version 11.13.19.07.0 and later
Information in this document applies to any platform.

Symptoms

On :  11.13.19.04.0 version, Technology Management - Reports/Analytics

ACTUAL BEHAVIOR  
---------------
- Amount is doubling due to multiple values for "Payroll - Payroll Run Results Real Time"."Input Value"."Input Value Name", which is aggregating on the report
- The issue is repeating every time an employee has the Salary modified by the middle of the month, so in that month the employee salary will be doubled.

EXPECTED BEHAVIOR
-----------------------
- the column should make only SUM aggregation


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Create an OTBI analysis
2. "Payroll - Payroll Run Results Real Time"."Payroll Run Results"."Amount"

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot create an OTBI analysis with correct data.

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.