Search Results fnd_dm_products_tl

Overview

FND_DM_PRODUCTS_TL is a translation (TL) table owned by the APPLSYS schema within the Oracle E-Business Suite Application Object Library (FND) product. It stores the language-specific display names and descriptions for records held in the base FND_DM_PRODUCTS table, which represents the repository of products known to the Oracle EBS Data Model / object repository infrastructure. Because Oracle EBS supports a multilingual deployment model, human-readable attributes such as product names and descriptions are segregated into companion TL tables keyed by language, while language-independent attributes remain in the base (non-TL) table.

The table is documented in ETRM with a status of VALID and contains five physical columns. Its stated description is that it "holds the translated name of the repository," confirming its role as the localized text segment of the product repository entity. From a heuristic Data Vault modeling perspective, this object is classified as standalone, meaning it is neither a hub, link, nor satellite in a typical raw-data-vault derivation. Practically, it is best modeled as a dependent descriptive child — functionally a satellite-like table — that carries translated attributes (name, description) attached to the FND_DM_PRODUCTS hub by way of PRODUCT_ID.

Key Information Stored

The documented schema exposes five columns, of which the following are material for query and join purposes:

• PRODUCT_ID — The foreign key referencing FND_DM_PRODUCTS.PRODUCT_ID. This is the join key that links a translated row back to its base product entity and is part of the composite identity of any TL record.
• LANGUAGE — The language code identifying the locale for which the row's DISPLAY_NAME and PRODUCT_DESCRIPTION values are valid. This is part of the composite key that distinguishes one translation from another for the same product.
• SOURCE_LANG — The source language from which the translation was derived, typically the base or installation language (commonly US). This column supports the standard EBS translation-tracking convention and is used to identify the authoritative language record.
• DISPLAY_NAME — The translated, user-facing name of the product or repository entity.
• PRODUCT_DESCRIPTION — The translated descriptive text associated with the product or repository entity.

The surrogate/business identity of a row is the combination of PRODUCT_ID and LANGUAGE, which uniquely determines a single translation. No standalone unique index on a single column is documented; the natural key is composite. The metadata does not document any additional surrogate primary key beyond this composite relationship to the base table.

Common Use Cases and Queries

This table is most often queried in multilingual reporting and in translations of repository metadata, where the analyst must retrieve the localized product name for a given session or reporting language. A representative join follows:

• Retrieving localized product names: SELECT b.product_id, t.display_name, t.product_description FROM fnd_dm_products b, fnd_dm_products_tl t WHERE b.product_id = t.product_id AND t.language = 'US';
• Filtering by a specific locale to produce a language-specific report.
• Comparing a translated record against its SOURCE_LANG counterpart to audit translation completeness.
• Identifying which products have no translation for a required language by using an outer join from the base table.

Because the table is standalone with respect to downstream dependencies, queries typically drive from FND_DM_PRODUCTS and resolve LANGUAGE using the EBS session locale (for example, FND_GLOBAL.LANGUAGE or the LANG profile value).

Related Objects

• FND_DM_PRODUCTS — The base table holding language-independent product/repository attributes. Joined via FND_DM_PRODUCTS_TL.PRODUCT_ID = FND_DM_PRODUCTS.PRODUCT_ID. This is the only documented foreign-key relationship and is the primary dependency.
• FND_LANGUAGES — The reference table of installed and available languages, used to validate or resolve the LANGUAGE and SOURCE_LANG codes.
• FND_DM_PRODUCTS_VL — Where present in the EBS data dictionary, the translated view that typically unions the base and TL tables to present a language-resolved row per product.

These objects should be considered together when constructing multilingual queries against the FND data-model repository.