Price Item, Parameter, and SQI Upload

There might be situations when the customer wants to move the price item, parameter, and service quantity identifier information from the legacy system to Oracle Revenue Management and Billing (ORMB). In such situations, you can use the Price Item, Parameter, and SQI Upload feature in ORMB to create new price items or edit the existing price items using the File Upload Interface utility. You can also use the Price Item, Parameter, and SQI Upload feature to create new parameters and SQIs using the File Upload Interface utility. However, at present, you cannot edit the existing parameters and SQIs using the Price Item, Parameter, and SQI Upload feature. You can only edit the existing parameters and SQIs from the respective user interface.

Note: If you want to edit an existing price item in the system, you must provide all details of the price item and not just the details which you want to update. This is because the File Upload Interface utility supports the Replace operation and not the Edit operation while editing the price item.

You can upload the price item, parameter, and SQI files in the XML or CSV format using the File Upload Interface utility. You can specify the following in the XML and CSV files along with the basic details of the price item:

  • Parameters and divisions which you want to associate with the price item

  • Characteristics for the price item

  • Division-specific characteristics for the price item

  • Division-specific SQIs for the price item

  • Details of the price item relationship

Note: While uploading the price item file, you need to ensure that the parameters and service quantity identifiers mentioned in the price item file are already present in the system.

You can upload the price items, parameters, and SQIs from the same file or from individual files based on the business requirements. For more information, refer to Uploading Price Items, Parameters, and SQIs from the Same File.

At present, the system does not allow you to configure the approval process for the Price Item, Parameter, and SQI Upload feature. Therefore, you must ensure that the files are pre-approved before uploading them in the system.

Related Topics

For more information on... See...
How to upload a price item file in the XML format using the File Upload Interface utility Uploading a Price Item File in the XML Format
How to upload a price item file in the CSV format using the File Upload Interface utility Uploading a Price Item File in the CSV Format
How to upload a parameter file in the XML format using the File Upload Interface utility Uploading a Parameter File in the XML Format
How to upload a parameter file in the CSV format using the File Upload Interface utility Uploading a Parameter File in the CSV Format
How to upload an SQI file in the XML format using the File Upload Interface utility Uploading an SQI File in the XML Format
How to upload an SQI file in the CSV format using the File Upload Interface utility Uploading an SQI File in the CSV Format

Parent Topic: Oracle Revenue Management and Billing Generic Business Processes