Implementation Guide for Oracle Self-Service E-Billing > Customizing User Management >
Input File Format for Canceling Payments for Consumer Users in Batch
Oracle Self-Service E-Billing provides a SQL script for canceling payments configured for consumer users 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 script to cancel user payments, see Administration Guide for Oracle Self-Service E-Billing. Table 8 shows the file format to use when canceling payments configured for consumer users in batch.
Table 8. Input File Format for Canceling Payments for Consumer Users in Batch
|
|
|
|
|
|
1 |
Billing System ID |
20 |
VARCHAR2 |
No |
The ID of the biller's system in Oracle Self-Service E-Billing |
2 |
Billing Account Number |
20 |
VARCHAR2 |
Yes |
The user's billing account number |
|