1. Using Revenue Management
  2. How Billing Data Import Data Is Processed

How Billing Data Import Data Is Processed

You can import billing data into Revenue Management to offset the contract asset accounts for your revenue contracts.

Use the Billing Data Import template to enter billing data into Revenue Management for third party billing applications. The template contains a detailed instruction worksheet on how to prepare and upload your billing data. The template also provides field-level bubble help to aid you with entering your data. You can then use the import billing data process to import the billing data.

To access the template, complete the following steps:

  1. Navigate to the File-Based Data Import for Oracle Financials Cloud guide.

  2. In the Table of Contents, click File-Based Data Imports.

  3. Click Billing Data Import.

  4. In the File Links section, click the link to the Excel template.

Follow these guidelines when preparing your data in the worksheet:

  • Enter the required information for each column. Refer to the tool tips on each column header for detailed instructions.

  • Don't change the order of the columns in the template.

  • You can hide or skip the columns you don't use, but don't delete them.

Settings That Affect the Billing Data Import Process

The Billing Data Import template contains an instructions tab and a tab that represents the table where the billing lines are loaded:

Spreadsheet Tab

Description

Instructions and DAT Generation

Contains instruction information about preparing and loading data, the format of the template, submitting the Import Billing Data process, and correcting import errors.

Billing Line Details

Enter information about the billing lines to be imported from the billing application for the revenue lines.

When entering data in the Billing Data Import template, ensure the following:

  1. The value of the following column should be the same in the Billing Line Details worksheet of the Billing Data Import template and all of the tables (worksheets) of the Revenue Basis Data Import template for all related rows:

    • Source document type code

  2. The value for the following columns should be the same in the Billing Line Details worksheet of the Billing Data Import template and the VRM_SOURCE_DOC_LINES and VRM_SOURCE_DOC_SUB_LINES worksheets of the Revenue Basis Data Import template for related rows:

    • Source document line unique identifier 1 through 5

    • Source document line unique identifier character 1 through 5

    • Source system

How Billing Data Is Processed

Load the Data

  1. After you finish preparing the data in the worksheet, click the Generate DAT File button. The process generates a Zip file that contains the DAT file.

  2. Click Navigator > File Import and Export.

  3. Click the Plus icon in the Search Results table.

  4. Browse and upload the Zip file that has been generated.

  5. Select fin/revenueManagement/import as the account.

  6. Click Save and Close so that the file is placed in the SFTP server or UCM.

  7. Navigate to the Scheduled Processes page and click Schedule New Process.

  8. Select the Load Interface File for Import process.

  9. Select Import Billing Data as the import process.

  10. Select the data file that was placed in the server.

  11. Submit the process to load the data into the interface tables.

  12. Review the results of the process.

Correct Load Errors and Regenerate and Load the DAT File

If the load of the DAT file fails on any row, the Load Interface File for Import process ends in error and the Load File to Interface child process ends in either warning or error. All rows that were loaded from the DAT file are deleted, even those rows that loaded successfully. This lets you edit the problematic data in the spreadsheet and resubmit it without the need to separate the successful rows from the rows that need modification.

  1. Review the log and output files of the Load File to Interface child process for information about the data that caused the failure.

  2. Correct the data in the template you used as part of the steps outlined in the Load the Data section.

  3. Repeat steps 1 and 2 in the Load the Data section.

  4. Repeat all these steps until all data is loaded successfully.

Recommendations for Loading Data

You can generate the DAT file using either of these methods:

  • Populate the billing data in the template.

  • Use SQL, ODI, or any similar tool to extract billing data into a DAT file similar in structure to the DAT file generated by the template.

After loading your billing data, you must:

  1. Run the Import Billing Data process to match the billed amount to each corresponding promised detail line.

  2. Run the Recognize Revenue of Customer Contracts process to generate the journal entries to account for the billing of the performance obligation.

If the bill lines fail any validations during processing, they're deleted from the interface tables. In this case, you need to correct the errors and reimport the corrected bill lines.

Once your billing data is processed, you can then review the billed amount at the promised detail, performance obligation, and contract header levels. You can also view the accounting for a specific contract by navigating to the Edit Customer Contracts page and selecting View Accounting.

Related Topics