Search Results fm_form_mst_tl_pk




Overview
Explore in AI Chat

Overview

The FM_FORM_MST_TL table is a translation table within the Oracle E-Business Suite (EBS) Process Manufacturing (GMD) module. Specifically, it belongs to the Product Development sub-module. Its primary role is to store translated, language-specific versions of descriptive attributes for formula headers. This table enables the multi-language support (MLS) capability of Oracle EBS, allowing formula descriptions and other translatable text to be maintained in multiple languages. It operates in conjunction with its base table, FM_FORM_MST_B, which holds the language-independent data. The existence of this "_TL" table is a standard Oracle Applications pattern for implementing translatable entities.

Key Information Stored

The table stores translated text for formula header fields that require localization. Based on its structure as a translation table and standard EBS conventions, the key columns typically include:

  • FORMULA_ID: The primary foreign key that links each translated record to its corresponding master record in the FM_FORM_MST_B table. This is part of the table's primary key.
  • LANGUAGE: The language code (e.g., 'US' for American English) for the translation. This, combined with FORMULA_ID, forms the primary key (FM_FORM_MST_TL_PK).
  • SOURCE_LANG: A column indicating the original language in which the data was entered.
  • FORMULA_DESC: The most critical translatable field, holding the descriptive name of the formula in the specified language.
  • Other potential columns include translated text for fields like comments or notes associated with the formula header.

Common Use Cases and Queries

The primary use case is retrieving formula information in a user's session language for forms, reports, and interfaces. A common reporting query joins this table with its base table and filters by the current session language using the USERENV('LANG') function or the FND_GLOBAL.APPS_INITIALIZE context. For example, to list active formulas with their descriptions in the current language:

SELECT b.FORMULA_NO, tl.FORMULA_DESC, b.FORMULA_VERS
FROM GMD.FM_FORM_MST_B b,
GMD.FM_FORM_MST_TL tl
WHERE b.FORMULA_ID = tl.FORMULA_ID
AND tl.LANGUAGE = USERENV('LANG')
AND b.DELETE_MARK = 0;

Another critical scenario is during data migration or interface development, where translated descriptions must be populated or extracted for specific languages. Administrators may also query this table to audit or clean up translation coverage for a set of formulas.

Related Objects

FM_FORM_MST_TL has a direct and essential relationship with its base table, as defined by its primary key constraint.

  • FM_FORM_MST_B: This is the base table for formula headers. The relationship is a foreign key from FM_FORM_MST_TL.FORMULA_ID to FM_FORM_MST_B.FORMULA_ID. All translations are child records of a parent entry in this table.
  • FM_FORM_MST_VL: A view that automatically joins FM_FORM_MST_B and FM_FORM_MST_TL to present a complete, language-sensitive record. This is the view most commonly used in applications and reports.
  • Other formula-related tables (e.g., FM_FORMULA_ITEMS, FM_ROUTING_DTL) will typically join to FM_FORM_MST_B or its view, not directly to the TL table.