My Oracle Support Banner

E1: 07: In The Wage Attachment (P07107) Using Source Of Calculation = B Calculation Is Wrong When Processing Payroll (P07200) (Doc ID 2964422.1)

Last updated on OCTOBER 19, 2023

Applies to:

JD Edwards EnterpriseOne US Payroll - Version 9.2 and later
Information in this document applies to any platform.


Testing the setup outlined in How to Exclude Certain Wage From The Basis Of Calculation For Wage Attachments (Doc ID 1287537.1)

Setup a wage attachment on the employee for child support with a source of calculation = B and then set up a corresponding Benefit to reverse the Mandatory Deductions, the system is ignoring the negative benefit code when calculating Disposable Wage whether it is included or excluded from the Basis of Calculation.

E1: 07/77: How To Exclude Certain Wages From The Basis of Calculation For Wage Attachments (Doc ID 1287537.1)

1. Set up the garnishment or child support deduction per standard documentation using the applicable Source of Calculation (1-3 or 8).  Do not use B on the deduction set up.
2.  Set up the basis of calculation on the deduction with only the pay types that the wage attachment is applicable on.
3.  Set up the employee wage attachment information via the Wage Attachment Workbench (P07107) and change the Source of Calculation value to B.
The system will calculate the gross wages based on the basis of calculation and then subtract taxes and/or deductions as established via the Source of Calculation used on the deduction set up.

Note: The B for source of calculation will only calculate for "Basis of Calc - Taxes", not "Basis of Calc - (Taxes+Mand Ded).
For every deduction that should not be within the garnishment calculation, a non-cash/non-tax benefit DBA will need to be created with a -100% and set the basis of calculation as the deduction DBA.
For example an employee Retirement DBA 1500 deduction should be excluded from the garnishment calculation.
1. Create a benefit "Retirement DBA For WA" (greater the 1500 number), Method of Calculation %, Amount Rate 1 -100, Effect on Gross/Net Pay 1, Basis of Calc 1500 (this can be set to not print on the Pay Stub).
2. Assign the benefit DBA to the employee.
3. The execution would create a corresponding negative benefit amount. Like an offset. The amount of the Retirement DBA would not be included in the garnishment calculation
4. Note that the DBA table is cached (the Enterprise server (database cache) needs to be reset. Work with the CNC and follow Doc ID 944015.1 question 10 to reset)
Steps 1-2 would need to be completed for every deduction that should be excluded from the garnishment calculation.

Steps to duplicate:
1. From P059116 add the below DBAs:
Deduction DBA 1125, Basis of Calc  1 - 999 (Second test add 9060)
Deduction DBA 1034, Basis of Calc 1 - 999
Benefit DBA 9060, Basis of Calc 1034
2. From P0801 attach the DBAs to the employee using the EE DBA Instructions button.
3. DBA 1125 will open P07107 to enter the wage attachment information, use B for source of calculation and save.
4. Run an interim test (P07210I) or prepayroll (P07210) for the employee and review the calculation of the DBAs - Row exit, DBA review.
5. Notice the Disposable Wage is not reflecting the amount of DBA 9060
6. For the second test, with DBA 9060 in the Basis of Calc for DBA 1125, the disposable wage remains the same.


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.