Search Results fnd_descr_flex_column_usages

Overview

The FND_DESCR_FLEX_COLUMN_USAGES table is a core repository table within the Oracle E-Business Suite Application Object Library (FND). It serves as the technical mapping layer between the physical database and the logical configuration of Descriptive Flexfields (DFFs). Its primary role is to define the correspondences between specific columns in application tables and the user-configurable segments that comprise a DFF. This table is essential for the runtime engine to correctly store and retrieve flexfield data, ensuring that user-defined segment values are written to the appropriate underlying application table columns. It is a critical component for the extensibility framework in both Oracle EBS 12.1.1 and 12.2.2.

Key Information Stored

The table stores the metadata that binds a DFF segment to a database column. Key columns, as defined by its primary and unique keys, include APPLICATION_ID, DESCRIPTIVE_FLEXFIELD_NAME, and DESCRIPTIVE_FLEX_CONTEXT_CODE to uniquely identify a specific DFF context. The APPLICATION_COLUMN_NAME specifies the actual database column (e.g., ATTRIBUTE1) that stores the segment's value. The END_USER_COLUMN_NAME represents the internal identifier for the segment as seen by administrators during setup. Other crucial columns include FLEX_VALUE_SET_ID, which links the segment to a validated list of values, and columns controlling display properties, security, and requiredness (DISPLAY_FLAG, ENABLED_FLAG, REQUIRED_FLAG, DISPLAY_SIZE).

Common Use Cases and Queries

This table is central to technical analysis, troubleshooting, and impact assessment related to DFFs. Common use cases include identifying all columns used by a specific DFF, auditing segment configurations, and diagnosing data issues where segment values may not appear correctly. A typical query retrieves the segment-to-column mapping for a known flexfield:

• SELECT application_column_name, end_user_column_name, flex_value_set_id, enabled_flag FROM apps.fnd_descr_flex_column_usages WHERE application_id = 401 AND descriptive_flexfield_name = 'PER_PEOPLE_F' AND descriptive_flex_context_code = 'PER_DATA_EFFECTIVE_DATE' ORDER BY column_seq_num;

Developers and DBAs also query this table to understand which application table columns are occupied by flexfield data before modifying tables or to generate documentation of all DFF segments tied to a particular base table.

Related Objects

As indicated by the foreign keys in the metadata, FND_DESCR_FLEX_COLUMN_USAGES has direct dependencies on several other key flexfield metadata tables. It is a child of FND_DESCR_FLEX_CONTEXTS, which defines the contexts within a DFF. It references FND_FLEX_VALUE_SETS to validate segment input. Its translated names and descriptions are stored in the related translation table, FND_DESCR_FLEX_COL_USAGE_TL. Furthermore, this table is the technical foundation for the user-facing configuration screens accessed via the "Descriptive Flexfield Segments" form (AD_DESCR_FLEX_COLUMN_USAGES form interface).