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 Bank Statement Reconciliation Activity workbook empowers business users to explore and understand bank statement data through natural language interactions, making bank statement analytics more intuitive and accessible.
In this AI enabled workbook, users can ask questions conversationally and instantly uncover insights into reconciled and unreconciled statements and its transactions including auto reconciliations, statement aging days. The workbook also enables interactive analysis of the bank statement activity across key dimensions such as Legal Entity, Bank Account and Bank Account Currency and other attributes, helping leaders make faster, data-driven decisions.
Application: Fusion ERP Analytics
Fusion Module: Cash Management
Target Persona: Cash Manager
Subject Areas: Financials -Cash Management Bank Statement
Business Use Case/Questions:
- Show unreconciled amounts by Fiscal period for <Legal Entity>and Bank Account Currency USD for the current fiscal year
- Show Top 5 Bank Accounts with Unreconciled Amounts in USD currency for <Legal Entity>
- What are the Top 5 Bank Accounts with Unreconciled Deposits for <Legal Entity> and bank Account Currency USD
- Which Bank Account has the highest Unreconciled Deposit in USD Currency
- Show Top 10 Statements in USD Currency with highest unreconciled Amount.
- Show Top 5 Unreconciled Amount by Transaction Type for Bank Account Currency USD
- What are the Unreconciled Payments for the USD Currency Accounts for <Legal Entity>
- List Top 10 Statements with unreconciled lines count by Bank Account
- What is the auto reconciled and manual reconciled lines count for statement end date in last 12 months
- Show Auto reconciled Lines Count % by Bank Account for the current Fiscal Period
- Show Incomplete bank statements count by Bank Account where Statement end date is in last 12 months relative to today
- Show Top 10 Bank Accounts with Total Lines Count, Reconciled Lines Count and Unreconciled Lines Count for the current fiscal period for the Legal Entity < >
- List Unreconciled Deposits and Payments by Bank Account Currency in the current Fiscal Period.
- List Total Lines Count, Reconciled Lines Count and Unreconciled Lines Count for the current fiscal period by Transaction Type for the Legal Entity
- Show the trend of total lines count by fiscal period for the current fiscal year for all USD Bank Accounts for <Legal Entity>
- Show the trend of Total Line Amount by fiscal period for the current fiscal year for all USD Bank Accounts for <Legal Entity>
- Show trend of Deposit and Payment by fiscal period for the current year for USD currency Accounts for <Legal Entity>
- Show Deposit and Payment Trend by fiscal period for the USD currency Accounts for all Legal Entities for <fiscal calendar> for the current year.
Prerequisites
- 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: Cash 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.
