EAP: Routing Number in ACH file has invalid Check Digit / DFI ID
Last updated on JANUARY 12, 2018
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
6271111111120741-256458 00001500000741-256458 US001 NEW YORK OPERATI 0012345670000003
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms