Automatic Payment/Refund on Post Bill Completion

Once a debit bill is completed, the system checks whether an auto pay option or auto pay instruction is available for the automatic payments which is effective on the bill’s due date. If an effective auto pay option or auto pay instruction is available for the automatic payments, the system creates an entry for the debit bill in the CI_​BILL_​ACH table using the auto pay option where the auto pay usage is set to Debit or Credit and Debit. If there are two auto pay options for the same date range – one with auto pay usage set to Debit and another with auto pay usage set to Credit and Debit, the system considers the auto pay option with the highest priority.

Similarly, once a credit bill is completed, the system checks whether an effective auto pay option or auto pay instruction is available for the automatic refunds which is effective on the bill’s due date. If an effective auto pay option or auto pay instruction is available for the automatic refunds, the system creates an entry for the credit bill in the CI_​BILL_​ACH table using the auto pay option where the auto pay usage is set to Credit or Credit and Debit. If there are two auto pay options for the same date range – one with auto pay usage set to Credit and another with auto pay usage set to Credit and Debit, the system considers the auto pay option with the highest priority.

Note: If the Rule Based Auto Pay option is not selected in the Auto Pay tab of the Account screen, the system considers the auto pay options defined for the account. However, if the Rule Based Auto Pay option is selected in the Auto Pay tab of the Account screen, the system considers the rule based auto pay instructions defined for the account. For more information on how rule based auto pay instruction is derived for the account, see C1-RULEAPPRC.

You need to execute the Create Automatic Payments and Refunds (APAYCRET) batch to create an automatic payment or adjustment for automatic refund for each record in the CI_​BILL_​ACH table. For more information about the batch, see Oracle Revenue Management and Billing Batch Guide.