File Type
Oracle Revenue Management and Billing allows you to define file types using which you can upload a usage or payment data file. It is the file type which helps the system to understand how to process the file. The feed type specified in the file type indicates the type of data that you can upload using the file type. You can upload the following types of data using a file type:
-
Banking Usage Data
-
Insurance Usage Data
Note: This file type is not applicable for financial services. -
Payment Upload Data
The following table lists the algorithms that you need to specify while defining file types for uploading usage or payment data:
| Feed Type | Algorithm | Mandatory (Yes or No) | Algorithm Type Shipped with the Product... | Algorithm Type Purpose |
|---|---|---|---|---|
| Payment Upload Data | Mapping algorithm | Yes | C1-CSVUPLPAY | Parses the flat file in the CSV format and maps the columns in the CSV file to various tables in the database. |
| Payment Upload Data | Validation algorithm | Yes | C1-PUPLVALID | Validates a payment data file. |
| Banking Usage Data | Mapping algorithm | Yes | C1-CSVPMALGO | Parses the flat file in the CSV format and maps the columns in the CSV file to an XML schema named Interface. |
| Banking Usage Data | Validation algorithm | No | C1-VLDALGO | Validates a usage data file. |
| Banking Usage Data | To Do algorithm | No | C1_ODBTDALGO | Initiates the approval process for usage records before creating the billable charges. |
| Banking Usage Data | Extract algorithm | No | C1-EXTALGO | Extracts the usage records along with the error messages (if any) in the CSV format. |
| Insurance Usage Data | Mapping algorithm | Yes | C1-CSVPMALGO | Parses the flat file in the CSV format and maps the columns in the CSV file to an XML schema named Interface. |
| Insurance Usage Data | Validation algorithm | No | None Note: You need to design custom algorithm type to validate
insurance usage data.
|
- |
| Insurance Usage Data | To Do algorithm | No | C1_ODBTDALGO | Initiates the approval process for usage records before creating the billable charges. |
| Insurance Usage Data | Extract algorithm | No | C1-EXTALGO | Extracts the usage records along with the error messages (if any) in the CSV format. |
The File Type screen allows you to define, edit, and delete a file type. This screen consists of the following zones:
Related Topics
| For more information on... | See... |
|---|---|
| How to define a file type | Defining a File Type |
| How to edit a file type | Editing a File Type |
| How to delete a file type | Deleting a File Type |
Parent topic: On Demand Billing