Implementation Guide for Oracle Self-Service E-Billing > Customizing User Management >
Input File Format for Migrating Consumer Users in Batch
Oracle Self-Service E-Billing provides a SQL script for migrating consumer users from a billing system to Oracle Self-Service E-Billing 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 Self-Service E-Billing. Table 6 shows the file format to use when creating the input file for migrating consumer users in batch.
Table 6. Input File Format for Migrating Consumer Users in Batch
|
|
|
|
|
|
1 |
Username |
36 |
VARCHAR2 |
Yes |
User ID for Oracle Self-Service E-Billing |
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 |
|