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 valuations analytics workbook that helping users explore, analyze and refine inventory valuation insights using natural-language prompts.
Application: Fusion SCM Analytics
Fusion Module: Cost Management
Target Persona: Cost Accountant
Subject Areas: SCM - Inventory Valuations, SCM - Inventory Valuations LSA
Business Use Case/Questions:
- Show me the Costed on Hand Amount for Cost Book ZCST-Seattle for Cost Org ZCST-Seattle for the last 6 periods.
- Show me the Unit Cost by Category for Cost Book ZCST-Seattle for Cost Org ZCST-Seattle for the last 6 periods.
- Show me the Accounted on Hand Amount for Cost Book ZCST-Seattle for Cost Org ZCST-Seattle for the last 6 periods.
- Show me the Unaccounted on Hand Amount for Cost Book ZCST-Seattle for the last 6 periods.
- Show me the period trend line of Accounted on Hand Amount by Inventory Org for Cost Book ZCST-Seattle for Cost Org ZCST-Seattle for the current year.
- Show me the period trend line of Unaccounted on Hand Amount by Inventory Org for Cost Book ZCST-Seattle for Cost Org ZCST-Seattle for the current year.
- Which item has the highest Unit Cost for Cost Book ZCST-Seattle for Cost Org ZCST-Seattle for the current year?
- Show me the Top 10 Items with the highest Unit Cost for Cost Book ZCST-Seattle for Cost Org ZCST-Seattle for the current year.
- Show me the breakdown of Costed on Hand Quantity by Category for Functional Area Inventory for Cost Book ZCST-Seattle for Cost Org ZCST-Seattle for the prior year.
- Show me the breakdown of Costed on Hand Quantity by Inventory Org, Subinventory, and Locator for Cost Book ZCST-Seattle for Cost Org ZCST-Seattle for the prior year.
- Show me the Top 10 Items with the highest Costed on Hand Amount for Cost Book ZCST-Seattle for Cost Org ZCST-Seattle for the last two quarters.
- Show me the Costed on Hand Amount for Item AS62445 for Cost Book ZCST-Seattle for Cost Org ZCST-Seattle for the current period.
- What are the inventory valuations for items or item category for the current period for Cost Book ZCST-Seattle for Cost Org ZCST-Seattle?
- What is the period trend in inventory valuations for items and organizations in the current year for Cost Book ZCST-Seattle for Cost Org ZCST-Seattle?
- Show me a trend of Unit Cost by Value As of Date for Item AS62445 for Cost Book ZCST-Seattle for Cost Org ZCST-Seattle for Value As of Date between Jan 1, 2025 and Jan 30, 2025.
- Show me a trend of Unit Cost by Month of Value As of Date for Item AS62445 for Cost Book ZCST-Seattle for Cost Org ZCST-Seattle for Value As of Date between Jan 1, 2025 and Dec 31, 2025.
- Show me the Top 10 Items with the highest Costed on Hand Amount for each Inventory Org for Cost Book ZCST-Seattle for Cost Org ZCST-Seattle for the current year.
- What is the periodic trend in Costed on Hand Amount for items and organizations for Cost Book ZCST-Seattle for Cost Org ZCST-Seattle for the current year?
- Which Valuation Structure Type has the highest Costed on Hand Amount for Cost Book ZCST-Seattle for Cost Org ZCST-Seattle for the current year, for the fiscal calendar accounting?
- Show me Unit Cost by Quarter for the last two quarters for Cost Book ZCST-Seattle for Cost Org ZCST-Seattle.
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.
