Design Details
This section describes the design details of the integration:
Storeroom Sync: The storeroom integration transfers sub inventory in Oracle Fusion ERP Cloud as storeroom in Oracle Utilities Work and Asset Cloud Service.
Stock Item Details Sync: The stock item details integration synchronizes the bulk load and incremental synchronization data from Oracle Fusion ERP Cloud inventory to Oracle Utilities Work and Asset Cloud Service:
Storeroom Integration: The Oracle Fusion ERP Cloud sub inventory is synchronized as Oracle Utilities Work and Asset Cloud Service storeroom. It runs through two modes.
Initial Load: This mode executes when the integration runs for the first time. As part of the execution, the flow reads all active Oracle Fusion ERP Cloud sub inventories and creates the corresponding storerooms in Oracle Utilities Work and Asset Cloud Service.
Incremental Load: After the initial load is executed, incremental load runs on a schedule. As part of incremental load, the changes in Oracle Fusion ERP Cloud sub inventories (create, update, deactivate) are propagated to the corresponding Oracle Utilities Work and Asset Cloud Service storerooms.
Stock Item Details Integration: The stock item details definition and inventory adjustments are synchronized in Oracle Utilities Work and Asset Cloud Service from Oracle Fusion ERP Cloud. The stock item details integration also works in two modes: initial load and increment load. It supports the following sub flows:
Stock Item Details Definition: The stock item details definitions are created based on the Oracle Fusion ERP Cloud item and inventory organization associations from the item definition.
Inventory Adjustment: The on-hand balance and unit cost price are picked from Oracle Fusion ERP Cloud at item-subinventory level and updated as item quantity and average unit price in Oracle Utilities Work and Asset Cloud Service at stock item details.