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 item cost analytics workbook that helping users explore, analyze and refine item cost insights using natural-language prompts.
Application: Fusion SCM Analytics
Fusion Module: Cost Management
Target Persona: Cost Accountant
Subject Areas: SCM – Item Cost, SCM - Item Cost Review Center LSA
Business Use Case/Questions:
Unit Cost and Profit Trends
- Show the Unit Cost and Profit in Inventory trend over the last six Fiscal Periods for Item AS46334, Cost Organization US Operations, and Cost Book US Operations.
- Show Unit Cost and Profit in Inventory % by Fiscal Quarter for Category Computer Servers in Fiscal Year FY2026, Cost Organization US Operations, and Cost Book US Operations.
- Show Unit Cost by Fiscal Date for Item AS85001 for Trailing Period Number 1 through 6 in Cost Organization US Operations and Cost Book US Operations.
- Show Unit Cost by Fiscal Year for Category Tablet Computers for the last three years using Trailing Year Number in Cost Organization US Operations and Cost Book US Operations.
- Show Material Cost and Overhead Cost for Item AS46336 for the current Fiscal Quarter using Trailing Quarter Number in Cost Organization US Operations and Cost Book US Operations.
- Show Unit Cost by Fiscal Period Number for Category Computer Servers, and Fiscal Year FY2026 in Cost Organization US Operations and Cost Book US Operations.
Cost Component Analysis
- Show Material Cost, Material Overhead Cost, Resource Cost, and Overhead Cost for Item AS85004 for Fiscal Period 06-26, Cost Organization US Operations, and Cost Book US Operations.
- Show Material Cost %, Material Overhead Cost %, Resource Cost %, and Overhead Cost % for Category Tablet Computers in Fiscal Year FY2026, Cost Organization US Operations, and Cost Book US Operations.
- Show Profit in Inventory and Profit in Inventory % by Cost Element and Cost Element Type for Category Computer Servers in the current Fiscal Quarter, Cost Organization US Operations, and Cost Book US Operations.
- Which Top 5 Items have the highest Overhead Cost by Expense Pool Description for Category Tablet Computers over the last six Fiscal Periods in Cost Organization US Operations and Cost Book US Operations?
- Which Top 10 Categories have the highest Material Overhead Cost and Resource Cost by Cost Element in Fiscal Year FY2026, Cost Organization US Operations, and Cost Book US Operations?
- Show Material Cost % and Material Overhead Cost % by Cost Element Type for Item AS46337 for Fiscal Period 06-26, Cost Organization US Operations, and Cost Book US Operations.
Item and Category Cost Analysis
- Show Item Description, UOM, Catalog, Functional Area, Category, and Category Description for Item AS46334, Cost Organization US Operations, and Cost Book US Operations.
- Which Top 10 Items have the highest Unit Cost by UOM for Category Computer Servers in Fiscal Period Jun-26, Cost Organization US Operations, and Cost Book US Operations?
- Which Top 5 Categories have the highest Profit in Inventory in Fiscal Year FY2026, Cost Organization US Operations, and Cost Book US Operations?
- Show the Top 10 Items by Unit Cost and Profit in Inventory % for Category Computer Servers in Fiscal Quarter 2026Q2, Cost Organization US Operations, and Cost Book US Operations.
- Show the Top 10 Items by Unit Cost and UOM for Category Tablet Computers and Catalog Corporate Item Catalog in Fiscal Year FY2026, Cost Organization US Operations, and Cost Book US Operations.
Valuation and Costing Configuration
- Show Unit Cost by Valuation Unit and Valuation Structure Type for Item AS85017 for Fiscal Period 06-26, Cost Organization US Operations, and Cost Book US Operations.
- Show Unit Cost by Cost Profile and Cost Method for Category Tablet Computers using Cost Method Standard Cost in Fiscal Year FY2026, Cost Organization US Operations, and Cost Book US Operations.
- Show Item, Primary Book Indicator, and Cost Currency for Item AS46336, Cost Organization US Operations, and Cost Book US Operations.
- Which Top 5 Items have the highest Unit Cost by Valuation Unit for Category Computer Servers and Cost Method Standard Cost in the current Fiscal Quarter, Cost Organization US Operations, and Cost Book US Operations?
- Which Top 10 Categories have the highest Profit in Inventory by Cost Profile over the last six Fiscal Periods in Cost Organization US Operations and Cost Book US Operations?
- Show Unit Cost by Category, Cost Method, and Valuation Structure Type for Category Tablet Computers in Fiscal Year FY2026, Cost Organization US Operations, and Cost Book US Operations.
Scenario, Publication, and Effective Dates
- Show Unit Cost and Profit in Inventory by Scenario for Item AS85001 and Scenario Published for Fiscal Period 06-26, Cost Organization US Operations, and Cost Book US Operations.
- Show Unit Cost by Published with Transaction Indicator for Category Tablet Computers with indicator Yes over the last six Fiscal Periods in Cost Organization US Operations and Cost Book US Operations.
- Show Unit Cost with Cost Effective Start Fiscal Date and Cost Effective End Fiscal Date for Item AS85004 for Fiscal Year FY2026, Cost Organization US Operations, and Cost Book US Operations.
Pre-Requisites:
- FDI Release: 26.R2
- Offering: Supply Chain Management Analytics
- Functional Area Activation: Cost 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.
