Search Results fnd_compiled_descriptive_flexs




Overview
Explore in AI Chat

Overview

The FND_COMPILED_DESCRIPTIVE_FLEXS table is a core repository for compiled metadata within the Oracle E-Business Suite Application Object Library (FND). It stores the runtime, executable definitions of descriptive flexfields (DFFs) after they have been processed by the flexfield compiler. While base DFF configuration is stored in tables like FND_DESCRIPTIVE_FLEXS, this table holds the optimized, versioned, and language-specific structures that the application uses at runtime to render DFF segments on forms and generate database columns. Its role is critical for performance, ensuring that the complex logic of DFF context and segment display is pre-processed and readily available.

Key Information Stored

The table's structure centers on uniquely identifying a specific compiled version of a DFF. The primary key columns are APPLICATION_ID, DESCRIPTIVE_FLEXFIELD_NAME, COMPILER_VERSION_NUM, SEQUENCE, and LANGUAGE. This design allows for multiple compiled versions (tied to compiler iterations) and supports multilingual deployments. While the full column list is extensive, key stored information includes the internal mapping of context prompts, segment codes, application column names, and display logic. The COMPILER_VERSION_NUM is particularly important, as it links the compiled runtime definition to a specific point in the DFF's configuration history, enabling version control and ensuring consistency.

Common Use Cases and Queries

Direct manipulation of this table is rare and generally not supported; interaction is typically through dedicated flexfield APIs or compiler utilities. However, querying the table is essential for diagnostic and reporting purposes. Common use cases include verifying that a DFF compilation was successful, identifying the current active compiled version, and auditing DFF structures across modules. A foundational query retrieves the latest compiled definition for a specific DFF:

  • SELECT * FROM apps.FND_COMPILED_DESCRIPTIVE_FLEXS WHERE application_id = &app_id AND descriptive_flexfield_name = '&flex_name' AND compiler_version_num = (SELECT MAX(compiler_version_num) FROM apps.FND_COMPILED_DESCRIPTIVE_FLEXS WHERE application_id = &app_id AND descriptive_flexfield_name = '&flex_name');

This data is also crucial for generating technical documentation of implemented DFF structures and troubleshooting issues where segments do not appear as configured.

Related Objects

This table has a direct foreign key relationship to the base configuration table, FND_DESCRIPTIVE_FLEXS, linking via APPLICATION_ID and DESCRIPTIVE_FLEXFIELD_NAME. It is the compiled counterpart to FND_DESCRIPTIVE_FLEXS_VL. The compilation process itself is driven by APIs and packages within the FND_FLEX_DESC module. For developers, the key related API is FND_FLEX_DESC_API. Administrators typically interact with the compilation process via the "Descriptive Flexfields" form or the `fdfcmp` concurrent program, which populate this table. Data in this table is often joined with FND_APPLICATION to resolve application names and FND_DESCR_FLEX_CONTEXTS for context details.