Implementation Guide for Oracle Billing Insight > Customizing User Management >
Input File Format for Migrating Consumer Users in Batch
Oracle Billing Insight provides a SQL script for migrating consumer users from a billing system to Oracle Billing Insight in batch. To use this script, you must create a pipe-delimited TXT data input file in the following format. For details on running the consumer user migration script, see Administration Guide for Oracle Billing Insight. Table 14 shows the file format to use when creating the input file for migrating consumer users in batch.
Table 14. Input File Format for Migrating Consumer Users in Batch
|
|
|
|
|
|
1 |
Username |
36 |
VARCHAR2 |
Yes |
User ID for Oracle Billing Insight |
2 |
Email Address |
255 |
VARCHAR2 |
No |
The user's email address |
3 |
Billing System ID |
255 |
VARCHAR2 |
Yes |
Billing system ID |
4 |
Account Number |
255 |
VARCHAR2 |
Yes |
Account number |
5 |
Creation Date |
MM/DD/YYYY |
DATE |
No |
The date the account was created |
6 |
My Bill is Ready for Viewing Flag |
1 |
CHAR |
No |
Y - Yes or N-No |
7 |
My Payment Account Has Been Created, Deleted, or Updated Flag |
1 |
CHAR |
No |
Y - Yes or N-No |
8 |
My Payment is Due in (X) Days Flag |
2 |
CHAR |
No |
Y - Yes or N-No |
9 |
My Payment was submitted Flag |
1 |
CHAR |
No |
Y - Yes or N-No |
10 |
My Recurring Payment is Setup or Modified Flag |
1 |
CHAR |
No |
Y - Yes or N-No |
11 |
My Recurring Payment is Less Than the Total Amount Due (Threshold Exceeded) Flag |
1 |
CHAR |
No |
Y - Yes or N-No |
12 |
My Payment was Made Successfully Flag |
1 |
CHAR |
No |
Y - Yes or N-No |
13 |
My Payment Failed Flag |
1 |
CHAR |
No |
Y - Yes or N-No |
14 |
My Credit Card is About to Expire Flag |
1 |
CHAR |
No |
Y - Yes or N-No |
15 |
My Batch Report is Ready Flag |
1 |
CHAR |
No |
Y - Yes or N-No |
16 |
Flex Field 1 |
255 |
VARCHAR2 |
No |
Flexible field |
17 |
Flex Field 2 |
255 |
VARCHAR2 |
No |
Flexible field |
18 |
Flex Field 3 |
255 |
VARCHAR2 |
No |
Flexible field |
19 |
Flex Field 4 |
255 |
VARCHAR2 |
No |
Flexible field |
20 |
Flex Field 5 |
19 |
NUMBER |
No |
Flexible field |
|