Search Results fnd_flexbuilder_params_tl




Overview
Explore in AI Chat

Overview

The FND_FLEXBUILDER_PARAMS_TL table is a core translation table within the Application Object Library (FND) of Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2. Its primary role is to store translated, user-facing text for the parameters used by the Flexbuilder framework. This framework is responsible for constructing and managing key flexfields and descriptive flexfields within the application. The table enables the EBS system to present parameter names and descriptions in the language of the end-user, supporting the application's global, multi-language capabilities. It is a child table that depends directly on the base table FND_FLEXBUILDER_PARAMETERS.

Key Information Stored

The table stores translated text for flexfield builder parameters, keyed by a composite primary key that ensures uniqueness per language. The most critical columns, as defined by its primary and unique keys, are APPLICATION_ID, FUNCTION_CODE, PARAMETER_NAME, SEQUENCE, and LANGUAGE. The FUNCTION_CODE column, which the user specifically searched for, is a vital identifier that links a parameter to a specific flexfield function or builder process. The USER_PARAMETER_NAME column holds the actual translated text of the parameter name as it should be displayed to the user in the specified LANGUAGE. Other typical columns in a translation table, such as DESCRIPTION, SOURCE_LANG, and LAST_UPDATE_DATE, are also present to manage the translation lifecycle.

Common Use Cases and Queries

A primary use case is generating user interfaces or reports for flexfield setup in a specific language. Developers and functional implementers may query this table to verify or audit translations for flexfield parameters. A common query pattern involves joining to the base parameters table to see both the seed data and its translations. For example, to find all translated parameter names for a specific flexfield function, one might use:

  • SELECT tl.language, tl.user_parameter_name, b.parameter_name
  • FROM fnd_flexbuilder_parameters b, fnd_flexbuilder_params_tl tl
  • WHERE b.application_id = tl.application_id
  • AND b.function_code = tl.function_code
  • AND b.parameter_name = tl.parameter_name
  • AND b.sequence = tl.sequence
  • AND b.function_code = '<specific_function_code>';

This is essential for troubleshooting display issues in non-English installations or for validating customizations that affect flexfield behavior.

Related Objects

The table has a direct and fundamental relationship with the FND_FLEXBUILDER_PARAMETERS table, as enforced by a foreign key constraint. The foreign key links on the columns APPLICATION_ID, FUNCTION_CODE, PARAMETER_NAME, and SEQUENCE, making FND_FLEXBUILDER_PARAMS_TL a true translation child table. The flexfield builder parameters themselves are utilized by various FND APIs and forms that manage flexfield definitions. While not directly referenced by common application views, the data in this table is surfaced through the standard flexfield administration forms and OA Framework pages when a user switches the application language, ensuring a localized user experience.