FND Data Groups – Oracle EBS SQL Report
Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™.
Overview
None
Report Parameters
Data Group Name
Oracle EBS Tables Used
fnd_data_groups, fnd_data_group_units, fnd_application_vl, fnd_oracle_userid
Report Categories
Related Reports
FND Applications, CAC Inventory and Intransit Value (Period-End) - Discrete/OPM, FND Audit Setup, CAC WIP Material Usage Variance, CAC WIP Resource Efficiency, CAC ICP PII WIP Material Usage Variance, CAC Inventory Lot and Locator OPM Value (Period-End), FND Responsibility Access
Running This SQL Without Blitz Report
Some Oracle EBS SQL reports in this library require functions from the utility package xxen_util. Install it before running the SQL directly against your Oracle EBS database.
Download & Import Options
| Resource | Link |
|---|---|
| Excel Example Output | FND Data Groups 04-Apr-2026 123137.xlsx |
| Blitz Report™ XML Import | FND_Data_Groups.xml |
| Full SQL on Enginatics | www.enginatics.com/reports/fnd-data-groups/ |
Executive Summary
The FND Data Groups report documents the Data Group configuration in EBS. Data Groups determine which Oracle ID (database schema) a concurrent program connects to when it runs.
Business Challenge
- Multi-Schema Support: Managing environments where different applications store data in different schemas (common in custom bolt-ons).
- Security: Verifying that programs are connecting with the appropriate privileges.
- Troubleshooting: Solving “Table or View does not exist” errors when a program runs in the wrong context.
The Solution
This Blitz Report lists the mapping between Applications and Oracle IDs within each Data Group:
- Group Definition: Shows the name of the Data Group (e.g., “Standard”).
- Application Mapping: Lists every application (e.g., “Assets”) and the Oracle User (e.g., “FA”) it maps to in that group.
Technical Architecture
The report queries FND_DATA_GROUPS and FND_DATA_GROUP_UNITS. It joins FND_ORACLE_USERID to show the actual database schema name.
Parameters & Filtering
- Data Group Name: Filter for a specific group.
Performance & Optimization
- Configuration Report: Runs instantly.
FAQ
- Q: What is the “Standard” data group?
- A: It is the default group where each application maps to its own standard schema (e.g., GL maps to GL schema).
- Q: Why would I change this?
- A: You might create a custom Data Group to point a standard report to a reporting schema or a custom schema for specific processing needs.
Useful Links
- Blitz Report™ – World’s Fastest Oracle EBS Reporting Tool
- Oracle Discoverer Replacement – Import Worksheets into Blitz Report™
- Oracle EBS Reporting Toolkits by Blitz Report™
- Blitz Report™ FAQ & Community Q&A
- Supply Chain Hub by Blitz Report™
- Blitz Report™ Customer Case Studies
- Oracle EBS Reporting Blog
- Oracle EBS Reporting Resource Centre
© 2026 Enginatics