| layout | default |
|---|---|
| title | FND Tables and Columns | Oracle EBS SQL Report |
| description | Registered FND tables, columns, primary keys and their flexfields – Oracle E-Business Suite SQL report |
| keywords | Oracle EBS, Oracle E-Business Suite, SQL report, Blitz Report, Enginatics, FND, Tables, Columns, fnd_application_vl, fnd_tables, fnd_columns |
| permalink | /FND%20Tables%20and%20Columns/ |
Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™.
Registered FND tables, columns, primary keys and their flexfields
Table Name, Column Name like, Key Columns only
fnd_application_vl, fnd_tables, fnd_columns, fnd_primary_key_columns, fnd_primary_keys, fnd_descriptive_flexs_vl
FND Flex Value Sets, Usages and Values, FND Descriptive Flexfield Table Columns, FND Audit Setup, CAC Invoice Price Variance, Blitz Report Parameter DFF Table Validation, FA Asset Book Details, CST Detailed Item Cost, CAC Last Standard Item Cost, CAC OPM WIP Account Value
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.
| Resource | Link |
|---|---|
| Excel Example Output | None |
| Blitz Report™ XML Import | FND_Tables_and_Columns.xml |
| Full SQL on Enginatics | www.enginatics.com/reports/fnd-tables-and-columns/ |
The FND Tables and Columns report serves as a dynamic data dictionary for the Oracle EBS application. It lists registered tables, their columns, primary keys, and associated descriptive flexfields. This is an invaluable resource for developers, report writers, and data analysts.
Oracle EBS has thousands of tables. Finding the correct table name, column name, or understanding the primary key structure for a specific entity can be challenging. Documentation is not always up to date with custom extensions or specific patch levels.
This report provides an "as-built" view of the database schema as registered in the Application Object Library (AOL). It helps users:
- Search for tables by name or pattern.
- Find specific columns across the entire schema.
- Identify primary keys for joining tables.
- See which tables have Descriptive Flexfields (DFFs) enabled.
The report queries the AOL dictionary tables: fnd_tables, fnd_columns, fnd_primary_keys, and fnd_descriptive_flexs. This ensures the information matches exactly what the application "knows" about the database.
- Table Name: Search for a specific table (e.g.,
PO_HEADERS_ALL). - Column Name like: Find tables containing a specific column (e.g.,
%VENDOR_ID%). - Key Columns only: Restrict the output to only show primary key columns, useful for understanding join conditions.
The report is optimized for metadata querying. Searching by Column Name like with a leading wildcard (e.g., %ID) may be slower than searching by Table Name.
Q: Does this include custom tables?
A: It includes any custom tables that have been registered in EBS using the AD_DD package or the "Register Table" form. It will not show custom tables that exist in the database but are not registered in AOL.
Q: Why don't I see a specific view?
A: This report focuses on Tables. While some views are registered in fnd_tables, many are not.
- 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