Skip to content

README.md

Latest commit

 

History

History
80 lines (58 loc) · 5.65 KB

README.md

File metadata and controls

80 lines (58 loc) · 5.65 KB
layout default
title FND Descriptive Flexfield Table Columns | Oracle EBS SQL Report
description Shows all active descriptive flexfield table columns. – Oracle E-Business Suite SQL report
keywords Oracle EBS, Oracle E-Business Suite, SQL report, Blitz Report, Enginatics, FND, Descriptive, Flexfield, Table, fnd_application_vl, fnd_descriptive_flexs_vl, fnd_tables
permalink /FND%20Descriptive%20Flexfield%20Table%20Columns/

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

Enginatics

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

© 2026 Enginatics