Retry Automatic Payment

In the Freeze Payments on Notification feature, the system enables you to freeze or cancel the automatic payment based on the review comments received from the auto clearing house. Until now, the system did not allow to resend the automatic payment clearing records to the auto clearing house for review in case of rejection. Now, the system enables you to resend the rejected automatic payment clearing records to the auto clearing house for review.

To enable this feature, you need to set the C1-APMSG characteristic type for the required divisions. Here, you must set the maximum automatic payment reattempts allowed while using the Freeze Payments on Notification feature.

A new batch named C1-APRCH is introduced in this release. You need to execute this batch in between the following two batches - C1-APACK and APAYRA. The C1-APRCH batch considers the automatic payment clearing staging records which are in the Pending status from the CI_​APAY_​STAGE_​UP table. The system then checks whether the APAY_​UPL_​RSN_​TYPE column corresponding to the automatic payment clearing staging record is set to SUCC or CANC. If the APAY_​UPL_​RSN_​TYPE column corresponding to the automatic payment clearing staging record is set to SUCC, the system updates the last extract date of the automatic payment clearing staging record to the extract date which is available corresponding to the clearing record in the CI_​APAY_​CLR_​STG table. However, if the APAY_​UPL_​RSN_​TYPE column corresponding to the automatic payment clearing staging record is set to CANC, the system checks whether the number of automatic payment clearing staging records for the clearing record is equal to or greater than one. If the number of automatic payment clearing staging records for the clearing record is equal to or greater than one, the system increments the retry count of the clearing ID. If the retry count is greater than zero and less than the maximum automatic payment reattempt limit defined for the division, the system does the following:

  • Recalculates the extract date and stamps it against the corresponding clearing record in the SCHED_​EXTRACT_​DT column of the CI_​APAY_​CLR_​STG table

  • Clears the BATCH_​NBR column of the corresponding clearing record in the CI_​APAY_​CLR_​STG table

  • Clears the APAY_​DIST_​FRZ_​DT column of the corresponding clearing record in the CI_​APAY_​CLR_​STG table

Finally, the status of the automatic payment clearing staging record is set to RETR. A To Do is created using the C1-APRET To Do type to notify that the status of an automatic payment clearing staging record is changed to RETR.