Search Results monetary_unit_id




Overview
Explore in AI Chat

Overview

The PAY_MONETARY_UNITS_TL table is a core translation table within the Oracle E-Business Suite Payroll (PAY) module, specifically for versions 12.1.1 and 12.2.2. It stores the multilingual descriptions for monetary units defined in the system. This table enables the global deployment of Oracle Payroll by allowing the user-facing names of currency denominations, such as "Dollar" or "Cent," to be displayed in the language of the user's session. It is a child table to a base table (typically PAY_MONETARY_UNITS_B) and is critical for maintaining a single source of definition for a monetary unit while supporting multiple language installations.

Key Information Stored

The table's primary purpose is to store translated textual descriptions. Its structure is defined by a composite primary key and a set of language-specific columns. The key columns are MONETARY_UNIT_ID, which links to the base definition, and LANGUAGE, which stores the language code (e.g., 'US', 'FR'). The most significant data column is typically MONETARY_UNIT_NAME, which holds the translated name for the monetary unit. Other standard Translation Table (TL) columns include SOURCE_LANG, which records the original language of the entry, and CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, and LAST_UPDATE_LOGIN for audit purposes.

Common Use Cases and Queries

This table is primarily accessed by the Oracle application's internal mechanisms to resolve translated labels for forms and reports. A common reporting use case is to generate a list of all monetary units with their descriptions in a specific language for reference or setup validation. A typical query would join this table to its base table to retrieve both the technical identifier and the user-friendly name.

  • Sample Query for Session Language:
    SELECT b.monetary_unit_id, tl.monetary_unit_name
    FROM pay_monetary_units_b b,
    pay_monetary_units_tl tl
    WHERE b.monetary_unit_id = tl.monetary_unit_id
    AND tl.language = USERENV('LANG');
  • Validation of Translations: Queries are often used to identify base entries missing translations for a target language or to audit translation completeness across installed languages.

Related Objects

As documented in the provided ETRM metadata, PAY_MONETARY_UNITS_TL has a defined primary key constraint (PAY_MONETARY_UNITS_TL_PK) on the columns (MONETARY_UNIT_ID, LANGUAGE). This structure indicates its fundamental relationship is as a child table to a base table keyed on MONETARY_UNIT_ID. The most direct parent is the PAY_MONETARY_UNITS_B table, which holds the non-translatable attributes for each monetary unit. The MONETARY_UNIT_ID column in the TL table is a foreign key to the MONETARY_UNIT_ID in the base table. This table is also referenced by various Payroll APIs and views that present monetary unit information in a multilingual context.