Freeze Payments on Notification

Oracle Revenue Management and Billing facilitates you to create automatic payments and refunds when the automatic payment option is enabled for an account. A clearing record is created for each automatic payment and refund in the system. You can then send the automatic payment and refund clearing records to the auto clearing house for verification. The system provides the mechanism to extract the automatic payment clearing records in a flat file. You can then send the flat file to the auto clearing house for verification. However, the implementation team will have to write the custom logic to extract the automatic refund clearing records in a file which you can then send to the auto clearing house for verification.

Once the auto clearing house reviews the automatic payment clearing records, the system allows you to upload review comments received in the EDI 824 file format. On uploading an EDI 824 file, an automatic payment clearing staging record is created for each valid automatic payment clearing ID. The data received from the auto clearing house is stored in the following staging tables:

• CI_​APAY_​STAGE_​UP

• CI_​APAY_​STAGE_​UP_​REM

• CI_​APAY_​STGUP_​CHAR

The implementation team will have to write the custom logic to upload review comments for automatic refund clearing records in the above mentioned staging tables. The review comments for automatic payment clearing records can be received in the form of reason (i.e. upload reason) and error codes (i.e. payment cancelation reason or NOC reason) which will help you to determine whether the automatic payment must be frozen or cancelled in the system. Similarly, the review comments for automatic refund clearing records can be received in the form of reason (i.e. upload reason) and error codes (i.e. void status reason) which will help you to determine whether the refund request must be voided and refund adjustments must be cancelled in the system.

Once the review comments are received from the auto clearing house, you can do the following:

• Freeze or cancel the automatic payments

• Void the refund requests and cancel the refund adjustments

For more detailed information about the freeze payments on notification process, see Freeze Payments on Notification Process.

The system allows you to define upload reasons, payment cancelation reasons, NOC reasons, and void status reasons. The system also allows you to edit and delete the automatic payment and refund clearing staging records through the user interface. However, you can edit an automatic payment or refund clearing staging record when it is in the Pending or Error status, and you can delete an automatic payment or refund clearing staging record when it is in the Pending status. During the freeze payments on notification process, the automatic payment and refund clearing staging records go through various statuses in its lifecycle. For more information about the statuses, see Automatic Payment or Refund Clearing Staging Record Status Transition.

For more information on how to setup the freeze payments on notification process, see Prerequisites.

Related Topics

Parent Topic: Oracle Revenue Management and Billing Generic Business Processes