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 turns analytics workbook that helps users explore, analyze, and refine inventory performance insights using natural-language prompts.
Application: Fusion SCM Analytics
Fusion Module: Inventory Management
Target Persona: Inventory Manager, Inventory Analyst, Supply Chain Planner
Subject Areas: SCM - Inventory Turns, SCM - Inventory Turns LSA
Business Use Case/Questions:
- Show me Inventory Turns for the Current Quarter for Ledger L1.
- Show me Inventory On-Hand Quantity for the Prior Quarter for Item Primary UOM EA.
- Show me the Excess Quantity by Inventory Organization for Last Year for Item Primary UOM EA.
- Show me the Obsolete Quantity by Inventory Organization for Last Year for Item Primary UOM EA.
- Show me the Excess Quantity by Item Status.
- Show me a trend of Days in Inventory by Period for Last Year for Inventory Organization ABC.
- Show me Sales Quantity vs On Hand Quantity by Period for Last Year for Inventory Organization ABC for Item Primary UOM EA.
- Show me Sales Amount vs On Hand Amount by Period for Last Year for Inventory Organization ABC.
- Show me a breakdown of Inventory On Hand Quantity by Category for Functional Area Inventory for Item Primary UOM EA for the Prior Year.
- Which products are in excess for Last Year for Item Primary UOM EA?
- Which products are obsolete for Last Year for Item Primary UOM EA?
- What are the Inventory Turns for each Item in Business Unit Name during the Current Year?
- Which Inventory Organizations have the highest COGS as a percentage of their Sales Value for the Current Year?
- How have Inventory Turns by Quarter trended over the trailing three years?
- Can I see the total Excess Quantity and Value by Inventory Organization for Item Primary UOM EA?
- Which Business Units have the highest Days in Inventory?
- What is the Average Unit Cost by Item for each Item Status?
- Which Categories have accumulated the most Excess Inventory this year for Functional Area Inventory for Item Primary UOM EA?
- Can I get a breakdown of Sales Quantity and Value by Item and Fiscal Period for Item Primary UOM EA?
- How does the Obsolete Quantity compare to the Total Inventory Quantity for [Category] for Functional Area Inventory for Item Primary UOM EA for the Current Year?
Pre-Requisites:
- FDI Release: 26.R2
- Offering: Supply Chain Management Analytics
- Functional Area Activation: Inventory Management
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.
