Results for “ready_to_compile_flag”

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

Overview

PA_IND_COST_MULTIPLIERS is a transactional configuration table in the Oracle Projects (PA) schema that stores the burden multipliers applied to an indirect burden schedule revision. Each row defines the multiplicative rate that Oracle EBS applies to a specific burden cost code within a given organization for a given burden schedule revision. Because multipliers directly drive the calculation of burdened cost on expenditures, this table is central to indirect cost allocation, project costing, and burdened revenue determination.

From a modeling perspective, the heuristic Data Vault classification mined from the foreign key structure is link. PA_IND_COST_MULTIPLIERS resolves the many-to-many relationship between schedule revisions, organizations, and indirect cost codes, and it carries descriptive and state-bearing attributes such as the multiplier value and the ready-to-compile flag. This suggests the table functions as a relationship (link) entity rather than a pure hub or satellite.

Key Information Stored

The table is owned by the PA schema and contains ten documented columns in ETRM 12.2.2. The most significant columns are:

• IND_RATE_SCH_REVISION_ID — Identifier of the burden schedule revision to which the multiplier belongs; part of the primary key and a foreign key to PA_IND_RATE_SCH_REVISIONS.
• ORGANIZATION_ID — The organization (business unit or expenditure organization) against which the multiplier is defined; part of the primary key and a foreign key to HR_ALL_ORGANIZATION_UNITS.
• IND_COST_CODE — The indirect cost code that the multiplier applies to; part of the primary key and a foreign key to PA_IND_COST_CODES.
• MULTIPLIER — The numeric burden multiplier applied to the cost code for the organization and revision combination. This is the core business value of the row.
• READY_TO_COMPILE_FLAG — Status indicator used by the burden compilation program to determine whether the multiplier is available to be compiled into the burden schedule.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATED_BY, CREATION_DATE, LAST_UPDATE_LOGIN — Standard Oracle EBS WHO columns capturing audit and user context for the record.

The primary key is PA_IND_COST_MULTIPLIERS_PK, defined over (IND_RATE_SCH_REVISION_ID, ORGANIZATION_ID, IND_COST_CODE). A unique index, PA_IND_COST_MULTIPLIERS_U1, covers the same three columns, confirming them as the business-key candidate.

Common Use Cases and Queries

Typical scenarios include auditing multiplier values for a specific revision, verifying organization-level coverage, and reconciling compiled burden amounts against source multipliers.

• Retrieve all multipliers for a revision:

  SELECT m.organization_id, m.ind_cost_code, m.multiplier, m.ready_to_compile_flag
  FROM   pa_ind_cost_multipliers m
  WHERE  m.ind_rate_sch_revision_id = :revision_id
  ORDER BY m.organization_id, m.ind_cost_code;

• Join to cost codes for descriptive reporting:

  SELECT c.cost_code, m.multiplier
  FROM   pa_ind_cost_multipliers m, pa_ind_cost_codes c
  WHERE  m.ind_cost_code = c.ind_cost_code
  AND    m.ind_rate_sch_revision_id = :revision_id;

• Identify rows not yet ready to compile: filter on READY_TO_COMPILE_FLAG to support pre-compilation validation and troubleshooting.
• Organization-level multiplier extraction: join ORGANIZATION_ID to HR_ALL_ORGANIZATION_UNITS to translate IDs into organization names for reporting.

Related Objects

The following objects are most significant to PA_IND_COST_MULTIPLIERS based on the documented relationships:

• PA_IND_RATE_SCH_REVISIONS — Parent revision table; joined on IND_RATE_SCH_REVISION_ID.
• HR_ALL_ORGANIZATION_UNITS — Organization definition; joined on ORGANIZATION_ID.
• PA_IND_COST_CODES — Indirect cost code definitions; joined on IND_COST_CODE.
• PA_IND_RATE_SCHEDULES_ALL and PA_IND_RATE_SCHEDULES — Schedule headers linked through revisions, used for end-to-end burden schedule reporting.
• PA_BURDEN_COMPILATION / burden compilation concurrent programs — Consume READY_TO_COMPILE_FLAG and multiplier values to build compiled burden structures.
• PA_EXPENDITURES_ALL — Burdened cost derived from these multipliers is ultimately reflected in expenditure records.