Third Party NACHA Errors: Assignment Id : XXXXX does not have an attachment number ORA-20101: Error in pay_us_nacha_tape.get_third_party_details (Doc ID 1376662.1)

Last updated on DECEMBER 28, 2016

Applies to:

Oracle HRMS (US) - Version 11.5.10.2 and later
Information in this document applies to any platform.
***Reviewed for relevance 02-SEP-2014***

Symptoms

Problem Statement:

An error occurs when attempting to generate third party NACHA payments.

ERROR
-----------------------
Assignment Id : XXXXX does not have an attachment number
HR_6881_HRPROC_ORA_ERR
SQLERRMC ORA-20101: Error in pay_us_nacha_tape.get_third_party_details
ORA-06512: at "APPS.PAY_US_NACHA_TAPE", line 583
ORA-06512: at "APPS.PAY_US_NACHA_TAPE", line 905
ORA-06512: at "APPS.PAY_US_NACHA_TAPE", line 1352
ORA-06512: at line 1
ORA-06512: at "SYS.DBMS_SQL", line 1575
ORA-06512: at "APPS.PAY_MAG_TAPE", line 14
ORA-06512: at line 1
ORA-06512: at line 1

SQL_NO 586
TABLE_NAME PAY_US_NACHA_TAPE.RUN_FORMULA
APP-PAY-06881: Error ORA-20101: Error in pay_us_nacha_tape.get_third_party_details
ORA-06512: at "APPS.PAY_US_NACHA_TAPE", line 583
ORA-06512: at "APPS.PAY_US_NACHA_TAPE", line 905
ORA-06512: at "APPS.PAY_US_NACHA_TAPE", line 1352
ORA-06512: at line 1
ORA-06512: at "SYS.DBMS_SQL", line 1575
ORA-06512: at "APPS.PAY_MAG_TAPE", line 14
ORA-06512: at line 1
ORA-06512: at line 1
has occurred in table PAY_US_NACHA_TAPE.RUN_FORMULA at location 586

Cause: an oracle error has occurred. The failure was reported on table PAY_US_NACHA_TAPE.RUN_FORMULA at location 586 with the error text ORA-20101: Error in pay_us_nacha_tape.get_third_party_details




Steps to Reproduce

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

  1. Run NACHA for 3rd party payments


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