Search Results pa_res_formats_tl




Overview
Explore in AI Chat

Overview

The PA_RES_FORMATS_TL table is a core translation table within the Oracle E-Business Suite (EBS) Projects module (PA). It is designed to store translated versions of resource format names, enabling the application to display these user-facing labels in multiple languages. This table supports the global deployment of Oracle Projects by allowing planning resource formats, which define how resources are categorized and displayed in planning interfaces, to be presented in a user's preferred language. Its existence is critical for maintaining a multilingual user experience in resource planning and management functionalities across EBS releases 12.1.1 and 12.2.2.

Key Information Stored

The table stores language-specific translations for resource format names. Its structure is typical of an EBS translation table, containing both key and descriptive columns. The primary key is a composite of RES_FORMAT_ID and LANGUAGE. The RES_FORMAT_ID column is the foreign key linking each translation row to its base definition in the PA_RES_FORMATS_B table. The LANGUAGE column holds the language code (e.g., 'US', 'FR') for the translation and references the FND_LANGUAGES table. A critical column is SOURCE_LANG, which also references FND_LANGUAGES and indicates the original language in which the data was entered; this is used by the EBS translation mechanism to identify seed data. The table's core descriptive column is NAME, which holds the actual translated text for the resource format as seen by end-users.

Common Use Cases and Queries

This table is primarily accessed by the Oracle Applications framework to retrieve translated labels dynamically based on the user's session language. Common practical scenarios include generating multilingual reports on resource planning setups and supporting data migration or reconciliation scripts in multi-language environments. A typical query to retrieve all translations for a specific resource format would join to the base table and the languages table.

  • Sample SQL Pattern: SELECT b.RES_FORMAT_ID, tl.LANGUAGE, tl.NAME, tl.SOURCE_LANG FROM PA_RES_FORMATS_B b, PA_RES_FORMATS_TL tl WHERE b.RES_FORMAT_ID = tl.RES_FORMAT_ID AND b.RES_FORMAT_CODE = '<CODE>';
  • Reporting Use Case: Auditing translation completeness by listing all base resource formats and the languages for which a translation exists (or is missing).

Related Objects

The PA_RES_FORMATS_TL table has defined dependencies on several key EBS objects, as documented in its foreign key relationships. Its primary relationship is with the base table PA_RES_FORMATS_B, which holds the language-independent definition of a resource format. The table also has two separate foreign key relationships to the application foundation table FND_LANGUAGES to validate the language codes used for both the translation and the source language.

  • PA_RES_FORMATS_B: The base definition table. Joined via PA_RES_FORMATS_TL.RES_FORMAT_ID = PA_RES_FORMATS_B.RES_FORMAT_ID.
  • FND_LANGUAGES (for LANGUAGE column): Validates the translation language code. Joined via PA_RES_FORMATS_TL.LANGUAGE = FND_LANGUAGES.LANGUAGE_CODE.
  • FND_LANGUAGES (for SOURCE_LANG column): Validates the source language code. Joined via PA_RES_FORMATS_TL.SOURCE_LANG = FND_LANGUAGES.LANGUAGE_CODE.