FND Descriptive Flexfields – Oracle EBS SQL Report
Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™. Oracle EBS module: Application Object Library · all Application Object Library reports
Overview
Descriptive flexfields table, context, column and validation information
Run this report in Excel in seconds: download Blitz Report™ free (your first 30 reports are free) or try it in the online demo.
Report Parameters
Application, Name, Title, Table Name, Window Prompt, Validation Table Name, Show LOV Query
Oracle EBS Tables Used
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
Report Categories
Related Reports
FND Flex Value Sets, Usages and Values, FND Concurrent Programs and Executables, PER Organizations, PER Person Extra Information Upload, PER Person Extra Information Upload 11i, FA Mass Additions Upload 11i, FA Mass Additions Upload, FND Key Flexfields, INV Item Upload
Running This SQL Without Blitz Report
The SQL source can be run in any SQL client. Some Oracle EBS SQL reports in this library use functions from the utility package xxen_util – install it first. Blitz Report™ adds parameters, Excel output with pivots, scheduling and security on top.
Download & Import Options
| Resource | Link |
|---|---|
| Excel Example Output | FND Descriptive Flexfields 24-Jul-2017 144351.xlsx |
| Blitz Report™ XML Import | FND_Descriptive_Flexfields.xml |
| SQL Source | FND Descriptive Flexfields.sql |
| Full Report on Enginatics | www.enginatics.com/reports/fnd-descriptive-flexfields/ |
Executive Summary
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.
Business Challenge
- 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.
The Solution
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).
Technical Architecture
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.
Parameters & Filtering
- 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.
Performance & Optimization
- Complex Validations: If “Show LOV Query” is enabled, the report may take slightly longer to render large SQL blocks.
FAQ
- 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.
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
© Enginatics GmbH