Results for “spread_curve_id”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

PA_SPREAD_CURVES_TL is the translation (TL) table for spread curves in the Oracle EBS Projects (PA) module. A spread curve defines how a monetary or effort amount is distributed across accounting periods — the curve's shape dictates the percentage applied in each period relative to a project's start, end, or baseline dates. This table stores the language-specific, translatable attributes of those curves: their display NAME and DESCRIPTION in each installed language, keyed by the language-independent SPREAD_CURVE_ID.

Oracle EBS follows a standard "_B / _TL" pattern. The base table PA_SPREAD_CURVES_B holds non-translatable, operational attributes (such as curve type and distribution method), while PA_SPREAD_CURVES_TL holds only the descriptive text that varies by language. Rows in the TL table are therefore created for every language into which a spread curve is translated, and they are read through a language view that resolves the session's LANG context.

Applying Data Vault modeling heuristics to the documented foreign-key structure, this table is classified as satellite-leaning. It is dependent on PA_SPREAD_CURVES_B via SPREAD_CURVE_ID, carries descriptive and audit attributes rather than defining new relationships, and is functionally subordinate to its parent base entity. The heuristic is a modeling suggestion only; the table is a conventional translated entity in the EBS data model.

Key Information Stored

The documented physical schema contains 11 columns in the PA schema. The most significant are:

• SPREAD_CURVE_ID — Surrogate primary key column and the sole component of the PA_SPREAD_CURVES_TL_PK constraint. It is also the foreign key to PA_SPREAD_CURVES_B.SPREAD_CURVE_ID, linking each translated row to its base record.
• NAME — The user-visible, translatable name of the spread curve as displayed in forms, lists of values, and reports.
• DESCRIPTION — The translatable free-text description explaining the curve's purpose or distribution logic.
• LANGUAGE — The language code of the row; combined with SPREAD_CURVE_ID, it identifies which translation is being read. It is a component of the unique index below.
• SOURCE_LANG — The language in which the record was originally entered, used by the translation framework to detect untranslated or source-language rows.
• ZD_EDITION_NAME — The edition identifier supporting Oracle's Edition-Based Redefinition (EBR) and Online Patching, introduced in EBS 12.2.
• Audit columns — LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATION_DATE, and CREATED_BY, which drive concurrency control and audit trails.

The business-key candidates are captured by the unique index PA_SPREAD_CURVES_TL_U1 on (SPREAD_CURVE_ID, LANGUAGE, ZD_EDITION_NAME). Whereas the primary key enforces only surrogate uniqueness, this index enforces the true natural key: one row per spread curve per language within an edition — the combination that the translation framework depends upon.

Common Use Cases and Queries

Queries against this table typically join to the base table and filter by the session language. A representative pattern retrieves the name and description for a given curve:

• Translation validation: identify base curves missing a row in a target language by comparing counts between PA_SPREAD_CURVES_B and PA_SPREAD_CURVES_TL for the same LANGUAGE.
• Reporting and LOVs: supply localized NAME values for spread-curve selection lists on project setup and budget forms.
• Audit and migration: use LAST_UPDATE_DATE, LAST_UPDATED_BY, and ZD_EDITION_NAME to trace when a translation was entered and under which edition.
• Backlog detection: find rows where SOURCE_LANG equals LANGUAGE, indicating text that has not yet been translated.

A typical join selects base curve attributes alongside translated text where the TL row matches the desired language and current edition.

Related Objects

• PA_SPREAD_CURVES_B — Parent base table; join on SPREAD_CURVE_ID. Holds the language-independent curve definition.
• PA_SPREAD_CURVES_VL / _V — Translation views that resolve LANGUAGE and expose localized name and description to forms and reports.
• PA_SPREAD_CURVE_LINES — Period-by-period curve definitions that reference the parent curve via SPREAD_CURVE_ID.
• PA_SPREAD_CURVE_TERMS — Curve term (segment) definitions associated with the same parent curve identifier.
• PA_PROJECTS / PA_BUDGET_VERSIONS — Project and budget entities that consume spread curves when distributing amounts over time.
• ZX / FND translation infrastructure — Language and edition context used by the EBR columns.

Collectively these objects support defining, translating, and applying spread curves within project budgeting and cost distribution in Oracle EBS 12.1.1 and 12.2.2.