ECM: Payment Batch Grouping Is Not Working As Described In PeopleBooks

(Doc ID 2331062.1)

Last updated on DECEMBER 04, 2017

Applies to:

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

Symptoms

When creating ACH payments from AP, using CCD+ NACHA delivered layout with delivered Payment Grouping Rule “Bank”, the payments are not being grouped as they should be.

The ACH payments are being settled via the Financial Gateway, and the PMT_DISPATCH App Engine is creating the payment file(s).  Payments originating from multiple business units, from the same bank and bank account, are being processed.  The “Bank” Payment File Grouping Rules define that payment from the same “BANK_CD” and “BANK_SETID” should be grouped into a single file.

The Payment Batch Grouping Rules further define that payments should be grouped that have similar “AMOUNT_CURRENCY_CD”, “BANK_ACCT_KEY”, “BUSINESS_UNIT”, and “PYMNT_DT”.

EXPECTED BEHAVIOR
It is expected that within the payment file, payments belonging to a Business Unit would be grouped together under a unique Batch Header Record (also known as the Record Type Code “5” line in the payment file). However, this is not what is happening. Payments from multiple Business Units are being grouped together in the same Batch Header Record, and the Company Name is being pulled from the AP Business Unit description field for the first BU in the group.


STEPS
1. Set Layout Catalog for CCD+ with Grouping Rule set to BANK.

2. Grouping Rule BANK defined with following Payment Batch Grouping Rules:

  “AMOUNT_CURRENCY_CD”, “BANK_ACCT_KEY”, “BUSINESS_UNIT”, and “PYMNT_DT”.

3. External Account setup for USBNK.
  - Default settlement set to Financial Gateway with CCD+ Layout

4. Create 1st voucher.  Sample data as follows:
        BU US002
        Invoice No. INV17
        Voucher ID 00000017

5. Create 2nd voucher.  Sample data as follows:
        BU US005
        Invoice No. INV8
        Voucher ID V888

  Note that the BU is different from 1st voucher.

6. Run Pay Cycle.

7. Process Financial Gateway (FG) Electronic Payments.

8. Dispatch Payment.

9. Open generated payment file.

   Only one level ‘5’ was generated.

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