This post shares Fusion ERP 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 Award Performance Analysis workbook empowers business users to explore and understand award funding and utilization data through natural language interactions, making grants award funding analysis more intuitive and accessible.
This AI-enabled workbook empowers users to ask natural language questions and instantly uncover insights into award funding and project allocations. Users can explore detailed funding consumption, analyze how awards are allocated across projects, and gain a clear understanding of budget utilization. The workbook also supports interactive analysis of award funding, budgets, and unbudgeted amounts across different budget periods, enabling users to identify trends, monitor financial performance, and make informed decisions with ease.
Application: Fusion ERP Analytics
Fusion Module: Grants Management
Target Persona: Award Administrator, Principal Investigator
Subject Areas: PPM- Grants Award Funding
Business Use Case/Questions:
- Extract a Total Funding and Unallocated Funding Trend for the past 3 years including current for "X" business unit in <Currency>?
- Extract Top 5 Total Funding Amount in <Currency>by Sponsor and break it down by Award?
- What is the Total Unallocated Funding in <Currency> for the <Principal Investigator>for the <Business Unit>?
- What is the award wise breakup of the unallocated funding for the <Principal Investigator> in <Currency>?
- What is the Unallocated Funding for <Award Number>?
- Extract the total funding, project funding and unallocated funding by budget period for the award <Award Number>?
- What are the total actuals and commitments for the <Award Number>?
- Show the trend of Open commitments for the <Award Number>?
- Extract Direct and Indirect Funding trend by Fiscal Year for the <Business Unit> in <Currency>?
- What is the Unbudgeted Amount by Funding source for the <Award Number> by budget period?
- What are the remaining Days left and Budget Available Amount for the <Award Number>?
- Extract Top 5 Unallocated Funding by Funding Source and Award Number for <Business Unit>
- Show Top 5 Award and Award Projects with high burn rate for the <Business Unit>
- Show Budget, Actual and Commitment Trend by fiscal period for the <Award Organization>
- Show the Authorized Budget Spend and Consumed Amount for the <Award Number> by Project
Pre-Requisites
- Fusion Data Intelligence Release: 26.R2 or higher
- Ensure the relevant FDI application and functional areas are activated in your FDI instance
- Application: Fusion ERP Analytics
- Functional Area: Grants Management
- User has permissions to import workbooks and agents
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.