Business Processes
The integration scope supports the following business processes:
Storeroom Sync from ERP SCM to WACS
The storeroom integration transfers the sub inventory in Oracle Fusion ERP Cloud as storeroom in Oracle Utilities Work and Asset Cloud Service:
• Active Storeroom Synchronization from Oracle Supply Chain Management to Oracle Utilities Work and Asset Cloud Service
• Inactive Storeroom Synchronization from Oracle Fusion ERP Cloud to Oracle Utilities Work and Asset Cloud Service
Active Storeroom Synchronization
This process synchronizes the “Active” sub inventories from Oracle Supply Chain Management to storerooms in Oracle Utilities Work and Asset Cloud Service in bulk and incremental fashion.
Inactive Storeroom Synchronization
This process synchronizes the sub inventories in “Inactive” status from Oracle Supply Chain Management to storerooms in Oracle Utilities Work and Asset Cloud Service in bulk and incrementally.
Stock Item Details Sync from ERP SCM to WACS
Stock Item Details Integration synchronizes the following data from Fusion Inventory to Oracle Utilities Work and Asset Cloud Service:
• Stock Item Detail Bulk Load from Oracle Fusion ERP Cloud to Oracle Utilities Work and Asset Cloud Service
• Stock Item Detail Incremental Sync from Oracle Fusion ERP Cloud to Oracle Utilities Work and Asset Cloud Service
• Item Quantities and Average Unit Price Sync from Oracle Fusion ERP Cloud to Oracle Utilities Work and Asset Cloud Service
Stock Item Detail Bulk Load
Item assignments in Oracle Fusion ERP Cloud sub inventory will be synchronized as Stock Item Details in Oracle Utilities Work and Asset Cloud Service storerooms. The bulk load will synchronize full item extract from Oracle Fusion ERP Cloud to SID in Oracle Utilities Work and Asset Cloud Service.
This integration release supports leadtime changes (mapping for leadTime as proessingdays+postprocessingdays+preprocssingdays).
Stock Item Detail Incremental Sync
Incremental synchronization will use create/update item events to synchronize the item to SIDs in Oracle Utilities Work and Asset Cloud Service incrementally.
This integration release supports leadtime changes (mapping for leadTime as proessingdays+postprocessingdays+preprocssingdays).
Item Quantities and Average Unit Price Sync
On-hand quantity and average unit price for an item in Oracle Fusion ERP Cloud sub inventory will be synchronized to Item Quantity in Oracle Utilities Work and Asset Cloud Service storeroom.
Material Reservation Integration from WACS to ERP SCM
The Material Reservation integration synchronizes the Material Activity Resource Requirement reservations in Oracle Utilities Work and Asset Cloud Service as User Defined Reservations in Oracle Utilities Work and Asset Management.
Material Request Integration from WACS to ERP SCM
The Material Request integration expense type creates a supply request in Oracle Fusion ERP Cloud after a Material Request is created in Oracle Utilities Work and Asset Cloud Service. This supply request creates an expense type transfer order. The pick wave for the transfer order is also created in Oracle Utilities Work and Asset Management nearer to the required by date.
The integration includes the following flows:
Supply Request Creation
The material request from Oracle Utilities Work and Asset Cloud Service creates an expense type supply request in Oracle Utilities Work and Asset Management. This supply request gets converted to expense type transfer order in Oracle Utilities Work and Asset Management through supply chain orchestration process of Oracle Fusion.
Pick Wave Creation
Closer to the transfer order required by date, the integration creates a pick wave for each transfer order. It also reduces the user defined reservation by appropriate quantity if the Oracle Utilities Work and Asset Cloud Service material request line has a material ARR attached to it with reservation.
This functionality is achieved through the integration flows. For more information, refer to the Integration Flows section.
Material Issue Integration from ERP SCM to WACS
The Material Issue integration synchronizes shipment lines from Oracle Fusion Cloud Inventory Management (SCM) as Material Issue lines to Oracle Utilities Work and Asset Cloud Service.
Material Demand Forecast Integration from WACS to ERP SCM
The Material Demand Forecast integration Process Material Demand file from Oracle Utilities Work and Asset Cloud Service to Oracle Supply Chain Management Planning as External Forecast. If there are multiple files, the integration processess the latest batch related files.
The integration includes the following flows:
Material Demand FTP Forecast Integration
The integration will read the Oracle Utilities Work and Asset Cloud Service batch file from FTP for Material Demand, transform it to the target schema, and then upload it as external forecast in Oracle Supply Chain Management Planning through external forecast FBDI.
Material Demand OS Forecast Integration
The integration will read the Oracle Utilities Work and Asset Cloud Service batch file from object storage for Material Demand, transform it to the target schema, and then upload it as external forecast in Oracle Supply Chain Management Planning through external forecast FBDI.
This functionality is achieved through the integration flows. For more information, see the Integration Flows section.
Note that the file name must be in the “ERPFORECAST_{BC}_{BN}_{TN}.csv.zip” or “ERPFORECAST_{BC}_{BN}_{TN}.csv” format.