Results for “fnd_flexbuilder_params_vl”

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

Overview

The FND_FLEXBUILDER_PARAMS_VL view is a translated (VL, or "view language") database object owned by the APPS schema in Oracle E-Business Suite 12.1.1 and 12.2.2. It belongs to the FND — Application Object Library product and exposes FlexBuilder parameter definitions together with their language-specific (translated) user-facing names. FlexBuilder is the framework used within Oracle EBS to define functions that invoke a key flexfield or descriptive flexfield in a specific context, and parameters drive which segments or values a function passes to and receives from the flexfield. This view therefore serves as the canonical read interface for reporting on and integrating with FlexBuilder parameter configuration across a multilingual EBS instance.

Because it is a VL view, it resolves the translation for the current session language via USERENV('LANG'), returning a single row per parameter per application function. This makes it suitable for both configuration reporting and programmatic lookups where the displayed parameter name must match the user's runtime language.

Underlying Base Objects

Per the documented ETRM metadata, the view is defined over two base objects:

• FND_FLEXBUILDER_PARAMETERS (referenced through a SYNONYM) — the primary base table holding the core parameter definition, including the flexfield identifiers, value set references, sequence, and conditional logic columns.
• FND_FLEXBUILDER_PARAMS_TL (referenced through a SYNONYM) — the translation table that stores the language-specific USER_PARAMETER_NAME.

The two objects are joined on the composite key of APPLICATION_ID, FUNCTION_CODE, SEQUENCE, and PARAMETER_NAME, with the translation side filtered to LANGUAGE = USERENV('LANG'). This join structure is the defining characteristic of the view and explains why it is versioned as a VL view rather than a simple base table synonym.

Key Columns

Among the columns exposed, several are directly relevant to FlexBuilder configuration and to the search term "conditional_parameter":

• APPLICATION_ID, FUNCTION_CODE, SEQUENCE, PARAMETER_NAME — the composite identity of a parameter within a function.
• USER_PARAMETER_NAME — the translated display name sourced from FND_FLEXBUILDER_PARAMS_TL.
• CONDITIONAL_PARAMETER and CONDITIONAL_VALUE — the columns that control whether a parameter is conditionally included, and the value that triggers inclusion.
• CONSTANT_VALUE — a fixed value passed by the parameter when applicable.
• ID_FLEX_CODE, ID_FLEX_NUM, FLEX_VALUE_SET_ID, ASSIGNMENT_VALUE_SET_ID, VALUE_SET_MATCH_REQUIRED_FLAG — flexfield and value-set binding details.
• PARAMETER_TYPE, ASSIGNMENT_TYPE, SEGMENT_ATTRIBUTE_TYPE, SOURCE_PARAMETER, OUTPUT_COLUMN, APPLICATION_COLUMN_NAME — determine how the parameter maps to segments and application columns.
• PROTECTED_FLAG, DESCRIPTION — metadata controlling editability and documentation.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN — standard audit columns.

Common Use Cases and Queries

Typical uses include auditing FlexBuilder parameter configuration, verifying conditional parameter logic, and building integrations that render flexfield prompts dynamically. The following query lists parameters and their conditional settings for a given function:

• SELECT parameter_name, user_parameter_name, conditional_parameter, conditional_value, constant_value FROM fnd_flexbuilder_params_vl WHERE function_code = :function_code ORDER BY sequence;

Because the view already performs language resolution, queries against it return names appropriate to the session language, making it preferable to joining the base tables directly for display purposes.