E1: 07: Pre-Payroll Calculates Incorrect One-Time Override Causing Gross-to-Net Out of Balance Error (Doc ID 2888499.1)

Last updated on SEPTEMBER 27, 2022

Applies to:

Symptoms

When attempting to process a one-time override to subtract -51.17 from a Medical Deduction that has been terminated by an employee, Pre-Payroll (R07200) populates an incorrect amount in the Deduction/Benefit/Accrual Ledger File (F0709) resulting in a Gross-to-Net Out of Balance Error. DBA Review screen shows Employee Medical Deduction is -10.23 which doesn’t equal the Stub Detail of -51.17 which is the reason for the Gross to Net Error.

This problem started after the client took the latest ESU (JN19831) for the Pre-Payroll DBA Calculation Business Function Code (B0700005.c).

Steps to Reproduce:

1. Select an Hourly Employee (P0801) with a Weekly Pay Frequency.
2. In Work with PDBAs Review PDBA Codes 1018 and 1019.
   1. The Medical Deduction 1018 has the “Calculate Only Once Per Pay Period” checkbox checked.
   2. The Medical Benefit 1019 also has the “Calculate Only Once Per Pay Period” checkbox checked.
3. In Employee DBA Instructions add the two DBAs as follows:
   1. 1018 D, Amount Level 1 = 120.65, Pay Start Date = 7/1/2022
   2. 1019 B, Amount Level 1 = 50.00, Pay Start Date = 7/1/2022
4. In Speed Time Entry (P051121) enter timecard with five lines for 8 hours per day from 7/25/2022 to 7/29/2022.
5. In Pay Cycle Workbench (P07210) setup Pay Cycle Setup as follows:
   1. AutoPay checkbox is unchecked
   2. Pay Cycle Code = W (Weekly)
   3. Pay Period End Date = 7/29/2022
   4. From Date = 7/23/2022
   5. Thru Date = 7/29/2022
6. In Pay Cycle Workbench (P07210) Submit Pre-Payroll
7. Take the Row Exit to Payment Review.
   1. Work with Payment Review shows 40 hours pay was processed.
8. Row Exit to Stub Detail.
   1. Employee Medical Deduction is 120.65 on Stub Detail, matching amount in Employee DBA setup.
9. Form Exit to DBA Detail.
   1. On DBA Review Employee Medical Deduction is 120.65 matching Stub Detail.
10. Return to Pay Cycle Workbench (P07210) and Reset Pre-Payroll (P07210).
11. In Speed One-time Overrides (P07OTO1) enter two records:
    1. Work Date =7/25/2022 (first day of pay period), DBA Code = 1018 (Deduction), Amount = -51.17
    2. Work Date =7/25/2022 (first day of pay period), DBA Code = 1019 (Benefit), Amount = -40.00
12. Return to Pay Cycle Workbench (P07210) and Submit Pre-Payroll.
13. Take the Row Exit to Payment Review.
    1. Work with Payment Review shows a Gross to Net Error.
14. Row Exit to Stub Detail.
15. Employee Medical Deduction is -51.17 on Stub Detail, matching amount in Speed One-time Overrides (P07OTO1)
    1. Form Exit to DBA Detail.
    2. On DBA Review Employee Medical Deduction is -10.23 which does NOT equal the Stub Detail of -51.17 which is the reason for the Gross to Net Error.

Cause

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