My Oracle Support Banner

E1: 05: Wage Attachment Workbench (P07107) Unable To End Wage Attachment When PO#2 Is Set To a 1 And Employee Has Multiple Records In Table F06106 (Doc ID 2590625.1)

Last updated on JANUARY 24, 2022

Applies to:

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


When P07107 PO#2 is set to a 1 to create a new DBA record for the change in F06106 and you make a change to the garnishment amount, the system is creating a new record in the F06106 correctly and end dating the 1st record with a date one day prior to the new change. Now if you attempt to end the wage attachment by entering a Thru date in the additional information tab of P07107, the system is incorrectly overwriting the end date one the 1st record with the new Thru date and you are unable to end the wage attachment because the 2nd record still exists with no end date. Also if you look in the Employee DBA instructions (P050181) you can see that the PDBA is not ended.

1- Set PO#2 behind P07107 to a 1
2- Enter a wage attachment for your test employee with an amount $120 and Start Date 07/28/2019 and notice a record is successfully added to the F06106 and the employee's DBA instructions (P050181)
3- Go back into the P07107 and change the garnishment amount from $120 to $140 with a Start Date of 09/01/2019 and notice that a 2nd record is added to the F06106 with amount $140 and start date 09/01/2019 and the 1st record is end dated with 08/31/2019
4- Now try to end the wage attachment by entering a Thru date of 09/10/2019 and notice that the system incorrectly changes the end date on the 1st record to the Thru date entered (09/10/2019) and the 2nd record is not changed, it is still active with no stop date.
5- Similarly, this issue can be seen on the employee dba instructions form.




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.