Costing Calculates Distributed Values Incorrectly When There is a Negative Earnings Value
(Doc ID 2818179.1)
Last updated on JANUARY 23, 2024
Applies to:
Oracle Payroll - Version 12.2.5 and laterInformation in this document applies to any platform.
Symptoms
Patch 31508540 was meant to resolve the issue of Distributed costing results being inflated and overall sum becomes less than 1. This issue is resolved, but now the Costing process is distributing the values incorrectly when the employee has a genuine negative earnings value. The amounts that are allocated are over- and under-valued.
This can be seen in the Costing Detail Report.
Example:
Based on (distributed element) NI Employer 162.15 and total earnings 2383.84 (which includes a negative value for Maternity Offset), Costing should be distributed:
OMP Pay 116.37 (debit)
London Allowance 14.56 (debit)
SMP Pay 45.78 (debit)
Basic Pay Spinal Salary 218.18 (debit)
Maternity Offset -232.74 (credit)
Total Debits 394.89
Total Credits 232.74
Net 162.15 (debit)
Instead, the 162.15 was distributed with these values after the Patch was applied:
OMP Pay 95.57 (debit)
London Allowance 11.96 (debit)
SMP Pay 37.60 (debit)
Basic Pay Spinal Salary 179.17 (debit)
Maternity Offset 162.15 (credit) <== same amount as NI Employer that is distributed
Total Debits 324.30
Total Credits 162.15
Net 162.15 (debit)
There is a significant difference in the distributed allocation after the Patch
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
From HRMS Manager responsibility or equivalent: Navigate: Processes and Reports > Submit Processes and Reports > Single Request
1. Run Payroll process employee(s) which includes a negative earnings result for one element
2. Run Costing process
3. Run Costing Detail Report and review results.
Changes
Applied Patch 31508540
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 |