Customers who have run the Upgrade Wage Attachments process after applying the 2012 RUP are reporting errors similar to those listed below when either running a quickpay or processing a payroll for employee(s) with involuntary deductions.
HR_51118_HRPROC_ERR_ON_ASG ASGNO 1115
APP-PAY-51118: Error was encountered when processing assignment 1115
ETNAME: Garnishment 3
APP-PAY-51119: Error was encountered when processing Element Type Garnishment 3
SQLERRMC ORA-01403: No data found
APP-PAY-06881:Error ORA-01403: no data found has occured in table pay_input_values_f at location 520
This issue was logged in Bug 14679161 - QUICK PAY ERROR AFTER RUP (2012) AND WAGE ATTACHMENT UPGRADE APP-PAY-06881.
The following one off patches have been released to My Oracle Support to resolve this issue*:
11i - Patch 14679161
12.0 - Patch 14849394:R12.PAY.A
12.1 - Patch 14849394:R12.PAY.B
* IMPORTANT: Depending on when/if customers have run the Wage Attachment upgrade process will determine the appropriate action to take. Any customer who is encountering the above error and/or has run the Wage Attachment upgrade process AFTER applying the 2012 RUP (applicable to their release level) should log a Service Request with Oracle Support to receive assistance on the necessary steps to take to resolve the problem BEFORE applying the above patch.
Any customer who has not yet run the Wage Attachment Upgrade process (either before or after applying the 2012 RUP), should follow the action plan documented in the patch readme.
For those customers who have already run the Wage Attachment Upgrade process BEFORE applying the 2012 RUP, should apply the patch (applicable to your release) listed above. Be sure to run any post install processes, such as the data install utility and HR global driver. See the patch readme for full details.
Please consult Note 404478.1: Americas (US, CA, MX) HCM High Priority Alert for the latest Alert status.