Exporting Usage Data into CSV file

Oracle Revenue Management and Billing provides you the facility to export the usage data into a CSV file. However, you can download the usage data in a CSV file only if the billable charges are not yet created. In other words, you can download the usage data only when all the records of a usage data file are in the valid and/or invalid status. Once the usage data is downloaded, you can edit the usage records and reupload the usage data file.
Note: When you download the usage data file using the Export To Excel option, the downloaded file is saved on your system with a unique ID. Once you make the required changes in the downloaded usage data file, you need to save the modified file with the same name as it exists in Oracle Revenue Management and Billing, and then upload the file into the system to replace the existing file.

Procedure

To export usage data into CSV file:

  1. Search for the usage data file in the Usage Data Processing screen.
  2. In the Search Results section, click the link in the Total column corresponding to the usage data file whose usage records you want to export.

    The Usage Data screen appears.

  3. Click the Export TO Excel link in the Search section to download details of all the valid and/or invalid records of a usage data file in a CSV file format.
    A message appears indicating that all valid and invalid records will be exported.
  4. Click OK.
    The system prompts you to save the file.

Related Topics

For more information on... See...
How to search for a usage data file Searching for a Usage Data File