Uploading Response from Auto Clearing House (ACH)

Once the auto clearing house reviews the automatic payment clearing records, the review comments can be shared in the EDI 824 file format. An EDI 824 file may contain the review comments for one or more automatic payment clearing records. You can upload these EDI 824 files and store the review comments in the staging area using the Upload Response from Auto Clearing House (C1-APACK) batch.

On uploading an EDI 824 file, the system checks whether the automatic payment clearing ID specified in each record exists in the system. If so, it creates an automatic payment clearing staging record for the automatic payment clearing ID in the CI_​APAY_​STAGE_​UP table. If the acknowledgement code in the record is set to TE or TR, the system considers that the auto clearing house has rejected the automatic payment clearing record. The reason code (i.e. upload reason) specified in the Reject Upload Reason parameter of the C1-APAY algorithm is stored corresponding to the automatic payment clearing staging record in the CI_​APAY_​STAGE_​UP_​REM table. In addition, the error code (i.e. payment cancelation reason) is stored corresponding to the automatic payment clearing staging record in the CI_​APAY_​STAGE_​UP_​REM table.

However, if the acknowledgement code is blank or if the acknowledgement code is set to a value other than TE or TR, the system considers that the auto clearing house has accepted the automatic payment clearing record. The reason code (i.e. upload reason) specified in the Success Upload Reason parameter of the C1-APAY algorithm is stored corresponding to the automatic payment clearing staging record in the CI_​APAY_​STAGE_​UP_​REM table. In addition, the error code (i.e. NOC reason) is stored corresponding to the automatic payment clearing staging record in the CI_​APAY_​STAGE_​UP_​REM table. In this case, the record may contain more than one error code.

The status of the automatic payment clearing staging record is set to Pending. If the error code (i.e. payment cancelation reason or NOC reason) is invalid, the status of the automatic payment clearing staging record is set to Error. An exception is logged in the CI_​APAY_​STGUP_​EXC table. In addition, if the status of the NOC reason is Inactive in the system, the status of the automatic payment clearing staging record is set to Error and an exception is logged in the CI_​APAY_​STGUP_​EXC table.

The system sets the automatic payment distribution and freeze date (i.e. APAY_​DIST_​FRZ_​DT) for each automatic payment clearing record (for which automatic payment clearing staging record is added in the system) to the payment date (which is stored on the payment event). For more information about the batch, see Oracle Revenue Management and Billing Batch Guide.
Note: An additional table named CI_​APAY_​STGUP_​CHAR is available which the implementation team can use to store additional information about the automatic payment clearing staging record in the form of characteristics.

To ensure that the EDI 824 files are uploaded successfully, you need to set the following parameters in an algorithm which is created using the C1-APAY algorithm type:

  • Line Separator - Used to indicate the character specified in the EDI 824 files to represent the end of line.

  • Field Separator - Used to indicate the character specified in the EDI 824 files to represent the end of data record.

  • Reject Upload Reason - Used to indicate the upload reason which you want to use when the auto clearing house has rejected the automatic payment clearing record.

  • Success Upload Reason - Used to indicate the upload reason which you want to use when the auto clearing house has accepted the automatic payment clearing record with or without Notice to Change (NOC).

Note: You must specify an upload reason which is already defined in the system.

For more information about the EDI 824 file format, see EDI 824 File Format.