Results for “fnd_flexbuilder_params_tl”

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

Overview

FND_FLEXBUILDER_PARAMS_TL is the translation (language-specific) table for FND_FLEXBUILDER_PARAMETERS within the Oracle E-Business Suite Application Object Library (FND). It resides in the APPLSYS schema and stores the translated, user-facing and display-oriented attributes of FlexBuilder parameter definitions that are maintained in the base table. Every row is scoped to a specific LANGUAGE, so the table holds one record per language per parameter, allowing Oracle EBS to render parameter prompts and names in the session language of the user.

In Data Vault modeling terms, the metadata heuristically classifies this object as satellite-leaning. The base parameter definition (retained in FND_FLEXBUILDER_PARAMETERS) acts as the parent, while FND_FLEXBUILDER_PARAMS_TL carries the descriptive, language-dependent attributes that describe that parent. It is therefore best modeled as a satellite hanging off the parameter hub/definition, not as an independent hub.

Key Information Stored

The table comprises 12 documented columns. The most important are:

• APPLICATION_ID — Identifies the owning application of the FlexBuilder function, forming part of every composite key.
• FUNCTION_CODE — The FlexBuilder function to which the parameter belongs; another key component.
• PARAMETER_NAME — The internal, language-independent parameter identifier; part of the primary key and the foreign key back to the base table.
• SEQUENCE — Orders the parameter within its function; part of both keys.
• LANGUAGE — The language code for the translated row; completes both the primary key and the unique key.
• USER_PARAMETER_NAME — The translated, user-visible parameter name; this is the business-key candidate that distinguishes the UK1 index and is the column most often returned in translated parameter listings.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN — Standard EBS audit columns recording who created and last changed the row and when.
• SOURCE_LANG — The language in which the base (source) row was originally authored, used by the translation framework to manage the translation set.

The surrogate primary key is FND_FLEXBUILDER_PARAMS_TL_PK over (APPLICATION_ID, FUNCTION_CODE, PARAMETER_NAME, SEQUENCE, LANGUAGE). The unique index FND_FLEXBUILDER_PARAMS_TL_U1 covers the same columns, and the additional unique index FND_FLEXBUILDER_PARAMS_TL_UK1 includes USER_PARAMETER_NAME, making it the documented business-key candidate.

Common Use Cases and Queries

Typical use cases center on FlexBuilder function configuration and language-specific rendering of parameters. A common query joins the translation table to its base table to display prompt text:

• Retrieving translated parameter names for a function: SELECT p.function_code, p.parameter_name, t.user_parameter_name FROM fnd_flexbuilder_parameters p, fnd_flexbuilder_params_tl t WHERE p.application_id = t.application_id AND p.function_code = t.function_code AND p.parameter_name = t.parameter_name AND p.sequence = t.sequence AND t.language = USERENV('LANG');
• Auditing translations that are missing or stale by comparing SOURCE_LANG against the available LANGUAGE rows.
• Reporting on parameter definitions by application and function for documentation or migration projects.
• Diagnosing why a FlexBuilder parameter prompt appears in the wrong language in a specific responsibility.

Related Objects

The following objects are most significant in relation to this table:

• FND_FLEXBUILDER_PARAMETERS — The parent (base) table; joined on APPLICATION_ID, FUNCTION_CODE, PARAMETER_NAME, and SEQUENCE. This is the direct foreign-key relationship documented for the object.
• FND_FLEXBUILDER_FUNCTIONS — Provides the function metadata to which parameters belong via FUNCTION_CODE.
• FND_APPLICATION — Supplies application names for APPLICATION_ID in reporting queries.
• FND_LANGUAGES — Resolves LANGUAGE codes to installed and active languages.
• FND_FLEXBUILDER_PARAMS_TL translation views and FND FlexBuilder configuration APIs — used by the FlexBuilder setup interface and AD translation utilities.

Because the table is translated content rather than transactional data, it is primarily read during setup, configuration display, and localization reporting rather than during routine transaction processing.