This post shares Fusion SCM Analytics sample content as part of Oracle Fusion Data Intelligence (FDI), a family of prebuilt, cloud-native analytics applications for Oracle Fusion Cloud Applications. These sample artifacts are intended to demonstrate potential use cases, accelerate implementation efforts, and provide examples of how customers can extend and customize FDI content to meet their business needs. To explore additional reusable sample content, visit the FDI Content Library.
Content Description: An AI-enabled inventory balances analytics workbook that helping users explore, analyze and refine Inventory Balances insights using natural-language prompts.
Application: Fusion SCM Analytics
Fusion Module: Inventory
Target Persona: Inventory Manager, Warehouse Manager
Subject Areas: SCM – Inventory Balances, SCM - Inventory Balances Overview LSA
Business Use Case/Questions:
Current inventory availability
• Show Current Onhand Quantity and Reservable On Hand Quantity by Subinventory and Locator for Item ESB100010 in Inventory Organization Seattle Inventory Organization.
• Which are the top 5 Subinventory values by Current Onhand Quantity, including Subinventory Description, for Nova1 Business Unit and Category Finished Goods?
• Show Current Onhand Quantity by Locator and Locator Description for Subinventory Main Stores and Item ESB100010.
• Which are the top 5 Locator values by Reservable On Hand Quantity for Item ESB100020 in Subinventory Main Stores?
Receiving and supply pipeline
• Show Receiving Quantity, Inbound Quantity, and In-Transit Quantity by Supplier for Item ESB100010 with Receipt Date in the last 30 days.
• Show Receiving Quantity by Receipt Date and Subinventory for Item ESB100020 with Receipt Date in the last 30 days.
• Show In-Transit Quantity by Shipped Date and Inventory Organization for Document Type Transfer Order with Shipped Date in the last 30 days.
• Show Receiving Quantity and Inbound Quantity by Supplier and Document Number for Nova1 Business Unit with Receipt Date in the last 14 days.
Consigned inventory ownership
• Show Consigned Quantity by Owning Party and Owning Party Site for Item ESB100010 in Inventory Organization Seattle Inventory Organization.
• Which are the top 5 Owning Party values by Consigned Quantity for Category Components in Nova1 Business Unit?
• Show Consigned Quantity by Item and Item Description for Owning Party Global Components and Category Components.
• Show Consigned Quantity by Lot and Serial Number for Item ESB100020 in Subinventory Consigned Stores.
Lot, serial, and expiration control
• Show Current Onhand Quantity by Lot and Expiration Date for Item ESB100010 with Expiration Date in the next 90 days.
• Show Reservable On Hand Quantity by Serial Number and Locator for Item ESB100020 in Subinventory Main Stores.
• Show Current Onhand Quantity by Item Class and Category Description for Catalog Inventory Catalog in Nova1 Business Unit.
• Show Current Onhand Quantity by Lot, Serial Number, and Expiration Date for Category Perishable Goods with Expiration Date in the next 30 days.
Item and organizational distribution
• Show Current Onhand Quantity by Inventory Organization Name and Inventory Organization Country for Item ESB100010 in Nova1 Business Unit.
• Show Current Onhand Quantity and Reservable On Hand Quantity by Subinventory Location Country and Subinventory Location State for Category Finished Goods in Inventory Organization Country US.
• Show Current Onhand Quantity by Item Class and Item Lifecycle Phase for Item ESB100020 with Item Primary UOM Each.
Pre-Requisites:
- FDI Release: 26.R2
- Offering: Supply Chain Management Analytics
- Functional Area Activation: Inventory Balances
Download: Available in the FDI Content Library.
We’d love to get your feedback and business use cases to help build a more sample FDI content.
