11External System Integrations

This chapter contains the following:

Inventory Transaction Interface

Use the Inventory Transaction Interface to automatically create inventory transactions from another system. You can also use the interface to view, edit, and correct transactions.

Run both the Create Inventory Transactions Interface and the Manage Inventory Transactions Interface by selecting the Manage Pending Transactions task from the Tasks pane of the Inventory Management work area.

Before launching this interface, you must:

  • Load import data to the Inventory Transaction Interface tables (INV_TRANSACTIONS_INTERFACE, INV_TRANSACTION_LOTS_INTERFACE, and INV_SERIAL_NUMBERS_INTERFACE). For more information on each interface table, see Oracle Enterprise Repository for Oracle Fusion Applications.

    You can load data to interface tables using predefined templates and the Load Interface File for Import scheduled process, which are both part of the External Data Integration Services for Oracle Cloud feature. For other implementations, optionally use this feature only if you have SFTP configured for it.

  • Establish parent-child relationships for the following Inventory Transaction Interface tables:

    • INV_TRANSACTIONS_INTERFACE

    • INV_TRANSACTION_LOTS_INTERFACE

    • INV_SERIAL_NUMBERS_INTERFACE

Count Sequence Interface

Use the Count Sequence Interface to create a new cycle count sequence, or to modify an existing cycle count sequence. You can also use the Count Sequence Interface to import and export cycle entries to and from external systems.

Run the Count Sequence Interface by selecting the Review Count Interface Records task from the Tasks pane of the Inventory Management work area.

Before launching this interface, you must:

  • Load import data to the Count Sequence Interface table (INV_CC_ENTRIES_INTERFACE). For more information on the interface table, see Oracle Enterprise Repository for Oracle Fusion Applications.

    You can load data to interface tables using predefined templates and the Load Interface File for Import scheduled process, which are both part of the External Data Integration Services for Oracle Cloud feature. For other implementations, optionally use this feature only if you have SFTP configured for it.

  • Establish parent-child relationships for the Count Sequence Interface table (INV_CC_ENTRIES_INTERFACE).

Reservation Interface

You can use the Reservation Interface to view, create, process, and delete inventory reservation requests in the Oracle Fusion Inventory Management INV_RESERVATION_INTERFACE table.

These reservation requests include unprocessed requests and process requests that didn't complete successfully. Requests that complete successfully disappear from the interface table. You can also submit and resubmit reservation requests for processing.

Run the Reservation Interface by selecting the Manage Reservation Interface task from the Tasks pane of the Inventory Management work area.

Before launching this interface, you must:

  • Load import data to the Reservation Interface table (INV_RESERVATION_INTERFACE). For more information on the interface table, see Oracle Enterprise Repository for Oracle Fusion Applications.

    You can load data to interface tables using predefined templates and the Load Interface File for Import scheduled process, which are both part of the External Data Integration Services for Oracle Cloud feature. For other implementations, optionally use this feature only if you have SFTP configured for it.

  • Establish parent-child relationships for the Reservation Interface table (INV_RESERVATION_INTERFACE).

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

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 values. Use the implementation pages in Oracle Fusion 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 Fusion. For key flexfield columns in the spreadsheet that require internal IDs, use the related Oracle Fusion 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.

Inventory Balances Integration with External Systems

Using Oracle Fusion Inventory Management's inventory balances integration capabilities, you can outsource warehousing and manufacturing processes to efficiently lower costs, service local markets, reduce cycle times, and so on.

A central integration framework across Oracle Purchasing Cloud, Oracle Fusion Order Management, and Inventory Management tracks interactions between the various external systems. You can receive inventory balance details from external systems, such as third-party logistics providers, warehouse management systems, or contract manufacturers and use this information to reconcile inventory balances. Inventory on-hand details can include subinventory, locator, lot, serial number, and external packing unit.

The inventory balances integration feature enables you to:

  • Use the Inventory Balance Transactions REST resource to post inventory balance messages from an external system

  • Import inventory balance messages in bulk using a SaaS spreadsheet

  • Enable users to resolve any processing exceptions

  • Purge inventory balance messages periodically

Note: This feature is automatically available and is included with the shipped job roles (warehouse manager and inventory manager).

Use the following processes and task to interface with external systems to improve tracking and visibility across your supply chain, including partners:

  • Manage Inventory Balances Processes

  • Manage Inventory Balance Messages in Spreadsheet (ADFdi)

  • Manage Inventory Transaction Process

  • Purge Inventory Balance Messages Process

Manage Inventory Balances Process

This scheduled process processes the imported inventory balance messages in the interface tables.

Manage Inventory Balance Messages in Spreadsheet (ADFdi)

Use this task, in the Inventory Management work area in the Manufacturing and Supply Chain Materials Management offering, to review and resolve any exceptions while processing the inventory balance messages.

Manage Inventory Transaction Process

This scheduled process processes the necessary adjustment transactions to reconcile the inventory balances.

Purge Inventory Balance Messages Process

Use this scheduled process to purge the historical balance inventory messages collected over time in the interface tables. Using the processing status parameter, you can purge error, successful, or all messages between a date range.

Third-Party Logistics and Warehouse Management Systems

A third-party logistics (3PL) provider typically specializes in integrated operation, warehousing, and transportation services that can be scaled and configured to customer need based on market conditions. A warehouse management system (WMS) is a software application designed to support warehouse or distribution center management and staff. This application facilitates management of available resources to move and store materials into, within, and out of a warehouse, while supporting staff in material movement and storage.

Oracle Fusion Applications provide a central integration framework that coordinates communication with a 3PL system or WMS to support purchase order receipts, returns to suppliers, internal material transfers, inventory transactions, and sales order shipments. Using Simple Object Access Protocol (SOAP)-based web services or REST resources, Oracle Fusion Inventory Management communicates receiving advice and shipment requests to a 3PL provider or external WMS for processing. After completion of processing in the 3PL system or WMS, Inventory Management accepts receipt confirmations, shipment confirmations, and inventory transactions from the 3PL system or WMS.

For more information, see these guides:

  • REST API for Oracle Supply Chain Management Cloud

  • Oracle Supply Chain Management Cloud SOAP Web Services for SCM

Overview of Inventory Management Integration with 3PL and Warehouse Management Systems

Oracle Fusion Inventory Management supports a central integration framework for working with third-party logistics (3PL) providers and warehouse management systems (WMS). The inventory management suite of products includes Oracle Fusion Receiving, Oracle Fusion Inventory Management, and Oracle Fusion Shipping.

The following figure illustrates how Inventory Management integrates with 3PL and WMS systems. The subsections following the figure provide more detail for this integration.

High-level overview of Inventory Management integration
with 3PL and WMS systems

Receiving Integration

Receiving integration addresses the following points:

  • Sends a receipt advice to the WMS for the various documents, such as purchase order (POs), advanced shipment notices (ASNs), and return material authorizations (RMAs).

  • Receives and processes receipt confirmations to acknowledge the receipt of material, updates the source documents and on-hand details for quantities and other related information, such as lots, serials, and external packing units, and the return of rejected material.

Shipping Integration

Shipping integration addresses the following points:

  • Sends the shipment requests to the WMS for the various documents, such as sales orders and transfer orders.

  • Receives and processes shipment confirmations to acknowledge the shipment of material and updates the source documents.

  • Updates the on-hand details for quantities and other related information, such as lots and serials and splitting of the unfulfilled portions.

Inventory Management Integration

Inventory Management integration addresses the following points:

  • Receives and processes various inventory transactions that can happen within a WMS that might affect the material location and on-hand details. Such inventory transactions include adjustments, miscellaneous receipts and issues, and transfers.

  • Receives and processes inventory balance updates for solving inventory reconciliation challenges.