Administration Guide for Oracle Billing Insight > Administering the Database >

Migrating B2C Users in Batch Mode

Oracle Billing Insight provides a SQL command script that lets you migrate B2C users from your billing system to Oracle Billing Insight 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 Billing Insight.

To migrate B2C users to Oracle Billing Insight in batch mode

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> 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.