1. Using Inventory Management
  2. Considerations for Using the Reservation Interface

Considerations for Using the Reservation Interface

You can create inventory reservations automatically from any internal or external application using the Reservation Interface.

Use the control file InvReservationsInterface.ctl and the Manage Reservation Interface process to load data from legacy and third-party applications. Use the Load Interface File for Import process to load your reservation data into the INV_RESERVATION_INTERFACE interface table.

Consider these tips when using the Reservation Interface:

  • Preparing table data

  • Loading data

  • Excel template format

  • Recommendations for loading reservation data

  • Importing loaded data

Preparing Table Data

Here are the steps for preparing the table data:

  1. Prepare the data for each interface table using the worksheet in Reservation Interface template.

  2. Refer to the bubble text on each column header for detailed instructions on preparing the data in that column, or for a description of the required data and data type.

  3. Common tasks for preparing table data include setting up for the data merge and searching for internal identifiers.

Loading Data

  1. After you finish preparing the data in the parent and child sheets, click the Generate CSV File button to generate a ZIP file containing one or more CSV files.

  2. Load your data from the CSV file into the interface tables using the Load Interface File for Import scheduled process. For more information, see the Documentation tab for the Load Interface File for Import scheduled process in Oracle Enterprise Repository for Oracle Fusion Applications.

Excel Template Format

Here are the details for the excel template format:

  • Each interface table is represented as a separate Excel sheet.

  • The first row in each sheet contains column headers that represent the interface table columns.

  • The columns are in the order that the control file expects them.

    • Don't change the order of the columns in the Excel sheets. Changing the order of the columns can cause the load process to fail.

    • You can hide columns that you don't intend to use, but you can't delete columns. Deleting columns can cause the load process to fail.

  • Each column header contains bubble text about the expected data type and, in some cases, instruction text.

  • You must enter data that conforms to what the control file can accept and process for the associated database column

    • Date fields must be entered in YYYY/MM/DD format.

    • Amount columns must not contain a thousands separator and must use a period (.) as the decimal separator.

    • Columns that must be whole numbers have data validation to allow only whole numbers.

  • Columns are formatted, where applicable, to match the expected data type to eliminate data entry errors.

  • For columns that require internal ID values, refer to the bubble text for additional guidance about finding these values.

Recommendations for Loading Reservation Data

In general, we recommend that:

  • You build an export file in the same format as the Reservations Interface described in this template. No matter which method you use to extract data, you need to create staging tables and a spreadsheet that mirrors the tabs contained in this template. You can use SQL, ODI, or a similar tool to extract data into a CSV file with the same structure as the CSV file generated by this template.

  • Your spreadsheet must have the same columns, and the columns must be in the same order, as in this template.

  • Once you have extracted the data into your temporary spreadsheet, cut and paste the data into the relevant sheets provided in this template.

  • For ID columns, you need to develop a mapping between existing values and Oracle Fusion Cloud Application values. Use the implementation pages in Oracle Functional Setup Manager to extract the identifier and additional attributes to help map the two values.

  • For key flexfields, you also need to develop a way to map the values in the source system that correspond to the unique combinations in Oracle. For key flexfield columns in the spreadsheet that require internal IDs, use the related Oracle implementation pages to export the internal IDs and the segment values to map to the source system values.

Importing Loaded Data

After you successfully load your data, you must submit the Manage Reservation Interface process to import the data into the application tables.

To submit the Manage Reservation Interface process:

  1. Navigate to the Scheduled Processes work area (Tools > Scheduled Processes.

  2. Click the Schedule New Process button and select Manage Reservation Interface.

  3. Enter the appropriate parameters and click Submit.

  4. Monitor the process in the Scheduled Process work area.

  5. If the submitted process ends in error or warning, review the log file for details about the rows that caused the failure.

To correct import errors:

  1. Click on the Manage Reservation Interface task in the Inventory Management work area.

  2. Query the records by specifying the appropriate search criteria.

  3. Review and correct the errors in the spreadsheet.

  4. Once you correct all of the rows with errors, resubmit the process.

  5. Repeat the submit and error correction steps in this section until all rows import successfully.