| layout | default |
|---|---|
| title | FND Descriptive Flexfields | Oracle EBS SQL Report |
| description | Descriptive flexfields table, context, column and validation information – Oracle E-Business Suite SQL report |
| keywords | Oracle EBS, Oracle E-Business Suite, SQL report, Blitz Report, Enginatics, FND, Descriptive, Flexfields, fnd_application_vl, fnd_descriptive_flexs_vl, fnd_descr_flex_contexts_vl |
| permalink | /FND%20Descriptive%20Flexfields/ |
Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™.
Descriptive flexfields table, context, column and validation information
Application, Name, Title, Table Name, Window Prompt, Validation Table Name, Show LOV Query
fnd_application_vl, fnd_descriptive_flexs_vl, fnd_descr_flex_contexts_vl, fnd_descr_flex_col_usage_vl, fnd_flex_value_sets, fnd_flex_validation_tables
FND Flex Value Sets, Usages and Values, FND Concurrent Programs and Executables 11i, FND Concurrent Programs and Executables, PER Organizations, FND Key Flexfields, HR Organization Upload
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 | FND Descriptive Flexfields 24-Jul-2017 144351.xlsx |
| Blitz Report™ XML Import | FND_Descriptive_Flexfields.xml |
| Full SQL on Enginatics | www.enginatics.com/reports/fnd-descriptive-flexfields/ |
The FND Descriptive Flexfield report is the comprehensive documentation tool for all DFF configurations in the system. It details every context, segment, and validation rule associated with a flexfield.
- Configuration Audit: Documenting all custom fields added to screens for compliance or upgrade planning.
- Troubleshooting: Debugging why a specific field is mandatory or has a specific list of values.
- Knowledge Transfer: Explaining the custom data model to new developers or business analysts.
This Blitz Report extracts the full DFF definition:
- Contexts: Lists the "Global Data Elements" and any context-sensitive structures.
- Segments: Details each segment (Attribute1, Attribute2, etc.), its prompt, and display size.
- Validation: Shows the Value Set attached to each segment and the underlying validation logic (SQL or independent values).
The report joins FND_DESCRIPTIVE_FLEXS, FND_DESCR_FLEX_CONTEXTS, and FND_DESCR_FLEX_COL_USAGE. It provides a hierarchical view of the flexfield structure.
- Title: Search by the user-friendly name of the DFF (e.g., "Order Headers").
- Table Name: Search by the underlying table (e.g.,
OE_ORDER_HEADERS_ALL). - Show LOV Query: Option to display the SQL query used by Table-validated value sets.
- Complex Validations: If "Show LOV Query" is enabled, the report may take slightly longer to render large SQL blocks.
- Q: Can I see Key Flexfields here?
- A: No, this is for Descriptive Flexfields. Use "FND Key Flexfields" for the accounting flexfield, item category, etc.
- 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