Search Results pa_ind_cost_multipliers




Overview
Explore in AI Chat

Overview

The PA_IND_COST_MULTIPLIERS table is a core data structure within the Oracle E-Business Suite Projects (PA) module, specifically for versions 12.1.1 and 12.2.2. It serves as the master repository for storing burden multipliers, which are essential for calculating indirect costs (overhead) on projects. The table's primary role is to define the specific multiplier rates applied to raw labor or expense costs, based on a combination of a burden schedule revision, an organization, and a burden cost code. This granular association enables precise and flexible burden cost calculations across different organizational structures and cost types, forming the foundation of the project costing engine.

Key Information Stored

The table's structure is defined by its composite primary key, which uniquely identifies a single multiplier record. The key columns are IND_RATE_SCH_REVISION_ID, which links to a specific version of a burden schedule; ORGANIZATION_ID, which identifies the HR organization unit; and IND_COST_CODE, which specifies the type of indirect cost. Beyond these key columns, the table typically stores the multiplier value itself (often in a column such as MULTIPLIER or RATE), along with standard Oracle EBS audit columns like CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, and LAST_UPDATED_BY. The integrity of the data is enforced through foreign key relationships to parent tables for each component of the primary key.

Common Use Cases and Queries

The primary use case is the automated calculation of burden costs during transaction processing (e.g., labor cost distribution, expense reports) and project planning. Reporting on burden rates for audit or analysis is another critical application. A common query pattern involves joining this table to its parent tables to retrieve a human-readable burden schedule. For example:

  • To list all multipliers for a specific burden schedule revision: SELECT organization_id, ind_cost_code, multiplier FROM pa_ind_cost_multipliers WHERE ind_rate_sch_revision_id = :p_rev_id;
  • To report on the full burden schedule with descriptions: SELECT rs.revision_name, hou.name org_name, cc.ind_cost_code, icm.multiplier FROM pa_ind_cost_multipliers icm JOIN pa_ind_rate_sch_revisions rs ON icm.ind_rate_sch_revision_id = rs.ind_rate_sch_revision_id JOIN hr_organization_units hou ON icm.organization_id = hou.organization_id JOIN pa_ind_cost_codes cc ON icm.ind_cost_code = cc.ind_cost_code;

Related Objects

As documented in the ETRM metadata, PA_IND_COST_MULTIPLIERS has defined foreign key relationships with three primary tables, forming the core of the burden costing model:

  • PA_IND_RATE_SCH_REVISIONS: Joined via IND_RATE_SCH_REVISION_ID. This table defines the different versions or revisions of a burden schedule.
  • HR_ALL_ORGANIZATION_UNITS: Joined via ORGANIZATION_ID. This HR table provides the organizational context for the multiplier.
  • PA_IND_COST_CODES: Joined via IND_COST_CODE. This table defines the valid burden cost code types (e.g., Overhead, G&A).

This table is also referenced by various project costing APIs and is a critical source for views that present burden schedule data to the application's user interface.