Voiding Refund Requests and Canceling Refund Adjustments

Once the auto clearing house reviews the automatic refund clearing records and shares the review comments, the implementation team will have to store the review comments in the following staging tables:

• CI_​APAY_​STAGE_​UP - Used to store the automatic payment or refund clearing staging record for an automatic payment or refund clearing record, respectively. The status of the automatic payment or refund clearing staging record must be set to Pending.

• CI_​APAY_​STAGE_​UP_​REM - Used to store the reason and error codes of each automatic payment or refund clearing staging record.

• CI_​APAY_​STGUP_​CHAR - Used to store additional information about the automatic payment or refund clearing staging record in the form of characteristics.

The review comments must be received in the form of reason (i.e. upload reason) and error codes (i.e. void status reason) for an automatic refund clearing record. On executing the Cancel Automatic Refunds (AREFRA) batch, it checks whether the reason and error codes specified in the automatic refund clearing staging record exist in the system. If the reason and error codes exist in the system, the system executes the algorithms attached to the reason code in the specified sequence. If the type of reason code is Cancel, the attached algorithm changes the status of the refund request to Voided and the corresponding refund adjustments are canceled. If the type of reason code is Success, no changes are made to the refund request and refund adjustments. Finally, the status of the automatic refund clearing staging record is changed to Complete.

If the reason code and/or error code (i.e. upload reason, void status reason) specified in the automatic refund clearing staging record does not exist in the system, the status of the automatic refund clearing staging record is changed to Error.