Search Results fnd_flexbuilder_parameters




Overview
Explore in AI Chat

Overview

The FND_FLEXBUILDER_PARAMETERS table is a core repository within the Application Object Library (FND) that defines the parameters for Flexbuilder functions in Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2. Flexbuilder is the underlying engine that constructs and manages the user interface for descriptive and key flexfields, which are central to the application's extensibility. This table stores the metadata that dictates the behavior, validation, and relationships of parameters used when configuring or displaying flexfield segments. It serves as a master definition table, enabling the dynamic generation of flexfield-related UI components and logic based on specific functional contexts.

Key Information Stored

The table's structure is defined by a composite primary key consisting of APPLICATION_ID, FUNCTION_CODE, PARAMETER_NAME, and SEQUENCE. This design allows multiple parameter definitions for a single function. Key columns include the FUNCTION_CODE, which identifies the specific Flexbuilder function, and the PARAMETER_NAME. The table heavily integrates with flexfield metadata through foreign key columns such as FLEX_VALUE_SET_ID and ASSIGNMENT_VALUE_SET_ID, linking to validation sets. It also references specific flexfield segments via FLEXFIELD_APPLICATION_ID, ID_FLEX_CODE, ID_FLEX_NUM, and APPLICATION_COLUMN_NAME, and connects to segment attribute definitions through SEGMENT_ATTRIBUTE_TYPE. The SEQUENCE column orders parameters within a function.

Common Use Cases and Queries

This table is primarily accessed for diagnostic, configuration analysis, and impact assessment tasks. Common scenarios include identifying all parameters for a specific Flexbuilder function to understand its configuration scope, or tracing which functions utilize a particular value set before modifying it. A typical query retrieves parameter definitions for a known function, often joining to the translated names table (FND_FLEXBUILDER_PARAMS_TL) for user-friendly descriptions. For example:

  • SELECT p.*, tl.PARAMETER_DISPLAY_NAME FROM FND_FLEXBUILDER_PARAMETERS p, FND_FLEXBUILDER_PARAMS_TL tl WHERE p.APPLICATION_ID = tl.APPLICATION_ID AND p.FUNCTION_CODE = tl.FUNCTION_CODE AND p.PARAMETER_NAME = tl.PARAMETER_NAME AND p.SEQUENCE = tl.SEQUENCE AND p.FUNCTION_CODE = 'SPECIFIC_FUNCTION_CODE';

Another critical use case is analyzing dependencies before a flexfield structural change by querying for parameters linked to a specific segment or value set ID.

Related Objects

As indicated by its foreign key relationships, FND_FLEXBUILDER_PARAMETERS is a central hub within the Flexbuilder schema. Key documented relationships include:

  • FND_FLEXBUILDER_FUNCTIONS: Parameters are defined for a specific function (join on APPLICATION_ID, FUNCTION_CODE).
  • FND_FLEX_VALUE_SETS: Parameters can reference two distinct value sets for validation (FLEX_VALUE_SET_ID, ASSIGNMENT_VALUE_SET_ID).
  • FND_ID_FLEX_SEGMENTS: Parameters can be linked directly to a flexfield segment (join on FLEXFIELD_APPLICATION_ID, ID_FLEX_CODE, ID_FLEX_NUM, APPLICATION_COLUMN_NAME).
  • FND_SEGMENT_ATTRIBUTE_TYPES: Parameters can reference a segment attribute type (join on FLEXFIELD_APPLICATION_ID, ID_FLEX_CODE, SEGMENT_ATTRIBUTE_TYPE).
  • FND_FLEXBUILDER_ASSIGNMENTS: This child table references parameters in three ways: as a conditional parameter, a segment parameter, and an ID parameter (join on APPLICATION_ID, FUNCTION_CODE, and the respective parameter name column with SEQUENCE).
  • FND_FLEXBUILDER_PARAMS_TL: The translation table for parameter display names (join on APPLICATION_ID, FUNCTION_CODE, PARAMETER_NAME, SEQUENCE).