ECM: Payment Batch Grouping Is Not Working As Described In PeopleBooks
(Doc ID 2331062.1)
Last updated on FEBRUARY 05, 2019
Applies to:PeopleSoft Enterprise FIN Cash Management - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.
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”.
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.
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:
Invoice No. INV17
Voucher ID 00000017
5. Create 2nd voucher. Sample data as follows:
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.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document