Results for “pa_cost_plus_structures”

50+ results




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

Overview

PA_COST_PLUS_STRUCTURES is a Projects (PA) module table in Oracle EBS 12.1.1 and 12.2.2 that defines the cost-plus structures used for burdening. In Oracle Projects, a cost-plus structure establishes the framework under which burden costs are applied to raw expenditure items. It groups the cost bases (cost codes and expenditure types) and links them with indirect rate schedules and revisions to determine how burden is calculated and applied across an organization's projects. The table serves as the master definition of each structure, its type, and the range of dates during which it is active.

The primary key is documented as PA_COST_PLUS_STRUCTURES_PK on the COST_PLUS_STRUCTURE column, and a unique index PA_COST_PLUS_STRUCTURES_U1 exists on the same column, indicating COST_PLUS_STRUCTURE is the business-key candidate. The metadata describes this object as hub-leaning in a heuristic Data Vault classification. From a modeling perspective, this suggests treating the table as a hub entity, with dependent tables such as PA_COST_BASE_COST_CODES, PA_COST_BASE_EXP_TYPES, and the rate schedule tables acting as satellites or links that reference the hub via foreign keys.

Key Information Stored

The table contains twelve documented columns. The most significant include:

  • COST_PLUS_STRUCTURE — Surrogate primary key and business-key candidate; uniquely identifies each burdening structure.
  • DESCRIPTION — Descriptive name or text for the structure, used in reporting and user interface selection.
  • COST_PLUS_STRUCTURE_TYPE — Indicates the classification or type of the cost-plus structure, which affects how burdening rules are applied.
  • START_DATE_ACTIVE and END_DATE_ACTIVE — Define the effective date range during which the structure is valid and can be used in cost processing.
  • ALLOWED_FOR_OVERRIDE_SCH_FLAG — Flag indicating whether the associated burden schedule may be overridden, providing flexibility at the project or task level.
  • DEFAULT_FOR_OVERRIDE_SCH_FLAG — Flag indicating whether the structure serves as the default for override schedules.
  • LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATED_BY, CREATION_DATE, LAST_UPDATE_LOGIN — Standard EBS audit columns tracking record creation and modification.

The surrogate primary key is COST_PLUS_STRUCTURE, while the unique index confirms it is also the business-key candidate. The audit columns follow Oracle EBS conventions for multi-user access and audit trail maintenance.

Common Use Cases and Queries

Typical usage involves querying active structures and joining them to base cost codes, expenditure types, and rate schedules. A sample query to retrieve active structures:

SELECT cost_plus_structure, description, cost_plus_structure_type FROM pa.pa_cost_plus_structures WHERE TRUNC(SYSDATE) BETWEEN start_date_active AND NVL(end_date_active, TRUNC(SYSDATE)) ORDER BY cost_plus_structure;

Another common pattern joins the structure to its base components to report on burdening configuration:

SELECT cps.cost_plus_structure, cps.description, cbc.cost_code FROM pa.pa_cost_plus_structures cps, pa.pa_cost_base_cost_codes cbc WHERE cps.cost_plus_structure = cbc.cost_plus_structure;

Reporting scenarios include auditing which structures permit schedule overrides, identifying structures without an end date, and analyzing burden calculation setups for a specific operating unit or project. These queries support configuration review, cost validation, and troubleshooting of unexpected burden amounts.

Related Objects

The table is referenced by several dependent objects through foreign keys on the COST_PLUS_STRUCTURE column:

  • PA_COST_BASE_COST_CODES — Stores cost codes that comprise the cost base, joined via COST_PLUS_STRUCTURE.
  • PA_COST_BASE_EXP_TYPES — Stores expenditure types included in the cost base, joined via COST_PLUS_STRUCTURE.
  • PA_IND_RATE_SCHEDULES_ALL_BG — Holds indirect rate schedules associated with the structure, joined via COST_PLUS_STRUCTURE.
  • PA_IND_RATE_SCH_REVISIONS — Stores revisions to indirect rate schedules, joined via COST_PLUS_STRUCTURE.

Together these relationships define the full burdening configuration, with PA_COST_PLUS_STRUCTURES acting as the central hub referenced by cost bases and rate schedule components.