Uploading a Usage Data File

Prerequisites

To upload a usage data file, you should have:

  • File types defined in the application

  • Usage data in the required CSV file format

  • File group using which you want to upload the usage data files is in Open status

Procedure

To upload a usage data file:

  1. Click the Menu link in the Application toolbar.
    A list appears.
  2. From the Main menu, select Billing Management and then click Usage Data Processing.
    The Usage Data Processing screen appears.
  3. Click the Upload link in the upper right corner of the Search zone.

    The Upload Usage Data File screen appears. It contains the following fields:

    Field Name Field Description Mandatory (Yes or No)
    Billing Method Used to specify the type of billing you want to use for the usage data file. The valid values are:

    • Adhoc Billing

    • Regular Billing

    		 Yes
    File Group Used to specify the file group to which you want to add the usage data file.
    Note: This field appears when you select the Adhoc Billing option from the File Group list. You can only view those file groups that are in the open status and to which you have access in the File Group list.
    		 Yes (Conditional)
    Note: If you select the billing method as Adhoc Billing, you have to specify the file group to which you want to add the usage data file.
    Bill After Date Used to specify the date after which the bills must be generated for the usage data file. By default, the current date appears in this field.
    Note: If you have selected the billing method as Adhoc Billing, this field appears in read-only mode and displays the bill after date as defined for the selected file group. If you have selected the billing method as Regular Billing then this field is enabled displaying the current date.
    		 Yes (Conditional)
    Note: If you select the billing method as Regular Billing, you have to specify the bill after date.
    Default Usage Start Date Used to specify the date from when the price item was used. The default usage start date is used when the start date is not specified for a record in the usage data file. By default, the current date appears in this field. You can change the default usage start date, if required.
    Note: If you have selected the billing method as Adhoc Billing, this field appears in read-only mode and displays the default usage start date as defined for the selected file group. If you have selected the billing method as Regular Billing then this field is enabled displaying the current date. The default usage start date cannot be later than the default usage end date.
    		 Yes (Conditional)
    Note: If you select the billing method as Regular Billing, you have to specify the default usage start date.
    Default Usage End Date Used to specify the date till when the price item was used. The default usage end date is used when the end date is not specified for a record in the usage data file. By default, the current date appears in this field. You can change the default usage end date, if required.
    Note: If you have selected the billing method as Adhoc Billing, this field appears in read-only mode and displays the default usage end date as defined for the selected file group. If you have selected the billing method as Regular Billing then this field is enabled displaying the current date. The default usage end date cannot be earlier than the default usage start date.
    		 Yes (Conditional)
    Note: If you select the billing method as Regular Billing, you have to specify the default usage end date.
    File Type Used to specify the type of usage data file. Yes
    Replace Existing File Used to indicate whether you want to replace any existing file in the system. You must select this check box when you want to upload the same file once again. No
    File Name Used to specify the name and path of the usage data file that you want to upload.
    Note: You can also click the Browse button corresponding to this field to browse to the location where the usage data file is available in the system.
    		 Yes
  4. Enter the required details.
  5. Click the Browse button corresponding to the File Name field.
    The Choose File to Upload dialog box appears.
  6. Browse to the location where the usage data file that you want to upload is available.
  7. Click Open.
    The usage data file name and path appears in the File Name field.
  8. Click Upload.

    A message appears indicating that the usage data file has been uploaded successfully. If an error occurs while parsing, the usage data file is not uploaded in the system.

    Note:

    The validation process starts immediately after the file is uploaded in the system. If a usage record is successfully validated, the status of the usage record is changed to Valid. And, if a usage record could not pass through the validation process, the status of the usage record is changed to Invalid. You can view the details of the uploaded file and its records in the Usage Data Processing screen.

    If the usage data file size exceeds the file size limit set in the C1-ODBFC feature configuration, a batch job is created using the Upload and Validate Usage Data File (C1-ODFU) batch. A message appears indicating the batch job ID. This batch job uploads and validates the usage data file. You can change the file size limit using the On Demand Billing (C1-ODBFC) feature configuration. For more information on the Upload and Validate Usage Data File (C1-ODFU) batch, see Oracle Revenue Management and Billing Batch Execution Guide.

    The number of usage records that are parsed and mapped in an XML file depends on the value defined for the Staging XML Size option type in the On Demand Billing (C1-ODBFC) feature configuration. For example, if the Staging XML Size option type is set to 100 and a usage data file contains 500 records, then the system creates 5 XML files - each containing 100 records.

    If a batch job is created automatically, the number of usage records that are validated in each work unit depends on the value defined for the Validation Chunk Size option type in the On Demand Billing (C1-ODBFC) feature configuration.

    On successful completion of the Upload and Validate Usage Data File (C1-ODFU) batch, a To Do entry is created using the C1-ODFU To Do type. You can view this To Do entry when you are assigned a To Do role which is mapped to the C1-ODFU To Do type. This To Do indicates whether the batch was successfully executed or not. If the batch was successfully executed, it indicates the following:

    • Number of records that were uploaded in the system

    • Number of records which were successfully validated

    • Number of records which could not pass through the validation process

    • Number of records which failed to validate due to some technical reasons

  9. Click OK in the message box.
    Once a usage record is successfully validated, the status of the usage record is changed to Valid. And, if a usage record could not pass through the validation process, the status of the usage record is changed to Invalid.

Related Topics

For more information on... See...
Usage Data Processing screen Usage Data Processing
Search zone Search
How to set the On Demand Billing (C1-ODBFC) feature configuration Setting the C1-ODBFC Feature Configuration