My Oracle Support Banner

E1: 07/77: Payroll GPA Not Accurate After Applying 9.2 Upgrade Update 5 (B0700005) (Doc ID 2770008.1)

Last updated on MAY 10, 2021

Applies to:

JD Edwards EnterpriseOne Canadian Payroll - Version 9.2 to 9.2 [Release 9.2]
Information in this document applies to any platform.


After updating to 9.2 Update 5, When creating Payroll with a Benefit DBA, the GPA decimal position is incorrect.  For example, if the amount should be 132.00, it is showing as 13,200.00.

Steps To Duplicate

  1. For a test Employee, set up DBA instructions with the following settings. 
    1. DBA basic setup
      1. 2000
        override flag=N
        amt/rt level 1 4.0000
        vhr flag = Y
        Table code = blank
        Amount Due = blank
        DBA Type = B
        Calc Method = 3
        description = RRSP ER%
    2. Group Plan Setup
      1. union code = 03SF03 (HSL SAL FT W BEN)
        DBA Code = 2000
        Tax Type = B
        MC = 3
        OF = N
        Table code = 20001
        Amt or Rate = 5.0000
      2. Calculation Table
        Table code = 20001
        table method = ZE
        Table type = D
        lower limit   upper limit amt/rate
        99999999.99- .01-        .0000
        blank           1199.99    1.0000
        1200.00         999999999.99  .0000
      3. Table Methods ZE
        lower/upper range represents months service from
        RRSP DATE multiply the gross earnings
        (current period) by the % amount defined
        in the table & then amount/rate defined on Emp.
        RRSP Date is ED12
        D/B/A/ Methods
        method 1 = 3 table - age (calc by DOB/SDOB)
        method 2 = 9 table - age (FAGE/SAGE)
        method 3 = blank
        2. Attach DBA to EE master
        3. Create an Interim for pay type 1 for 80 hours
        4. click the purple calculator
        5. go to Row Exit and select DBA Details
        6. Notice GPA is displaying incorrectly/decimals are way off.
    3. Employee DBA Instructions
      1. DBA 2000 is assigned at the group plan level but for this employee it is also assigned at the Employee level to give a lesser percent.
      2. Union code is set
      3. Effective date is 4/8/2021
  2. After completing above setup and attaching DBA 2000 to Employee, create a Interim Payment;
  3. Click Purple Calculator,
  4. Once results appear, go to Row Exit DBA Details screen;
  5. Notice the Amount shows decimal in wrong position.  



This occurs after applying 9.2 Update 5


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.