My Oracle Support Banner

Costing Calculates Distributed Values Incorrectly When There is a Negative Earnings Value (Doc ID 2818179.1)

Last updated on OCTOBER 30, 2021

Applies to:

Oracle Payroll - Version 12.2.5 and later
Information in this document applies to any platform.


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.


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


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. 


 Applied Patch 31508540


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

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