Administration Guide for Oracle Billing Insight > Administering the Database >

Canceling Payments for B2C Billing Accounts

Oracle Billing Insight provides a SQL command script that lets you cancel, or delete, all payment types configured for one or more billing accounts. The script reads the billing account numbers defined in the UTF8 input file and cancels the following payment types configured for this account.

• ACH. One-time, scheduled, and recurring payments.
• Credit Card. Scheduled and recurring payments.

For details about the input file, see Implementation Guide for Oracle Billing Insight.

To cancel payments for B2C billing accounts

• Using SQL*Plus, log in to the Oracle Billing Insight instance as the OLTP schema owner.
• Upload the input file to the database server.
• Run the following commands using SQL*Plus:

  SQL>set serveroutput on size 100000

  SQL> exec edx_pkg_cxl_pymnt.main('Input_File_Directory', 'Cancel_Payments_Filename.dat')

  SQL>exit;

  where:

  • Input_File_Directory is the directory where the input file is located.
  • Cancel_Payments_Filename.dat is the name of the input file.

    Records that cannot process successfully are displayed in a list on the screen.