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: An AI-enabled intercompany workbook that provides document-currency visibility into IC transaction volume, value, and reconciliation across the full Provider → Receiver lifecycle — spanning fiscal time, provider and receiver legal entity, ledger, batch, transaction type, transaction status, GL account, and AP/AR accounting and posting status dimensions. Paired with the Intercompany 360 Agent for natural-language Q&A over the same data.
- Content Type: AI Data Agent + Workbook
- Application: ERP
- Fusion Module: Global Intercompany (GIC)
- Target Persona: Intercompany Accountant, Controller, GL Accountant, Finance Manager, Reconciliation Analyst
- Subject Areas: Financials - Global Intercompany Transactions
Business Use Case / Questions:
- What is the trend for Intercompany transaction net amount for the last 3 fiscal years?
- What is the total IC transaction net amount trend by fiscal quarter?
- What is the IC transaction net amount by provider legal entity?
- Compare transaction net amount by receiver legal entity for last year.
- Which are the top 10 provider legal entities by transaction net amount for the last fiscal year? Show provider and receiver legal entity as a table.
- List transaction net amount by transaction type for the last three fiscal years and sort high to low.
- Which are the top 10 transaction types for the last 3 years?
- Top 10 transaction types by transaction net amount for last 8 fiscal quarters.
- Which quarter had the highest IC net amount in the last 2 years?
- Show total transaction net amount by transaction status.
- How much of the submitted and approved amount is still pending transfer to GL? Show in a table and include status.
- Show transaction count by transaction status for last 3 years.
- Show me transactions with status Complete by fiscal year.
- What is the GL posting gap by provider legal entity?
- Which 10 provider–receiver entity pairs have the highest unposted (GL posting gap) amount?
- What is the match rate by provider legal entity this period?
- Which provider legal entities have the lowest match rate?
- Which transactions are stuck before posting (in a non-terminal status)? List in a table.
- List entity pairs with at-risk amount more than 100,000.
- Which providers generated the highest number of Intercompany batches?
- What is the average processing and acceptance cycle time by transaction type?
Pre-Requisites:
FDI release 26.R2 or later. Global Intercompany (GIC) is a Preview module in 26.R2; the Global Intercompany functional area should be activated.
Download: Available in the FDI Content Library.
We'd love to get your feedback and business use cases to help build more sample FDI content.
