Bookshelf Home | Contents | Index | PDF     

Implementation Guide for Oracle Billing Insight > Payment Processing >

Input File Format for Canceling Payments for Consumer Users in Batch

Oracle Billing Insight 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 Billing Insight.

Table 69 shows the file format to use when canceling payments configured for consumer users in batch.

Table 69. 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 Billing Insight

2

Billing Account Number

20

VARCHAR2

Yes

The user's billing account number

    
Implementation Guide for Oracle Billing Insight Copyright © 2016, Oracle and/or its affiliates. All rights reserved. Legal Notices.