Results for “fnd_flexbuilder_parameters”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

FND_FLEXBUILDER_PARAMETERS is a configuration table in the APPLSYS schema of Oracle E-Business Suite, owned by the FND (Application Object Library) product. It stores the parameter definitions used by Oracle Flexbuilder, the metadata framework that drives the Flexfield-related validation logic behind key and descriptive flexfield segments across EBS 12.1.1 and 12.2.2. Each row describes a single parameter that a Flexbuilder function accepts, along with the source of its value (constant, flexfield segment, value set, or application column), its assignment behavior, and its relationship to a specific flexfield structure.

Under a heuristic Data Vault classification, this table leans toward a satellite. Its composite unique key of APPLICATION_ID, FUNCTION_CODE, PARAMETER_NAME, and SEQUENCE identifies the parent business key (the Flexbuilder function), while the remaining descriptive attributes — parameter type, assignment type, value set references, and conditional logic — are the descriptive payload. Modeling it as a satellite keyed to FND_FLEXBUILDER_FUNCTIONS is a reasonable suggestion, though the multiple foreign keys into FND_ID_FLEX_SEGMENTS and FND_FLEX_VALUE_SETS also give it link-like characteristics.

Key Information Stored

The primary key is FND_FLEXBUILDER_PARAMETERS_PK on (APPLICATION_ID, FUNCTION_CODE, PARAMETER_NAME, SEQUENCE), which also serves as the business-key candidate via unique index FND_FLEXBUILDER_PARAMETERS_U1. The 27 documented columns include the most operationally significant attributes:

• APPLICATION_ID, FUNCTION_CODE, SEQUENCE, PARAMETER_NAME — the composite key identifying which Flexbuilder function the parameter belongs to and its ordering.
• ASSIGNMENT_TYPE — categorizes how the parameter value is assigned (e.g., constant, flexfield, value set).
• PARAMETER_TYPE — the data type or role of the parameter.
• CONDITIONAL_PARAMETER and CONDITIONAL_VALUE — define conditional assignment logic governing when the parameter applies.
• CONSTANT_VALUE — a literal value for constant-type parameters.
• FLEXFIELD_APPLICATION_ID, ID_FLEX_CODE, ID_FLEX_NUM, SEGMENT_ATTRIBUTE_TYPE — link the parameter to a specific flexfield segment and attribute type.
• FLEX_VALUE_SET_ID and ASSIGNMENT_VALUE_SET_ID — reference the validation value sets used.
• APPLICATION_COLUMN_NAME, OUTPUT_COLUMN, SOURCE_PARAMETER, ID_PARAMETER — map parameters to table columns for input and output.
• VALUE_SET_MATCH_REQUIRED_FLAG and PROTECTED_FLAG — control validation and editability.
• DESCRIPTION, LAST_UPDATE_DATE, CREATED_BY, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATION_DATE — descriptive and audit columns.

Common Use Cases and Queries

Typical uses include diagnosing why a flexfield segment validation fails, auditing which value sets back a particular function, and tracing how parameters map to application columns during Flexbuilder processing. A representative query joining to the function parent:

• SELECT p.PARAMETER_NAME, p.PARAMETER_TYPE, p.ASSIGNMENT_TYPE, p.CONSTANT_VALUE, p.FLEX_VALUE_SET_ID FROM FND_FLEXBUILDER_PARAMETERS p WHERE p.APPLICATION_ID = :app_id AND p.FUNCTION_CODE = :func_code ORDER BY p.SEQUENCE;
• Join to FND_FLEXBUILDER_PARAMS_TL on (APPLICATION_ID, FUNCTION_CODE, PARAMETER_NAME, SEQUENCE) to retrieve translated parameter descriptions.
• Join FLEX_VALUE_SET_ID to FND_FLEX_VALUE_SETS to resolve the value set name backing a parameter, useful in validation audits and migration analysis.
• Filter on CONDITIONAL_PARAMETER and CONDITIONAL_VALUE to enumerate conditional parameter logic for documentation or regression testing.

Related Objects

The most significant related objects, based on documented foreign key relationships, are:

• FND_FLEXBUILDER_FUNCTIONS — parent via (APPLICATION_ID, FUNCTION_CODE); defines the function each parameter serves.
• FND_FLEX_VALUE_SETS — referenced twice via FLEX_VALUE_SET_ID and ASSIGNMENT_VALUE_SET_ID.
• FND_ID_FLEX_SEGMENTS — referenced via (FLEXFIELD_APPLICATION_ID, ID_FLEX_CODE, ID_FLEX_NUM, APPLICATION_COLUMN_NAME).
• FND_SEGMENT_ATTRIBUTE_TYPES — referenced via (FLEXFIELD_APPLICATION_ID, ID_FLEX_CODE, SEGMENT_ATTRIBUTE_TYPE).
• FND_FLEXBUILDER_ASSIGNMENTS — child table referencing this table through APPLICATION_ID, FUNCTION_CODE, and the SEGMENT_PARAMETER, CONDITIONAL_PARAMETER, and ID_PARAMETER columns.
• FND_FLEXBUILDER_PARAMS_TL — translation table referencing this table on the full composite key.