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 aging workbook and AI agent that help users explore aging inventory through natural language prompts. Users can analyze aging bands, aged value, expired and near expiry lots, organizations, items, categories, subinventories, and consigned inventory.
Application: Fusion SCM Analytics
Fusion Module: Inventory Management
Target Persona: Inventory Manager, Inventory Analyst, Supply Chain Planner
Subject Areas: SCM - Inventory Aging, SCM - Inventory Aging LSA
Business Use Case/Questions:
Aging Profile and Trends
- What is the total inventory aging value by aging band?
- What is the total inventory aging quantity by aging band?
- Show inventory aging value trend by fiscal period.
- Compare aged inventory value this fiscal quarter versus last fiscal quarter.
- Show inventory age quantity by category for the current fiscal period.
Organization Category and Subinventory Risk
- Which inventory organizations have the highest inventory value older than 90 days?
- Which inventory organizations have the highest inventory value older than one year?
- Which categories have the highest aged inventory value?
- Which subinventories contain the highest aged inventory value?
- What is the average inventory age by inventory organization?
- Which inventory organizations have the greatest value in the 181 to 365 days and 1 plus year aging bands?
Item Level Aging Analysis
- Show the top 10 items with the highest inventory value older than 90 days.
- Which items have the highest average inventory age?
- Which items have both high inventory age and high inventory value?
Expiry and Lot Management
- Show expired lot quantity and expired lot value by inventory organization.
- Which lots have the highest expired inventory value?
- Which lots are expiring in the next 30 days?
- Which items are expiring in the next 30 days?
- List the expired and near expiry lot worklist, including item, lot, expiry date, organization, quantity, and value.
Consigned Inventory
- Show consigned inventory quantity and aged inventory value by owning party.
Pre-Requisites:
- FDI Release: 26.R3
- 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.
