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

Last updated on SEPTEMBER 15, 2016

Applies to:

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

Symptoms

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.

STEPS
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
9000001000001000000030002469134000000150000000000150000                                       
9999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999
9999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999
9999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999999

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.

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