NACHA File Addendum Counts Incorrect Causing File to be Rejected by Bank
(Doc ID 2785950.1)
Last updated on DECEMBER 09, 2022
Applies to:
Oracle HRMS (US) - Version 12.1.3 and laterInformation in this document applies to any platform.
Symptoms
When trying to submit the .mf NACHA file to the bank the file was being rejected due to addendum count not being correct.
Internal test case NACHA file with issue shown below: (NOTE: All account and banking information is artificial and is not associated with any real customer/bank)
101 000023493 98793884921052021240094101BOFA1
5200VISION CORPORATI 9999
62300000001122 0000000000888798374 <<<< Starts with 6
628000292992282761-282763 0000000000 <<<< Starts with 6
820000000200000293000000000000000000000000009999
90000010000010000000 >>>> 1 <<<<< 0000029300000000000000000000000000 <<<< Count should show 2 instead of 1
9999999999999999999999999999999999999999999999999999999
5200VISION CORPORATI 9999
62300000001122 0000000000888798374 <<<< Starts with 6
628000292992282761-282763 0000000000 <<<< Starts with 6
820000000200000293000000000000000000000000009999
90000010000010000000 >>>> 1 <<<<< 0000029300000000000000000000000000 <<<< Count should show 2 instead of 1
9999999999999999999999999999999999999999999999999999999
-----------------------
All rows starting with '6' should be added up and displayed in position 21 of the first row starting with '9'
Steps to Replicate:
- US HRMS Manager > Processes and Reports > Submit Processes and Reports
- Run NACHA
- Locate the directory that stores the .mf file that is created.
To locate the NACHA file output, you can use the following query:
- Review .mf and notice that count (shown above in yellow) is not adding the rows properly
Changes
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 |
Changes |
Cause |
Solution |
References |