EAP 9.2: Pay Cycle Error - Payment Amount Exceeds The Limit Of 10 Digits For ACH/EFT Payments
Last updated on DECEMBER 28, 2017
Applies to:PeopleSoft Enterprise FIN Payables - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.
An issue has been detected with the Payment Selection process (Application Engine Program AP_APY2015), when running Pay Cycles for Payment Method Automated Clearing House. If the Pay Cycle Total Amounts calculated by the transactions picked up by Payment Selection is greater than 99,999,999.99 USD, the Pay Cycle ends in 'No Work' status when processing NACHA Payments, and Pay Cycle Errors get generated (Page PYCYCL_ERR).
Per NACHA regulations (National Automated Clearing House Association) for Automated Clearing House (ACH) Payments, the below limits are established:
- Control Total Limit is 9,999,999,999.99 (10,2)
- Single Payment Limit is 99,999,999.99 (8,2)
This seems to be a regression, as <Bug 21930817> (AP: Pay Cycle Error - Total Amount Exceeds The Bank Limit Of 10 Digits For ACH), reporting the same scenario, was addressed in PeopleSoft Enterprise FSCM 9.2 Image #15, but on Image #18, the issue seems to have returned.
1.- Configure an External Bank Account for ACH Payment Method, with below settings:
- Form ID = EFT2
- Layout = CCD+
- Settle By Financial Gateway
2.- Add 2 Vouchers for Supplier ID USA0000002 as follows:
- Voucher1 $99999999.99 - Separate Payment box checked
- Voucher2 $99999999.99 - Separate Payment box checked
3.- Create a brand new ACH Payment Method Pay Cycle with the selection criteria targeting the 2 created Vouchers
4.- Run the Payment Selection on this new Pay cycle ID
5.- Confirm that the Pay Cycle is in a Status of 'No Work', even though the AP_APY2015 AE Program ended in Success
6.- Click on the Pay Cycle Error link, which will open the Pay Cycle Errors page (PYCYCL_ERR), where some Error Messages have been stored
To gather more information concerning this scenario and its related problem, refer to the available Replication Steps Word Document here linked containing the complete configuration and the replication steps necessary to reproduce the issue.
" Error Type: Payment Error
Message Text: The payment amount exceeds the limit of 10 digits for NACHA Entry Detail Record
Description: Banks limit ACH/EFT payments using the CCD, CCD+, PPD, and CTX layout to 10 digits in length, the total amount of the voucher(s) exceeds the 10 digit limit. The voucher(s) comprising this payment will need to be updated to reduce the total amount of the payment to 10 or less digits in length. "
Pay Cycle is not working properly, and does not allow the generation of the needed ACH payments.
Payment Selection process should be able to handle this scenario, and issue clear Error Messages, explaining into detail when the rules are not being met, and why.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms