Search Results pa_amount_types_tl




Overview
Explore in AI Chat

Overview

PA_AMOUNT_TYPES_TL is the translation table for amount types within the Oracle Projects (PA) module of Oracle E-Business Suite. Amount types define the categorization of monetary values used throughout Oracle Projects for costing, budgeting, revenue accrual, and reporting purposes. This table provides multi-lingual support for amount type names, allowing the same underlying amount type definition to be displayed in multiple languages based on the user's session language setting. In Oracle EBS 12.1.1 and 12.2.2, translation tables follow the standard _TL naming convention, storing language-specific descriptive attributes while the base definition resides in the corresponding _B (base) table.

From a data modeling perspective, the ETRM metadata classifies this object heuristically as standalone within a Data Vault framework. This suggests it is best modeled as a satellite table attached to the PA_AMOUNT_TYPES_B hub, capturing the descriptive, language-dependent attributes of each amount type. The absence of foreign keys beyond the reference to PA_AMOUNT_TYPES_B reinforces its role as a dependent descriptive structure rather than an independent transactional entity.

Key Information Stored

The table contains 10 documented columns. The most significant are:

  • AMOUNT_TYPE_ID — The surrogate foreign key linking each translation row back to the base definition in PA_AMOUNT_TYPES_B. This column forms part of the composite unique key and is the primary join vehicle.
  • LANGUAGE — The NLS language code (e.g., "US" for American English) identifying which language the translated name applies to. This is the second component of the composite unique index PA_AMOUNT_TYPES_TL_U1.
  • AMOUNT_TYPE_NAME — The translated, user-facing name of the amount type displayed in forms, reports, and list of values within the corresponding language session.
  • SOURCE_LANG — Indicates the source language from which the translation was derived, supporting Oracle's translation management conventions.
  • ZD_EDITION_NAME — The edition identifier supporting Oracle EBS 12.2's edition-based redefinition (EBR) architecture. This is the third component of the unique index and is critical for online patching support.
  • LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN — Standard WHO (Who Columns) audit fields tracking the creation and modification history of each translation row.

The business-key candidate is the composite unique index PA_AMOUNT_TYPES_TL_U1 spanning (AMOUNT_TYPE_ID, LANGUAGE, ZD_EDITION_NAME). A proper join to the base table must always include AMOUNT_TYPE_ID and, on 12.2.x, ZD_EDITION_NAME to ensure edition-consistent results.

Common Use Cases and Queries

The most common reporting requirement is retrieving a translated amount type name for a given language. A typical query joins the translation to the base table:

SELECT b.amount_type_id, t.amount_type_name
FROM pa_amount_types_b b, pa_amount_types_tl t
WHERE b.amount_type_id = t.amount_type_id
AND t.language = USERENV('LANG')
AND b.zd_edition_name = t.zd_edition_name;

Developers writing custom Oracle Projects extensions frequently must resolve amount type IDs to display names in concurrent programs, OAF pages, and BI Publisher reports. Multi-language deployments use this table to render amount type labels appropriate to each operating unit's locale. Data migration and interface scripts inserting new amount types must populate both the base and translation tables consistently, respecting the SOURCE_LANG convention.

Related Objects

  • PA_AMOUNT_TYPES_B — The base table holding the primary amount type definition; joined via AMOUNT_TYPE_ID.
  • PA_AMOUNT_TYPES_VL — The standard Oracle EBS view that outer-joins base and translation rows, presenting a language-resolved virtual table for forms and reports.
  • PA_AMOUNT_TYPE_LINES — Transactional or setup lines referencing amount types for project cost and budget processing.
  • PA_EXPENDITURE_ITEMS_ALL / PA_COST_DISTRIBUTION_LINES_ALL — Transaction tables consuming amount types for categorization of project expenditures.
  • PA_BUDGET_LINES / PA_REVENUE_ITEMS — Budgeting and revenue objects that reference amount type definitions during processing and reporting.

This table is read-only from an application perspective and should only be modified through Oracle Projects setup forms or sanctioned DML during upgrades and translations.