My Oracle Support Banner

EAP: Canadian Bank Code not formatted properly in CPA005 EFT Layout (Doc ID 2200124.1)

Last updated on FEBRUARY 05, 2019

Applies to:

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


Canadian Bank Code is not formatted properly in the CPA005 EFT file layout. The Bank ID specified on the Supplier Bank Account is not reflecting in the file. The Branch ID is being shown correctly but the Bank ID is always reflecting as 0000.


1. Supplier Bank Account setup (Supplier > Location > Payables hyperlink > Payables Options page
a. Bank ID Qualifier = 002
b. Bank ID = 0002
c. Branch ID = 96446
d. DFI Qualifier = 04
e. DFI ID = 000296446
2. External Accounts > Payment Methods setup
a. Bank = CNBNK
b. Bank Account = CHCK
c. Payment Method = EFT
d. Settle By = Pay Cycle
e. Layout = CPA005
3. Create a Voucher for the Supplier in Step 1
4. Voucher > Payments page
a. Bank = CNBNK
b. Account = CHCK
c. Method = EFT
d. Layout = CPA005
5. Pay the Voucher through the Pay Cycle
6. Check EFT file created
7. File is showing the following for the Bank ID and Branch ID combination:

000096446 -- which is incorrect

The correct formatting should be -- 000296446




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.