Search Results fnd_profile_cats_tl




Overview
Explore in AI Chat

Overview

The FND_PROFILE_CATS_TL table is a core Application Object Library table within the Oracle E-Business Suite (EBS) architecture. It serves as the translation table for the FND_PROFILE_CATS base table. Its primary role is to store translated, language-specific descriptions for profile option categories, enabling the EBS user interface to display these category names in the language selected by the end-user. This table is essential for supporting the multi-language capabilities (NLS) of the application, ensuring that administrators and users encounter localized terminology when navigating and managing system profile options.

Key Information Stored

The table stores translated text for profile category names. Its structure is defined by a composite primary key that uniquely identifies each translation record. The critical columns include:

  • NAME and APPLICATION_ID: Together, these columns form part of the primary key and foreign key back to the FND_PROFILE_CATS table. They identify the specific profile category requiring translation.
  • LANGUAGE: The third component of the primary key, this column holds the language code (e.g., 'US' for American English, 'D' for German) for which the translation is applicable.
  • DESCRIPTION: This column holds the actual translated text for the profile category name in the specified language.

Common Use Cases and Queries

This table is primarily accessed by the EBS framework to render translated content. Common technical use cases involve queries to audit or verify translations for implementation or upgrade projects. A typical query retrieves the base and translated descriptions for a specific profile category across multiple languages:

SELECT b.NAME, b.DESCRIPTION AS BASE_DESC, t.LANGUAGE, t.DESCRIPTION AS TRANSLATED_DESC
FROM APPLSYS.FND_PROFILE_CATS b, APPLSYS.FND_PROFILE_CATS_TL t
WHERE b.NAME = t.NAME
AND b.APPLICATION_ID = t.APPLICATION_ID
AND b.NAME = '&PROFILE_CATEGORY_NAME';

Another common pattern is identifying categories missing translations for a target language, which is crucial for localization testing and completeness.

Related Objects

The table has a direct and critical relationship with its base table, as documented in the provided metadata. The key dependencies are:

  • Primary Key: FND_PROFILE_CATS_TL_PK on columns (NAME, APPLICATION_ID, LANGUAGE).
  • Foreign Key Relationship: The table references the FND_PROFILE_CATS base table. The foreign key is defined on the columns FND_PROFILE_CATS_TL.NAME and FND_PROFILE_CATS_TL.APPLICATION_ID, which join to the corresponding columns in FND_PROFILE_CATS. This enforces referential integrity, ensuring every translation record corresponds to a valid base profile category.

Consequently, any operation on profile categories in FND_PROFILE_CATS that affects the NAME or APPLICATION_ID key values must consider the dependent rows in this translation table.