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

Migrating B2C Users in Batch Mode

Oracle Self-Service E-Billing provides a SQL command script that lets you migrate B2C users from your billing system to Oracle Self-Service E-Billing in batch mode.

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.

To migrate B2C users to Oracle Self-Service E-Billing in batch mode

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> exec EDX_PKG_MIG_END_USER.main('Input_File_Directory', 'Migrate_End_Users_Filename.dat');

   SQL> exit;

   where:

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