E1: 04: Create A/P Bank Tape - PPD Format (R04572T1) Incorrectly Leaves Record 6 Field 4, Check Digit, (Pos. 12) Blank Even if the Bank Transit field (TNST) Has a 9-Digit Number. (Doc ID 2880233.1)

Last updated on DECEMBER 01, 2022

Applies to:

Symptoms

Create A/P Bank Tape - PPD Format (R04572T1) incorrectly leaves Record 6 field 4, Check Digit, (pos. 12) blank even if the Bank Transit field (TNST) has a 9-digit number. If the TNST field has a 9-digit number, then R04572T1 should use the 9th digit as the Check Digit in position 12 of Record 6.

If the TNST field only has an 8-digit number, but the Check Digit field (CHKD) has a value in it, then the value of the CHKD field should be used.

The Record 6 field 4, Check Digit, (pos. 12), should only be blank if the TNST has 8 digits and the CHKD is blank.

See also Nacha’s ISO 20022-to-ACH Mapping Guide & Tool on the ISO 20022 page on NACHA’s website. This was last updated on December 2021.

STEPS TO REPRODUCE

1. P0030G: set up GL bank account
2. AAI: set up PB AAI to point to this GL bank account
3. Batch Versions: set up a version for R04572T1 - PPD format, and submit its version specs
4. P0417: set up the payment instrument for PPD to point to this R04572T1 version
5. P04012: set up three suppliers with this payment instrument as the default, and uncheck the pre-note code field
6. P0030A: set up a bank account for the suppliers:
   1. Supplier 1:
      1. Make sure that the Bank Transit Number only has 8 digits
      2. Make sure that there IS a value in the Control Digit field
   2. Supplier 2:
      1. Make sure that the Bank Transit Number has 9 digits
      2. Make sure that there is NO value in the Control Digit field
   3. Supplier 1:
      1. Make sure that the Bank Transit Number only has 8 digits
      2. Make sure that there is NO value in the Control Digit field
7. P0411: create a voucher for each supplier and post them
8. Run R04570 for the suppliers
9. P04571: inquire on the payment group created and write it
10. P0457: create a text file for the payment
11. Verify the values, if any, in the Records 6 for position 12 to 12 of the text file that was created

DESIRED OUTCOME

R04572T1 should check both the 9^th character of the TNST field and the CHKD field and use either of the values in these fields if only one is present (whichever one is present). If both are present, then the CHKD value should have priority.

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.