FND Descriptive Flexfield Table Columns – Oracle EBS SQL Report
Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™.
Overview
Shows all active descriptive flexfield table columns.
Report Parameters
Application, Name, Title, Table Name
Oracle EBS Tables Used
fnd_application_vl, fnd_descriptive_flexs_vl, fnd_tables, fnd_columns
Report Categories
Related Reports
FND Flex Value Sets, Usages and Values, FND Tables and Columns, FND Descriptive Flexfields, Blitz Report Parameter DFF Table Validation, FND Key Flexfields, CST Detailed Item Cost, FND Flex Value Security Rules, CAC Inventory Lot and Locator OPM Value (Period-End), CAC Inventory Pending Cost Adjustment - No Currencies
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 Descriptive Flexfield Table Columns 04-Apr-2026 123137.xlsx |
| Blitz Report™ XML Import | FND_Descriptive_Flexfield_Table_Columns.xml |
| Full SQL on Enginatics | www.enginatics.com/reports/fnd-descriptive-flexfield-table-columns/ |
Executive Summary
The FND Descriptive Flexfield Table Columns report provides a technical mapping of database columns to Descriptive Flexfields (DFFs). It identifies which columns in a table are enabled for flexfield usage.
Business Challenge
- Customization Analysis: Identifying which tables have available “Attribute” columns for storing custom data.
- Data Migration: Mapping legacy data to specific DFF segments during a migration project.
- Cleanup: Finding unused or disabled flexfield columns.
The Solution
This Blitz Report lists the columns in FND_TABLES that are registered as part of a Descriptive Flexfield:
- Table Mapping: Shows the database table name (e.g.,
PO_HEADERS_ALL). - Column Usage: Lists the specific column (e.g.,
ATTRIBUTE1) and its status.
Technical Architecture
The report joins FND_TABLES, FND_COLUMNS, and FND_DESCRIPTIVE_FLEXS to show the relationship between the physical table structure and the logical flexfield definition.
Parameters & Filtering
- Table Name: Filter by the database table you are investigating.
- Application: Filter by module (e.g., “Purchasing”).
Performance & Optimization
- Metadata Report: Runs instantly against the data dictionary.
FAQ
- Q: Does this show the values in the columns?
- A: No, this report shows the definition of the columns. To see the data, you would need to query the table itself or use the “FND Descriptive Flexfields” report to see the configuration.
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