How Units of Production Import Data Is Processed

Use the Import Units of Production import process to upload production information from another system.

You can download a Units of Production spreadsheet template to use to prepare your data. The template contains an instruction sheet to help guide you through the process of entering your information.

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 Import Units of Production.

  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.

  • Do not change the order of the columns in the template.

  • You can hide or skip the columns you do not use, but do not delete them.

Settings That Affect the Import Units of Production Process

The units of production import template contains an instructions tab, plus a tab that represents the table where the data is loaded:

Spreadsheet Tab

Description

Instructions and CSV Generation

Contains instruction information about preparing and loading data and the format of the template.

FA_PRODUCTION_INTERFACE

Enter production information, such as the production units, the units of measure, and the periods for the production.

How Units of Production Are Processed

After submitting the production details using the Import Units of Production import template, run the Upload Units of Production process by submitting the asset book as the parameter.

To submit the Upload Units of Production process:

  1. Navigate to the Scheduled Processes page.

  2. Click the Schedule New Process button.

  3. Search for the Upload Units of Production process.

  4. Click OK.

  5. Select the book.

  6. Click Submit.