Administration Guide for Oracle Billing Insight > Administering the Database >

Deleting B2C Users in Batch Mode

Oracle Billing Insight provides a SQL command script that lets you delete B2C users along with their associated billing accounts and payment configurations.

You must create a UTF8 input file with the required user information to use this script. For details about the input file, see Implementation Guide for Oracle Billing Insight.

For each user IDs defined in the ASCII file, the delete B2C users script soft deletes the users from the Oracle Billing Insight database. In addition, the script also performs the following tasks:

• Disassociates the billing accounts from each user.
• Cancels all scheduled and recurring payments each user has configured.
• Removes all payment accounts associated with each user.

To delete B2C users and associated activity

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

   SQL>set serveroutput on size 100000

   SQL>exec edx_pkg_del_user_act.main('Input_File_Directory', 'Delete_B2C_Users_Filename.dat');

   SQL>exit;

   where:

   • Input_File_Directory is the directory that contains the input file.
   • Delete_B2C_Users_Filename.dat is the name of the input file.

     Records that are invalid or generate an error display on screen.