Thursday, 15 May 2025

How to use AI and ML in Oracle Cloud WMS

How to use AI and ML in Oracle Cloud WMS 


Oracle Cloud WMS is a modern, cloud-based warehouse management system that offers scalability, flexibility, and a host of powerful features. One of the most transformative aspects of Oracle Cloud WMS is its ability to leverage Artificial Intelligence (AI) and Machine Learning (ML) to optimize warehouse operations, improve efficiency, and reduce costs.

In this article, I will explore how AI can be used in Oracle Cloud WMS with real-world use cases, examples, and implementation steps.


AI Capabilities in Oracle Cloud WMS

Oracle integrates AI in WMS through the following areas:


1. Inventory Optimization

Use Case:

AI analyses historical sales data, supplier lead times, and seasonal trends to optimize inventory levels.

Live Example:

A retailer uses Oracle Cloud WMS to manage warehouse stock. By enabling Oracle AI capabilities, it automatically identifies that demand for winter jackets spikes in November based on the last 5 years of sales data and recommends increased stocking in October.

Implementation Steps:

·   Enable AI/ML features from the Oracle Fusion SCM dashboard.

·   Integrate historical inventory and sales data using Oracle Data Integration tools.

·   Use Oracle Analytics Cloud to visualize predictions and suggested actions.


2. Order Fulfilment Predictions

Use Case:

AI predicts the best warehouse to fulfil an order based on delivery time, stock levels, and shipping cost.

Live Example:

A customer from Delhi places an online order. AI suggests fulfilling it from the Noida warehouse instead of Mumbai because it reduces delivery time by 2 days and shipping cost by 20%.

Implementation Steps:

·   Set up multi-warehouse configurations in Oracle Cloud WMS.

·   Integrate Oracle AI Apps for SCM.

·   Configure predictive routing rules using Oracle Process Automation.


3. Labor Forecasting and Optimization

Use Case:

AI predicts labour requirements based on incoming order volume and schedules shifts accordingly.

Live Example:

During Black Friday week, AI forecasts a 300% increase in outbound shipments and recommends hiring 15 additional temporary workers for the week.

Implementation Steps:

·   Use Oracle Workforce Management with Oracle WMS.

·   Upload historical labour and volume data.

·   Enable predictive scheduling in the Workforce Optimization module.


4. Anomaly Detection

Use Case:

Detect unusual stock movements or errors in warehouse operations.

Live Example:

AI detects that Item A has a 50% higher return rate than usual in the past week. It automatically flags the item and notifies QA for investigation.

Implementation Steps:

·   Use Oracle AI Adaptive Intelligence apps.

·   Configure anomaly thresholds in Oracle IoT Cloud apps if using IoT sensors.

·   Automate alerts via Oracle Notification Services.


5. Autonomous Decision Making

Use Case:

AI triggers automatic replenishment, rerouting, or alerts without human intervention.

Live Example:

When stock for a fast-moving item drops below threshold, AI autonomously creates a PO from a preferred supplier.

Implementation Steps:

·   Set rules and thresholds in the Oracle WMS rules engine.

·   Enable autonomous triggers using Oracle SCM Cloud AI engine.

·   Use Oracle Integration Cloud for automated supplier communications.


6. Computer Vision Integration

Use Case:

Use AI-powered cameras for real-time inventory scanning and safety monitoring.

Live Example:

A warehouse installs AI cameras integrated with Oracle IoT Cloud. These detect incorrect stacking of pallets and alert staff to prevent accidents.

Implementation Steps:

·   Integrate computer vision hardware with Oracle IoT Cloud.

·   Train AI models using Oracle Machine Learning (OML) in Autonomous Database.

·   Stream insights into Oracle Cloud WMS dashboards.


Tools and Services Involved

·   Oracle Cloud Infrastructure (OCI) AI Services

·   Oracle Analytics Cloud (OAC)

·   Oracle Machine Learning (OML)

·   Oracle Integration Cloud

·   Oracle IoT Cloud

·   Oracle Digital Assistant (for AI-driven user interfaces)


Getting Started

Prerequisites:

·   Oracle Cloud WMS subscription

·   Access to Oracle Fusion Cloud SCM

·   Historical data for AI model training

Steps:

·   Connect your WMS to Oracle Analytics Cloud.

·   Import relevant data from ERP, CRM, and external systems.

·   Train ML models using Oracle Machine Learning.

·   Deploy AI insights back into Oracle WMS through APIs or dashboards.


AI in Oracle Cloud WMS is not just a concept, it's already being applied by businesses to cut costs, improve efficiency, and make smarter decisions. Whether you're predicting stock shortages or rerouting shipments, AI provides a competitive edge in the modern supply chain.


Thanks,

Pratip Chatterjee

Monday, 28 April 2025

How to use Agile methodology during an Oracle Cloud WMS (Warehouse Management System) implementation

Using Agile for Oracle Cloud WMS Implementation

When implementing Oracle Cloud WMS, the company decided to shift from the traditional waterfall approach to Agile, aiming for faster results and better adaptability. The project was broken down into sprints — short, focused periods (2–3 weeks each) — where small, manageable pieces of the WMS system were configured, tested, and reviewed.

Sprint 1 started with basic warehouse setup: defining facility structures, inventory organizations, and users. During the sprint, daily stand-up meetings were held to track progress and solve issues immediately. At the end of the sprint, a demo was given to warehouse managers for feedback.

Sprint 2 focused on inbound operations: receiving, putaway rules, and ASN (Advanced Shipment Notice) setups. Based on early feedback, the team quickly adapted the putaway strategies to match the real-world needs of the warehouse.

Sprint 3 tackled outbound operations: including picking, packing, and shipping flows. User stories (business requirements written from the user’s perspective) guided configuration and testing, ensuring every function added real operational value.

Parallel to the sprints, training and UAT (User Acceptance Testing) were continuous activities. Users were involved early, practicing on partial builds instead of waiting for the final rollout.

Benefits:

  •  Faster visibility of issues
  •  Early feedback reduced rework
  •  Users felt ownership from Day 1
  •  Flexibility to adjust to unexpected business needs

After about 4–5 sprints, the core functionalities were ready, and a final stabilization sprint was done before going live.

Agile Approach for Oracle Cloud WMS Implementation

1. Agile Phases Overview

Initiation (Sprint 0):  Identify high-level business processes (Receiving, Putaway, Picking, Shipping, Cycle Counting). Define Epics (big features) and break them into User Stories (small tasks).

 Sprints (2–3 weeks each): 

  • Sprint Planning
  • Daily Standups
  • Mid-Sprint Reviews
  • Sprint Demo to Business Users
  • Sprint Retrospective
  • Go-Live and Stabilization Sprint.

 2. Detailed Use Case Example: "Automate Receiving Process"

 As a warehouse manager, you want to automate the receiving process so that received goods are accurately updated into inventory with minimal manual entry.

 User Stories:

  • Configure supplier ASN (Advance Shipment Notice) integration.
  • Set up default putaway rules after receiving.
  • Auto-generate LPNs (License Plate Numbers) during receiving.
  • Customize receiving UI to show mandatory fields (PO number, Quantity, Condition Code).

 3. Development Team Procedure Management 

Step

Action

Backlog Grooming

Work with Product Owner to refine user stories with clear Definition of Done (acceptance criteria).

Sprint Planning

Pick 4-6 stories (depending on capacity), estimate effort in story points.

Configuration

WMS Functional Consultants configure receiving parameters, shipment types, defaulting rules.

Development

If customizations are needed (e.g., extensions, REST API, ASN import), developers create extensions in Oracle Visual Builder Cloud Service (VBCS) or through API's

Testing

QA team and warehouse user test the configures processes inside the Sprint.

Demo

At Sprint end, showcase Auto Receiving workflow to business user for approval or feedback.

UAT Preparation

Collect feedback adjusted in the next Sprint if needed.

Deployment Management

Use Oracle Migratior tools (Export/Import Setup Data or Functional Setup Manager) to move configurations across environments (Dev to Test to Production).

 4. Important Agile Best Practices for Dev Team

  •  Daily Standup: Quickly share blockers, e.g., ASN payload from supplier missing required fields.
  •  Backlog Updates: After demo, if user asks for small changes, create new user stories for next sprint.
  •  Incremental Deployment: Every sprint should create a working, testable WMS feature.

 Collaboration with Oracle Cloud Services: Engage Oracle SRs (Service Requests) if a platform issue arises and track separately from sprint deliverables.

 DevOps: If using custom code (extensions or integrations), maintain versioning in GitHub or DevOps tools.

 Summary Diagram (Flow) 

  • Sprint 0 → Identify Epics and Stories
  • Sprint 1 → Configure Receiving → Test → Demo
  • Sprint 2 → Configure Putaway → Test → Demo
  • Sprint 3 → Configure Picking → Test → Demo
  • Sprint 4 → Integrations/Customizations → Test → Demo
  • Sprint 5 → Stabilization → Final UAT → Go-Live

 

Thank You,

Pratip Chatterjee


Wednesday, 23 April 2025

How SaaS (Software as a Service) and PaaS (Platform as a Service) work in the context of Oracle Cloud Warehouse Management System (WMS)

In today's article, I am discussing how SaaS (Software as a Service) and PaaS (Platform as a Service) work in the context of Oracle Cloud Warehouse Management System (WMS).

Understanding SaaS and PaaS in Oracle Cloud WMS

Cloud computing has revolutionized how businesses manage enterprise applications like warehouse management systems (WMS). Oracle offers a robust, scalable, and integrated solution through Oracle Cloud WMS, using both SaaS and PaaS models. This article breaks down how each model works and supports logistics operations.

What is Oracle Cloud WMS?

Oracle Cloud WMS is a cloud-based warehouse management system that helps organizations manage warehouse operations efficiently—from inventory tracking and order fulfillment to labor management and real-time analytics.

SaaS (Software as a Service) in Oracle Cloud WMS

SaaS delivers a fully-managed software application over the internet. In the case of Oracle Cloud WMS:

 How it works:

  • Oracle hosts and maintains the WMS software.
  • Customers access it via a web interface or API.
  • All backend processes like updates, patches, security, and scalability are managed by Oracle.

 Features Offered via SaaS:

  • Pre-configured workflows for receiving, picking, shipping, inventory control.
  • Real-time visibility into warehouse operations.
  • AI/ML-powered demand forecasting and inventory optimization.
  • Seamless integration with Oracle ERP Cloud and other third-party systems.

 Benefits:

  • Quick deployment: No need to install or maintain software.
  • Scalability: Easy to add new warehouses or users.
  • Lower TCO: No infrastructure costs.
  • Automatic updates: Stay current with the latest features.

 Use Case Example:

A retailer with multiple fulfilment centers uses Oracle Cloud WMS SaaS to manage distributed inventory. The software helps streamline operations without needing IT teams to deploy or maintain the system locally.

PaaS (Platform as a Service) in Oracle Cloud WMS

PaaS provides a platform and environment for developers to build, customize, and deploy applications on top of Oracle’s infrastructure.

 How it works:

  • Oracle offers a set of development tools, APIs, and services like Oracle Integration Cloud, Oracle Visual Builder, and Oracle APEX.
  • Developers can create extensions or custom apps that interact with Oracle WMS.

 Common PaaS Use Cases in WMS:

  • Custom dashboards: Building specific visualizations not available in the standard SaaS dashboard.
  • Integrations: Connecting Oracle WMS with legacy ERP or third-party logistics systems.
  • Custom business logic: Adding unique workflows or rule sets for specialized warehouse processes.
  • Mobile app extensions: Enhancing mobile UIs for handheld devices used in the warehouse.

 Benefits:

  • Customization: Tailor Oracle WMS to your unique business needs.
  • Faster innovation: Deploy new features quickly without waiting for SaaS releases.
  • Secure and scalable: Built on the same robust Oracle Cloud Infrastructure (OCI).

 Use Case Example:

A pharma company needs a custom temperature tracking system in its cold storage warehouse. Developers use Oracle PaaS to create a module that interfaces with IoT sensors and integrates the data into Oracle WMS.

So, SaaS + PaaS: A Powerful Combination; Oracle Cloud WMS is designed to leverage the best of both models:


Oracle Cloud WMS provides an enterprise-grade, cloud-native solution using both SaaS and PaaS models. While SaaS enables rapid deployment and standardized best practices, PaaS offers the flexibility to customize and extend functionality. Together, they empower businesses to operate smarter, faster, and more efficiently in today’s dynamic supply chain landscape.

Thank You,
Pratip Chatterjee

Tuesday, 18 February 2025

Purchase Order Full Flow - Fusion to WMS to Fusion

Purchase Order Full Flow - Fusion to WMS to Fusion


PO Created in Fusion > Run/Schedule Generate Receipt Advice > Interface (OIC) >  PO created in WMS > Create IB Shipment in WMS (or ASN import from Fusion) > Appointment for Load > Dock Check In > Cartonization > IBLPN (Print Blind IBLPN) > RF Receiving > Putaway > Dock Check Out > Verification  > Interface (OIC) > GRN is created per IB Shipment in Fusion 


- Purchase Order Status during Receiving (Header and Line): In Receiving

- IB Shipment Status during Receiving : Header = Receiving Started and Line = Received

- IB Shipment Status after Receiving is completed : Header = Receiving Completed and Line = Received

- IBLPN Status : Received


- After Receiving : This will send an interface to Fusion Inventory Management to create receipts. (Receipt Confirmation)

- After Put away : This will again send an interface back to Fusion to initiate the GRN process. (Receipt Confirmation)

- PO receipt : One GRN is created per IB Shipment in Fusion based on the shipment verification file from WMS.


Thank You,
Pratip Chatterjee

Wednesday, 3 July 2024

What is the difference between asset sub-inventory and expense sub-inventory in Oracle Cloud Procurement

What is the difference between asset sub-inventory and expense sub-inventory in Oracle Cloud Procurement

An asset sub-inventory is a location where assets are stored, while an expense sub-inventory is a location where expenses are tracked.

Assets are items that have a long-term value to a company, such as buildings, equipment, and vehicles. Expenses are costs that are incurred in the course of doing business, such as rent, utilities, and salaries.

Asset sub-inventories are typically used to track the movement of assets within a company, while expense sub-inventories are typically used to track the costs of expenses.

Here is a table summarizing the key differences between asset sub-inventories and expense sub-inventories:


It is important to note that the terms "asset sub-inventory" and "expense sub-inventory" are not standardized, and different companies may use different definitions. It is important to understand the specific definitions used by your company in order to use sub-inventories effectively.

An asset sub-inventory is a grouping of assets that share common characteristics, such as location or department. An expense sub-inventory is a grouping of expenses that share common characteristics, such as cost center or project.

Here are some additional details about asset sub-inventories and expense sub-inventories:

- Asset sub-inventories are created in Oracle Fusion Inventory.

- Expense sub-inventories are created in Oracle Fusion General Ledger.

- Asset sub-inventories can be used to track the movement of assets between locations or departments.

- Expense sub-inventories can be used to track the allocation of expenses to projects or cost centers.

- Asset sub-inventories can be used to generate reports on asset usage.

- Expense sub-inventories can be used to generate reports on expense allocation.

Overall, asset sub-inventories and expense sub-inventories are two different types of sub-inventories that are used for different purposes. Asset sub-inventories are used to track assets, while expense sub-inventories are used to track expenses.


Thank You,

Pratip Chatterjee

Sunday, 19 May 2024

Oracle Retail Warehouse Management System and its distinguishing feature from Oracle R12 WMS

Oracle Retail Warehouse Management System and its distinguishing feature from Oracle R12 WMS


Oracle Retail WMS

Oracle Retail WMS is an enterprise-wide warehouse management system that optimizes the flow of goods through the warehouse. It provides a single view of inventory across multiple locations, and it automates tasks such as receiving, put-away, picking, packing, and shipping. Oracle Retail WMS is also integrated with other Oracle Retail applications, such as Oracle Retail POS and Oracle Retail E-Commerce, to provide a seamless end-to-end supply chain solution.

Here are some of the benefits of using Oracle Retail WMS:

- Increased efficiency: Oracle Retail WMS can help you to improve the efficiency of your warehouse operations by automating tasks, reducing errors, and providing real-time visibility into inventory levels.

- Reduced costs: Oracle Retail WMS can help you to reduce costs by optimizing the flow of goods through the warehouse, reducing the amount of time that goods spend in the warehouse, and minimizing the amount of inventory that is required.

- Improved customer service: Oracle Retail WMS can help you to improve customer service by providing faster order fulfillment and more accurate inventory information.

If you are looking for an enterprise-wide warehouse management system that can help you to improve the efficiency, reduce the costs, and improve the customer service of your warehouse operations, then Oracle Retail WMS is a good option for you.

Here are some of the features of Oracle Retail WMS:

- Single view of inventory: Oracle Retail WMS provides a single view of inventory across multiple locations, so you can always know where your products are and how much of each product you have.

- Automated tasks: Oracle Retail WMS automates tasks such as receiving, putaway, picking, packing, and shipping, so you can free up your employees to focus on other tasks.

- Real-time visibility: Oracle Retail WMS provides real-time visibility into inventory levels, so you can always make informed decisions about your inventory.

- Integration with other Oracle Retail applications: Oracle Retail WMS integrates with other Oracle Retail applications, such as Oracle Retail POS and Oracle Retail E-Commerce, to provide a seamless end-to-end supply chain solution.


Difference between Oracle Retail WMS and Oracle R12 WMS

Oracle Retail WMS

- Overview

    - Oracle Retail WMS is a warehouse management system (WMS) that helps retailers manage their inventory and orders. It provides a single view of inventory across all channels, and it can be integrated with other Oracle Retail applications, such as Oracle Retail POS and Oracle Retail Ecommerce.

    - Oracle Retail WMS is designed to help retailers improve their efficiency, accuracy, and customer service. It can help retailers:

       - Reduce inventory costs

        - Improve order fulfillment accuracy

        - Increase customer satisfaction

- Features

    - Oracle Retail WMS includes a variety of features that help retailers manage their inventory and orders, including:

        - Order management

        - Inventory management

        - Warehouse management

        - Transportation management

        - Reporting and analytics

- Pricing

    - Oracle Retail WMS is available on a subscription basis. The subscription price depends on the number of users, the number of warehouses, and the features that are included.

Oracle R12 WMS

- Overview

    - Oracle R12 WMS is a warehouse management system (WMS) that helps businesses manage their inventory and orders. It provides a single view of inventory across all locations, and it can be integrated with other Oracle applications, such as Oracle ERP and Oracle CRM.

    - Oracle R12 WMS is designed to help businesses improve their efficiency, accuracy, and customer service. It can help businesses:

        - Reduce inventory costs

        - Improve order fulfillment accuracy

        - Increase customer satisfaction

- Features

    - Oracle R12 WMS includes a variety of features that help businesses manage their inventory and orders, including:

        - Order management

        - Inventory management

        - Warehouse management

        - Transportation management

        - Reporting and analytics

- Pricing

    - Oracle R12 WMS is available on a perpetual license basis. The license price depends on the number of users, the number of warehouses, and the features that are included.


Comparison:

The following table compares Oracle Retail WMS and Oracle R12 WMS in terms of features, pricing, and support:



Thanks,
Pratip Chatterjee


Wednesday, 17 January 2024

Difference between Oracle Fusion Product Information Management and Oracle Fusion Product Data Hub

Difference between Oracle Fusion Product Information Management and Oracle Fusion Product Data Hub

Oracle Fusion Product Information Management and Oracle Fusion Product Data Hub are both enterprise-class applications that can help organizations manage their product information. However, there are some key differences between the two applications.

Oracle Fusion Product Information Management is a product information management (PIM) solution that helps organizations manage their product data across multiple channels. It provides a central repository for product data, and it offers a variety of features for managing, storing, and distributing product information. Oracle Fusion Product Information Management can be used to:

- Create and manage product catalogs: Oracle Fusion Product Information Management can be used to create and manage product catalogs for different channels, such as online stores, catalogs, and print media.

- Centralize product data: Oracle Fusion Product Information Management can help organizations centralize their product data, making it easier to manage and distribute.

- Automate product data workflows: Oracle Fusion Product Information Management can automate product data workflows, such as product creation, approval, and publishing.

- Optimize product data for search engines: Oracle Fusion Product Information Management can help organizations optimize their product data for search engines, making it easier for customers to find their products.


Oracle Fusion Product Data Hub is a product data hub (PDH) solution that helps organizations manage their product data across multiple systems. It provides a central repository for product data, and it offers a variety of features for integrating, cleansing, and enriching product data. Oracle Fusion Product Data Hub can be used to:

- Unify product data from multiple sources: Oracle Fusion Product Data Hub can help organizations unify product data from multiple sources, such as ERP systems, CRM systems, and e-commerce platforms.

- Cleanse and enrich product data: Oracle Fusion Product Data Hub can help organizations cleanse and enrich product data, making it more accurate and complete.

- Automate product data workflows: Oracle Fusion Product Data Hub can automate product data workflows, such as product creation, approval, and publishing.

- Optimize product data for search engines: Oracle Fusion Product Data Hub can help organizations optimize their product data for search engines, making it easier for customers to find their products.

Key differences between Oracle Fusion Product Information Management and Oracle Fusion Product Data Hub

The following table summarizes the key differences between Oracle Fusion Product Information Management and Oracle Fusion Product Data Hub:




Thank You
Pratip Chatterjee



Oracle Cloud 26B: Smarter WMS, Mobile, Integration, and Logistics

The Oracle Cloud 26B release is not just another quarterly update it reflects a clear evolution in how warehouse operations, integrations, a...