Search Results fnd_flexbuilder_assignments




Overview
Explore in AI Chat

Overview

The FND_FLEXBUILDER_ASSIGNMENTS table is a core repository table within the Application Object Library (FND) module of Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2. It serves as a critical configuration table for the Flexbuilder architecture, which is the underlying framework for defining and managing descriptive flexfields (DFFs). The table's primary role is to store assignment rules that govern how specific parameters and segments of a descriptive flexfield are associated with a particular flexfield function. It acts as a mapping table, linking flexfield definition components to their runtime behavior and validation rules, ensuring the correct structure and parameters are applied when a DFF is rendered in the application user interface.

Key Information Stored

The table's structure is defined by its composite primary key and its relationships to parameter definitions. The primary key consists of APPLICATION_ID, FUNCTION_CODE, ID_FLEX_NUM, and SEQUENCE, which together uniquely identify a specific assignment rule for a flexfield. Key columns include APPLICATION_ID, which identifies the owning application; FUNCTION_CODE, which specifies the flexfield function; and ID_FLEX_NUM, which denotes the specific flexfield structure number. The table holds foreign key references to parameter codes in the FND_FLEXBUILDER_PARAMETERS table, notably through columns such as ID_PARAMETER, SEGMENT_PARAMETER, and CONDITIONAL_PARAMETER. These columns store the codes for parameters that define the flexfield's identifier, its individual segments, and any conditional display logic, respectively. The SEQUENCE column orders the assignments within a given context.

Common Use Cases and Queries

This table is primarily accessed for diagnostic, reporting, and advanced configuration purposes related to descriptive flexfield behavior. A common use case is investigating why a particular DFF segment is not appearing or validating correctly in a form. Developers and functional consultants may query this table to understand the parameter assignments for a specific flexfield function. A typical diagnostic query would join to FND_FLEXBUILDER_PARAMETERS to translate parameter codes into meaningful names.

SELECT ffa.application_id,
       ffa.function_code,
       ffa.id_flex_num,
       ffa.sequence,
       ffa.id_parameter,
       ffp1.parameter_name id_param_name,
       ffa.segment_parameter,
       ffp2.parameter_name seg_param_name
FROM   apps.fnd_flexbuilder_assignments ffa,
       apps.fnd_flexbuilder_parameters ffp1,
       apps.fnd_flexbuilder_parameters ffp2
WHERE  ffa.application_id = ffp1.application_id
AND    ffa.function_code = ffp1.function_code
AND    ffa.id_parameter = ffp1.parameter_code
AND    ffa.application_id = ffp2.application_id
AND    ffa.function_code = ffp2.function_code
AND    ffa.segment_parameter = ffp2.parameter_code
AND    ffa.function_code = '&function_code';

Direct data manipulation in this table is strongly discouraged; configuration should be performed through the official Oracle EBS flexfield definition forms and APIs.

Related Objects

The FND_FLEXBUILDER_ASSIGNMENTS table has a direct and integral relationship with the FND_FLEXBUILDER_PARAMETERS table, as defined by three documented foreign key constraints. These relationships are based on joining specific parameter code columns to the parameter definitions.

  • FND_FLEXBUILDER_PARAMETERS: Joined via (APPLICATION_ID, FUNCTION_CODE, CONDITIONAL_PARAMETER, SEQUENCE). This links an assignment to its conditional display parameter definition.
  • FND_FLEXBUILDER_PARAMETERS: Joined via (APPLICATION_ID, FUNCTION_CODE, SEGMENT_PARAMETER, SEQUENCE). This links an assignment to its individual segment parameter definition.
  • FND_FLEXBUILDER_PARAMETERS: Joined via (APPLICATION_ID, FUNCTION_CODE, ID_PARAMETER, SEQUENCE). This links an assignment to its flexfield identifier parameter definition.

This table is a foundational component for the FND_FLEX_VALIDATION_PKG and other internal flexfield processing logic, ultimately feeding the runtime view FND_FLEX_VALIDATION_RULES_VL.