This post shares Oracle E-Business Suite Data Intelligence sample content as part of Oracle Fusion Data Intelligence (FDI), a family of prebuilt, cloud-native analytics applications. These sample artifacts are intended to demonstrate potential use cases, accelerate implementation efforts, and provide examples of how customers can extend and customize EBS content to meet their business needs. To explore additional reusable sample content, visit the FDI Content Library.
Content Description:
AI-enabled EBS Journal Analysis workbook empowers business users to explore and understand journal amounts and counts by source, category, accounts, posted status, and periods through natural language interactions, making analytics more intuitive and accessible.
Content Type: AI Data Agent + Workbook
Application: E-Business Suite Data Intelligence
EBS Module: General Ledger
Target Persona: Financial Analyst, Controller, and Accounting Leaders
Subject Areas : EBS Financials - GL Detail Transactions
Business Use Case/Questions:
Transaction amounts by financial dimension
- Which cost centers have the highest transaction amounts in <fiscal year>?
- Which financial statement items had the largest transaction amounts for <Ledger Name> in <Fiscal Year>?
- Which accounts had the highest transaction amount in <fiscal year> for <Ledger Name>?
- What are debit and credit amounts by concatenated segments, and account description in <fiscal period>?
Journal sources, categories, and volume
- Which journal categories account for the largest debit amount in <fiscal year>?
- What are the top ten source and category combinations for fiscal year <fiscal year> by Journal Count?
- Show the Journal count by Journal Category for <Ledger Name> in <fiscal year>.
Unposted journals and amounts
- Which journal sources have the largest transaction amounts for unposted records?
- Show the absolute value of transaction amount in Unposted status by Concatenated Segments for <Ledger Name>.
- How many Journals are in Unposted status by Journal Source?
- Which journal sources have the largest debit amounts for unposted records?
- List the unposted Journal Batches in <Fiscal Year>.
Journal details
- Show GL journal details for account <account code>, including fiscal period, journal batch, journal header, posted status, and amount in <fiscal year>.
Pre-Requisites:
- Fusion Data Intelligence Release: 26.R3.P4 or higher
- Ensure the Pre-requisites for E-Business Suite Data Intelligence Bundles are deployed. Refer Link
- Application: E-Business Suite Data Intelligence
- Module: EBS General Ledger
- 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 more sample EBS content.