Search Results pa_spread_curves_tl




Overview
Explore in AI Chat

Overview

The PA_SPREAD_CURVES_TL table is a core translation table within the Oracle E-Business Suite (EBS) Projects module. It functions as the language-specific repository for descriptive spread curve information. In Oracle EBS, spread curves are mathematical models used to define the pattern for distributing project revenue, cost, or budget amounts across multiple accounting periods. While the base table, PA_SPREAD_CURVES_B, stores the technical and non-translatable attributes of a curve, the PA_SPREAD_CURVES_TL table holds the translated names and descriptions for those curves, enabling support for multiple languages in a global deployment. Its role is critical for ensuring that spread curve selections and reports display correctly localized terminology to users worldwide in both EBS 12.1.1 and 12.2.2.

Key Information Stored

The table's primary purpose is to store translated textual data linked to a specific spread curve identifier and language. While the full column list is not detailed in the provided metadata, the structure of translation tables in Oracle EBS follows a consistent pattern. The key columns invariably include SPREAD_CURVE_ID, which links to the base table, and LANGUAGE, which holds the language code (e.g., 'US', 'FR'). The core translatable columns are typically NAME and DESCRIPTION, containing the user-facing label and explanatory text for the spread curve in the specified language. Additional standard columns include SOURCE_LANG, CREATION_DATE, and LAST_UPDATE_DATE. The primary key constraint, PA_SPREAD_CURVES_TL_PK, is defined on the combination of SPREAD_CURVE_ID and LANGUAGE, ensuring a single translation per curve per language.

Common Use Cases and Queries

This table is primarily accessed by the application's user interface and reporting engines to display curve names in the session language. A common operational query retrieves the translated name for a specific curve for reporting or data validation. For example, to fetch the English and French names for a set of curves, one might use:

  • SELECT b.spread_curve_id, tl_lang.name, tl_fr.name FROM pa_spread_curves_b b, pa_spread_curves_tl tl_lang, pa_spread_curves_tl tl_fr WHERE b.spread_curve_id = tl_lang.spread_curve_id AND tl_lang.language = userenv('LANG') AND b.spread_curve_id = tl_fr.spread_curve_id AND tl_fr.language = 'F';

Data migration or setup scripts also interact with this table when cloning spread curves or adding new language translations. Reporting on the availability of translations for audit purposes is another key use case, often checking for curves missing a translation in a required language.

Related Objects

PA_SPREAD_CURVES_TL has a direct and essential relationship with its base table, as documented in the provided metadata. The foreign key from PA_SPREAD_CURVES_TL.SPREAD_CURVE_ID references PA_SPREAD_CURVES_B. This is a one-to-many relationship where a single record in the base table can have multiple corresponding translation records in the TL table, one for each supported language. This table is also referenced by various project-related views and APIs that present spread curve information to other modules, such as Project Billing, Costing, and Planning. While not listed in the excerpt, it is typically joined to in application views like PA_SPREAD_CURVES_VL (the vertical view that combines base and translated data for reporting).