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

Last updated on NOVEMBER 02, 2016

Applies to:

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

Symptoms

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.

STEPS

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

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