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: AI-enabled Cost Accounting Analysis workbook empowers Cost Accountants to explore and understand transaction debit, credit, and net amounts, costing status, distribution accounting status, and costed quantities using natural-language questions.
Application: Fusion SCM Analytics
Fusion Module: Cost Management
Target Persona: Cost Accountant
Subject Areas: SCM – Cost Accounting, SCM - Cost Accounting Analysis LSA
Business Use Case/Questions:
Debit and Credit Amounts
- Show Transaction Debit Amount and Transaction Credit Amount for Item AS35001 in Cost Organization US Operations and Cost Book Financial for Fiscal Period 01-26.
- Show the Fiscal Period trend in Transaction Debit Amount and Transaction Credit Amount for Item AS35001 in Cost Organization US Operations and Cost Book Financial over the last six Fiscal Periods.
- Show Transaction Debit Amount and Transaction Credit Amount by Transaction Type for Item AS35001 in Cost Organization US Operations and Cost Book Financial for Fiscal Period 01-26.
- Which top five Items have the highest Transaction Debit Amount in Cost Organization US Operations and Cost Book Financial for Fiscal Quarter 2026Q1?
- Show Transaction Debit Amount and Transaction Credit Amount by Business Unit for Category Laptops in Cost Organization US Operations and Cost Book Financial for Fiscal Year 2026.
- Show Transaction Debit Amount and Transaction Credit Amount by Inventory Organization and Subinventory for Item AS35001 in Cost Organization US Operations and Cost Book Financial for Fiscal Period 01-26.
Costing and Accounting Status
- Show Transaction Debit Amount and Transaction Credit Amount by Costing Status for Item AS35001 in Cost Organization US Operations and Cost Book Financial for Fiscal Period 01-26.
- Show Transaction Debit Amount and Transaction Credit Amount by Distribution Accounting Status for Category Laptops in Cost Organization US Operations and Cost Book Financial for Current Fiscal Quarter.
- Show Transaction Debit Amount and Transaction Credit Amount by Accounting Line Type for Distribution Accounting Status Final accounted in Cost Organization US Operations and Cost Book Financial for Current Fiscal Quarter.
Item and Quantity Analysis
- Show Transaction Quantity, Costed Quantity, UOM, UOM Code, Cost UOM, and Cost UOM Code for Item AS35001 in Cost Organization US Operations and Cost Book Financial for Fiscal Period 01-26.
- List the top five Items by Transaction Quantity with Item Description and Category in Cost Organization US Operations and Cost Book Financial for Current Fiscal Quarter.
- Show Transaction Quantity and Costed Quantity by Inventory Organization and Inventory Organization Name for Item AS35001 in Cost Organization US Operations and Cost Book Financial for Fiscal Period 01-26.
- List Item, Item Description, Category, Catalog, and Functional Area for the top 10 Items by Costed Quantity in Cost Organization US Operations and Cost Book Financial for Current Fiscal Quarter.
- Show Costed Quantity, Cost UOM, and Cost UOM Code by Subinventory for Item AS35001 in Cost Organization US Operations and Cost Book Financial for Fiscal Period 01-26.
Cost Elements and Accounting Lines
- Show Transaction Debit Amount and Transaction Credit Amount by Cost Element Type for Item AS35001 in Cost Organization US Operations and Cost Book Financial for Fiscal Quarter 2026Q1.
- Show Transaction Debit Amount and Transaction Credit Amount by Accounting Line Type and Cost Element for Item AS35001 in Cost Organization US Operations and Cost Book Financial for Fiscal Period 01-26.
- Show Transaction Debit Amount and Transaction Credit Amount by Cost Element Type and Transaction Type for Category Laptops in Cost Organization US Operations and Cost Book Financial for Fiscal Period 01-26.
Transaction and Reference Details
- List the top 10 Inventory Transaction Numbers with Reference Number, Reference Transaction Number, and Transaction Reference Type by Transaction Debit Amount in Cost Organization US Operations and Cost Book Financial for Current Fiscal Period.
- Show Transaction Type, Transaction Reference Type, Reference Number, Cost Method, Transaction Debit Amount, and Transaction Credit Amount for Item AS35001 in Cost Organization US Operations and Cost Book Financial for Fiscal Period 01-26.
- Show Transaction Quantity, UOM Code, Costed Quantity, and Cost UOM Code by Inventory Transaction Number for Item AS35001 in Cost Organization US Operations and Cost Book Financial for Fiscal Period 01-26.
Pre-Requisites:
- FDI Release: 26.R2
- Offering: Supply Chain Management Analytics
- Functional Area Activation: Cost Accounting
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.
