Bookshelf Home | Contents | Index | PDF     

Implementation Guide for Oracle Billing Insight > 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 Oracle Billing Insight in batch, 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 Billing Insight.

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

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

1

Username

255

VARCHAR2

Yes

User ID in Oracle Billing Insight

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 Billing Insight Copyright © 2016, Oracle and/or its affiliates. All rights reserved. Legal Notices.