My Oracle Support Banner

EAP: Routing Number in ACH file has invalid Check Digit / DFI ID (Doc ID 1539918.1)

Last updated on SEPTEMBER 01, 2020

Applies to:

PeopleSoft Enterprise FIN Payables - Version 9 to 9.1 [Release 9]
Information in this document applies to any platform.


Vendor is set up for Payment Method = ACH using CCD+ file layout.  When the output file is created, it does not pick up the correct digit Check Digit.  The CCD+  file has Account Number listed where the Routing Number should be.

1. External Account is setup with Payment Method = ACH, Layout = CCD+, Settle By = Pay Cycle
2. Vendor setup with Payment Method = ACH, Layout Option = Use Bank Account Default
a) Specify Vendor Bank Accounts
b) Bank ID = 111000023 -- This is actually their Bank's Routing Number, which ends in a 5, but they changed it to a 3 so that it matches the Vendor's Check Digit and is provided in the ACH file.
c) DFI ID = 063107513 -- This is the Vendor's Bank Routing Number but the system does not pick up the 8th digit Check Digit to be provided in the ACH file.  Instead, it is picking up the Bank's ID Check Digit.
3. Create a Voucher for Vendor and Bank
4. Pay the Voucher through Express Payment
5. Review ACH file.  The CCD+  file has Account Number listed where the Routing Number should be.

CCD+ file has DFI as 063107512 instead of 063107513

101 121042882 12104288212122015551094101USA BANK               USA - New York                 
5200US001 NEW YORK O005004                        CCDUSBNK CHEC1212201212220001        0000001
622063107512111000023        00001500000741-256458    Bay Area Electric-      1012345670000001
705RMR*IV*TESTACH003**1500\                                                        00010000001
6271111111120741-256458      00001500000741-256458    US001 NEW YORK OPERATI  0012345670000003
82000000030002469134000000150000000000150000                                           0000001

For Vendor Bank Account:

DFI ID = 063107513 but 622 row has 063107512 -- This in incorrect.

For External Account:

DFI ID = 111111118 but 627 row has 111111112 -- This in incorrect.




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

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