Bookshelf Home | Contents | Index | PDF     

Implementation Guide for Oracle Self-Service E-Billing > Customizing User Management >

Input File Format for the DefUsrAcctRelationship Job

To use the DefUsrAcctRelationship Command Center job to add or remove user-account relationships in batch from Oracle Self-Service E-Billing, create a pipe-delimited TXT data input file in the following format. For details on configuring and running the DefUsrAcctRelationship job, see Administration Guide for Oracle Self-Service E-Billing.

Table 5 shows the file format to use when creating the input file for the DefUsrAcctRelationship job.

Table 5. Input File Format for the DefUsrAcctRelationship Job
Position
Names
Maximum Length
Data Type
Required
Description

1

Username

255

VARCHAR2

Yes

User ID in Oracle Self-Service E-Billing

2

Billing System ID

255

VARCHAR2

Yes

Billing system ID

3

Account Number

255

VARCHAR2

Yes

Account number

4

Add or Remove Flag

1

CHAR

Yes

A - Add or R -Remove

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