E1: 04: Create A/P Bank Tape - PPD Format Incorrectly Leaves The Check Digit Field Of Record 6 Blank Even If There Is A Value In The Control Digit Field Of The Supplier's Bank Account Record (F0030, P0030A, R04572T1)

(Doc ID 2338700.1)

Last updated on DECEMBER 12, 2017

Applies to:

JD Edwards EnterpriseOne Accounts Payable - Version 9.0 and later
Information in this document applies to any platform.

Symptoms

When creating EFT text files for the PPD format using the Create A/P Bank Tape - PPD Format (R04572T1) print program UBE, the Check Digit field of record 6, position 12-12, incorrectly shows either a blank if the Bank Transit Number (TNST) has only 8 characters, or the 9th character if the Bank Transit Number field has 9 characters.

This is even though the Control Digit (CHKD) has a value in it, and the explanation for record 6, position 12-12, in KM article 'E1: 04: How To Create Electronic Funds Transfer (EFT) Automatic Payments For PPD, CTX and IAT Formats' (R04572T1, R04572T2, R04572T3) (<Document 2195563.2>) on the 'PPD Format' tab states the following:

"Control Digit (CHKD) form the Supplier Bank Account (P0030A)"

Per the NACHA’s ISO 20022 Mapping Guide & Tool, https://www.nacha.org/iso-20022-mapping, "NACHA ISO 20022 Guide for pain.001 (credit transfer) Nov 2016" states the following for this field:

    Length Position M, R, O Content Description ISO 20022 Mapping Comments
Entry Detail Record (6) - PPD
1 Record Type Code 1 01-01 M Code identifying the Entry Detail Record is "6" Not mapped, set by ODFI system to “6”
3 Receiving DFI Identification 8 04-11 M First 8 digits of the receiver's bank transit routing number Maps to first 8 digits: ...
4 Check Digit 1 12-12 M Last digit of the receiver's transit bank routing number Maps to 9th digit: …

Note that Field 3 and 4 are combined for Record 6 as the Check Digit is the last (or 9th) digit of the transit routing number.

 

Changes

 

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