Search Results fnd_stage_fn_parameters_tl




Overview
Explore in AI Chat

Overview

The FND_STAGE_FN_PARAMETERS_TL table is a core translation table within the Application Object Library (FND) module of Oracle E-Business Suite (EBS) versions 12.1.1 and 12.2.2. As a translation (TL) table, its primary role is to store multilingual content for the parameter definitions used by staged functions within the system. It provides the language-specific labels and descriptions for parameters, enabling the EBS interface to display these elements in a user's chosen language. This table is essential for supporting the global deployment of Oracle EBS applications, ensuring that parameter metadata is presented correctly across different linguistic locales.

Key Information Stored

The table stores translated text for staged function parameters, keyed by a unique combination of identifiers and language. The primary columns, as defined by its documented primary keys, are APPLICATION_ID, FUNCTION_ID, PARAMETER_ID, and LANGUAGE. These columns link the translation record to its base data in the FND_STAGE_FN_PARAMETERS table and specify the language of the translation (e.g., US, D, JA). Another unique key also includes PARAMETER_NAME. Critical descriptive columns typically found in TL tables, such as PARAMETER_DISPLAY_NAME and DESCRIPTION, would hold the actual translated text. The table also includes standard EBS audit columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN) and a SOURCE_LANG column to track the original language of the translatable data.

Common Use Cases and Queries

This table is primarily accessed by the EBS framework to render multilingual user interfaces for function and parameter configuration. Common operational and reporting scenarios include auditing translation coverage and extracting parameter metadata for a specific language. A typical query would join this table to its base table to retrieve a complete, translated parameter definition.

  • Retrieve Translated Parameters for a Specific Function:
    SELECT tl.parameter_display_name, tl.description, b.*
    FROM fnd_stage_fn_parameters_tl tl,
    fnd_stage_fn_parameters b
    WHERE tl.application_id = b.application_id
    AND tl.function_id = b.function_id
    AND tl.parameter_id = b.parameter_id
    AND tl.language = USERENV('LANG')
    AND b.function_id = :your_function_id;
  • Identify Missing Translations:
    SELECT base.parameter_name, base.language "BASE_LANG", tl.language
    FROM fnd_stage_fn_parameters base
    LEFT JOIN fnd_stage_fn_parameters_tl tl
    ON base.application_id = tl.application_id
    AND base.function_id = tl.function_id
    AND base.parameter_id = tl.parameter_id
    AND tl.language = 'D'
    WHERE tl.parameter_id IS NULL;

Related Objects

FND_STAGE_FN_PARAMETERS_TL maintains defined foreign key relationships with several key Application Object Library tables, as documented in the provided metadata.

  • FND_STAGE_FN_PARAMETERS: The base table for which this table stores translations. Joined via APPLICATION_ID, FUNCTION_ID, and PARAMETER_ID.
  • FND_EXECUTABLES: Linked via APPLICATION_ID and FUNCTION_ID, indicating the staged function to which the parameter belongs.
  • FND_LANGUAGES: Referenced twice, validating entries in the LANGUAGE and SOURCE_LANG columns against installed languages.
  • FND_USER: Referenced by the CREATED_BY and LAST_UPDATED_BY audit columns to track the user who created or last modified the translation record.
  • FND_LOGINS: Referenced by the LAST_UPDATE_LOGIN audit column to track the session of the last update.