Quick Pay Prepayment Process Errors: ORA-20001: There Is No Payment Method Specified (Doc ID 1905880.1)

Last updated on DECEMBER 01, 2016

Applies to:

Oracle Payroll - Version 11.5.10.2 and later
Information in this document applies to any platform.

Symptoms

Quick Pay Prepayments fails with an error after an employee changed payrolls and has a wage attachment element.

HR_6881_HRPROC_ORA_ERR
SQLERRMC ORA-20001: There is no payment method specified.
ORA-06512: at "APPS.HR_UTILITY", line 939
ORA-06512: at "APPS.HR_PRE_PAY", line 2595
ORA-06512: at "APPS.HR_PRE_PAY", line 2921
ORA-06512: at "APPS.HR_PRE_PAY", line 3246
ORA-06512: at line 3

SQL_NO 1122
TABLE_NAME hr_pre_pay.do_prepayment
APP-PAY-06881: Error ORA-20001: There is no payment method specified.
ORA-06512: at "APPS.HR_UTILITY", line 939
ORA-06512: at "APPS.HR_PRE_PAY", line 2595
ORA-06512: at "APPS.HR_PRE_PAY", line 2921
ORA-06512: at "APPS.HR_PRE_PAY", line 3246
ORA-06512: at line 3
has occurred in table hr_pre_pay.do_prepayment at location 1122

Cause: an oracle error has occurred. The failure was reported on table hr_pre_pay.do_prepayment at location 1122 with the error text ORA-20001: There is no payment method specified.

 

 

Steps to Reproduce:
The issue can be reproduced at will with the following steps:

1. Add wage attachment element and give it to an assignment
2. Change payroll for assignment
3. Run Quick Pay
4. Run Quick Pay Prepayments



Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms