Administration Guide for Oracle Self-Service E-Billing > Administering the Database >

Deleting B2C Users in Batch Mode

Oracle Self-Service E-Billing 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 Self-Service E-Billing.

For each user IDs defined in the ASCII file, the delete B2C users script soft deletes the users from the Oracle Self-Service E-Billing 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 Self-Service E-Billing 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.