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 laterInformation 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 | ||
| 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