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 sales order analytics workbook that helping users explore, analyze and refine sales order insights using natural-language prompts.
Application: Fusion SCM Analytics
Fusion Module: Order Management
Target Persona: Order Administrator, Order Manager
Subject Areas: SCM - Sales Orders, SCM - Sales Orders LSA
Business Use Case/Questions:
- Show me the Order Amount for the current year.
- Which customer has the highest Order Amount?
- Show the Order Amount by Customer for orders that were actually shipped in Jan 2025.
- Show the Order Amount by Customer for orders that are promised to ship in Jan 2025.
- Show the Order Amount by Customer for orders that are scheduled to ship in Jan 2025.
- Show me the Order Amount for cancelled orders for the current year.
- Show me the top 10 Order Amounts by Category for the current year.
- Show me the top 10 Order Amounts by Customer for the current year.
- How many orders are on hold for the current year?
- Which customer has the highest Order Amount that is not yet shipped for the current year?
- Show me the Order Count for the last two years.
- Show the Order Amount by Category for orders that were actually shipped in 2025, 2024, and 2023.
- Show me the Open Order Count by Customer for the current year.
- Show me the Return Amount for the current year.
- Which customer has the highest Return Order Count for the current year?
- Show me the Return Amount by Customer where the order is an actual order that was shipped later than the promised date.
- Show me the Return Amount by Category where the order is an actual order that was shipped later than the promised date in the current year.
- What is the Order Fulfill Cycle Time by Category for orders that were actually shipped in Jan 2024?
- Which orders are cancelled and actually shipped in Jan 2024?
- Show the Order Amount by Fulfillment Line Status for Fiscal Year 2020, Fiscal Quarter 2020Q2, and Fiscal Period Apr20.
Pre-Requisites:
- FDI Release: 26.R2
- Offering: Supply Chain Management Analytics
- Functional Area Activation: Order 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.
