EAP 9.2: Pay Cycle Error - Payment Amount Exceeds The Limit Of 10 Digits For ACH/EFT Payments (Doc ID 2178411.1)

Last updated on AUGUST 31, 2016

Applies to:

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

Symptoms

 

ISSUE:

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.

REPLICATION STEPS:

     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 MESSAGE:

     " 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. "

ACTUAL RESULT:

Pay Cycle is not working properly, and does not allow the generation of the needed ACH payments.

EXPECTED RESULT:

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.

 

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