Results for “pa_spread_curves_b”

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

Overview

PA_SPREAD_CURVES_B is a Projects (PA) module table that stores spread curve information used to distribute planning amounts and resource assignment quantities across time periods. Spread curves are the mechanism by which Oracle Projects applies a time-phased distribution pattern to budget, forecast, or resource assignment values, allowing a single planned total to be allocated over a date range rather than loaded evenly. The table resides in the PA schema and is classified as a base (B) table, indicating that its translatable descriptive attributes are held separately in a companion translation table, PA_SPREAD_CURVES_TL, in the standard Oracle E-Business Suite multilanguage (MLS) pattern.

The documented ETRM metadata classifies PA_SPREAD_CURVES_B as hub-leaning under a heuristic Data Vault model. In practical terms, this is a modeling suggestion rather than a physical constraint: SPREAD_CURVE_ID functions as a durable business key around which dependent records cluster, with descriptive and effective-dating attributes carried as satellite-style detail. The table is validated in Oracle EBS 12.1.1 and 12.2.2, and it appears in the documented 12.2.2 physical schema with 22 columns.

Key Information Stored

The surrogate primary key is SPREAD_CURVE_ID, enforced through the PA_SPREAD_CURVES_B_PK constraint. A documented unique index, PA_SPREAD_CURVES_B_U1, is defined on the combination of SPREAD_CURVE_ID and ZD_EDITION_NAME, which reflects Oracle's edition-based redefinition support in 12.2.x and serves as the business-key candidate for the row set.

The most significant columns are:

• SPREAD_CURVE_ID — surrogate primary key and the foreign key target for all dependent tables.
• SPREAD_CURVE_CODE — user-facing business identifier for the curve.
• EFFECTIVE_START_DATE / EFFECTIVE_END_DATE — date-range validity window governing when the curve definition applies.
• ROUNDING_FACTOR_CODE — controls how distributed amounts are rounded during spreading.
• POINT1 through POINT10 — the ten distribution points that define the shape of the curve and the percentage or weight applied to each period.
• RECORD_VERSION_NUMBER — optimistic locking / record versioning attribute.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN — standard Oracle who-columns used for auditing and change tracking.
• ZD_EDITION_NAME — edition identifier supporting edition-based redefinition.

Common Use Cases and Queries

Spread curves are referenced whenever planned costs or resource quantities must be distributed across accounting periods. A typical reporting query resolves a curve definition and its translated name for a given effective date:

• Resolve the curve for an assignment: join PA_RESOURCE_ASSIGNMENTS to PA_SPREAD_CURVES_B on SPREAD_CURVE_ID to return SPREAD_CURVE_CODE, ROUNDING_FACTOR_CODE, and the POINT1–POINT10 weights.
• Reporting distribution shape: select SPREAD_CURVE_CODE and POINT1 through POINT10 to analyze how planned amounts are phased.
• Effective-dating validation: filter on EFFECTIVE_START_DATE and EFFECTIVE_END_DATE to return only curves active for a project or budget period.
• Translation lookups: join PA_SPREAD_CURVES_TL on SPREAD_CURVE_ID to retrieve the language-specific curve name.
• Duplicate detection via the unique index columns SPREAD_CURVE_ID and ZD_EDITION_NAME is useful in 12.2.x multi-edition environments.

Related Objects

PA_SPREAD_CURVES_B is a referenced parent in the documented foreign key graph. The significant dependent objects are:

• PA_SPREAD_CURVES_TL — translation table, joined on SPREAD_CURVE_ID, holding language-specific descriptive text.
• PA_RESOURCE_ASSIGNMENTS — references the curve through SPREAD_CURVE_ID to determine how planned resource quantities are distributed over time.
• PA_PLAN_RES_DEFAULTS — references the curve through SPREAD_CURVE_ID to supply default spreading behavior for planning resources.
• PA_SPREAD_CURVES_B_PK — the primary key constraint that anchors all of the above relationships.
• PA_SPREAD_CURVES_B_U1 — the unique index supporting business-key and edition-based lookups.

Together these objects form the spreading framework that links curve definitions to planning and resource assignment records throughout Oracle Projects.