Skip to the content.

FND Descriptive Flexfield Table Columns – 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

Shows all active descriptive flexfield table columns.

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

Oracle EBS Tables Used

fnd_application_vl, fnd_descriptive_flexs_vl, fnd_tables, fnd_columns

Report Categories

Enginatics

FND Flex Value Sets, Usages and Values, FND Tables and Columns, FND Descriptive Flexfields, Blitz Report Parameter DFF Table Validation, FND Key Flexfields, FND Flex Value Security Rules, PER Person Extra Information Upload, FA Mass Additions Upload 11i, FA Mass Additions 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 Flexfield Table Columns 04-Apr-2026 123137.xlsx
Blitz Report™ XML Import FND_Descriptive_Flexfield_Table_Columns.xml
SQL Source FND Descriptive Flexfield Table Columns.sql
Full Report 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

The Solution

This Blitz Report lists the columns in FND_TABLES that are registered as part of a Descriptive Flexfield:

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

Performance & Optimization

FAQ


© Enginatics GmbH