My Oracle Support Banner

Third Party NACHA Errors: Assignment Id : XXXXX Does Not Have An Attachment Number (Doc ID 2466954.1)

Last updated on DECEMBER 03, 2019

Applies to:

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

Symptoms

Problem Description

NACHA process errors out for third party payments.

Error detail is provided below:

Assignment Id : 20489 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 616
ORA-06512: at "APPS.PAY_US_NACHA_TAPE", line 938
ORA-06512: at "APPS.PAY_US_NACHA_TAPE", line 1389
ORA-06512: at line 1
ORA-06512: at "SYS.DBMS_SQL", line 1707
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 616
ORA-06512: at "APPS.PAY_US_NACHA_TAPE", line 938
ORA-06512: at "APPS.PAY_US_NACHA_TAPE", line 1389
ORA-06512: at line 1
ORA-06512: at "SYS.DBMS_SQL", line 1707
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
ORA-06512: at "APPS.PAY_US_NACHA_TAPE", line 616
ORA-06512: at "APPS.PAY_US_NACHA_TAPE", line 938
ORA-06512: at "APPS.PAY_US_NACHA_TAPE", line 1389
ORA-06512: at line 1
ORA-06512: at "SYS.DBMS_SQL", line 1707
ORA-06512: at "APPS.PAY_MAG_TAPE", line 14
ORA-06512: at line 1
ORA-06512: at line 1
.

Action: Please contact your support representative.


Steps to Reproduce:
The issue can be reproduced at will with the following steps:
1. Submit NACHA for third party payments
2. Observe error in log



Cause

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
Symptoms
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.