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
Position
Names
Maximum Length
Data Type
Required
Description

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

Implementation Guide for Oracle Self-Service E-Billing Copyright © 2014, Oracle and/or its affiliates. All rights reserved. Legal Notices.