My Oracle Support Banner

WS: 77: Deduction Calculation Table, P069021, with a Table Method Based on Age, does not Calculate for Employees with Date of Birth Year Higher than 1999 (Doc ID 2867841.1)

Last updated on SEPTEMBER 12, 2022

Applies to:

JD Edwards World Canadian Payroll Processing - Version A9.4 and later
Information in this document applies to any platform.


When an employee has a birthdate on the Employee Master, P0801, year 2000 and higher, and a deduction calculation table, P069021 is set up with a table method based on age, DOB (date of birth) the deduction is not calculating for any employees born after 1999.


1.  Set up a DBA (deduction, benefit, accrual) on P069117, DBA Setup, with a Calculation Table, P069021, using a Table Method based on Age, such as AS (lower/upper range represents AGE in years).

2.  Attach the DBA to the DBA Instructions, P070181, for an employee set up on P0801 (Employee Master) with a birthdate of 20xx (ex: 2001).

3.  Enter an Interim Check, P070531 for this employee.

4.  Review the interim check and see the DBA did not calculate.




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.