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)
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.
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|
|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.
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