Results for “pa_ind_compiled_sets”

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

Overview

PA_IND_COMPILED_SETS is a transaction and setup table in the Oracle Projects (PA) module, owned by the PA schema. As documented in the ETRM metadata, it stores groups of compiled multipliers — the pre-compiled, staged results of indicator and rate calculation logic that Oracle Projects applies when computing burdened costs, revenue, and invoice amounts for a project. Rate schedules in Oracle Projects define how multipliers (such as burden rates, overhead absorption rates, and rate-based revenue multipliers) are derived. Before those multipliers can be consumed at transaction time, they must be compiled. PA_IND_COMPILED_SETS is the container that binds a compiled set to a specific rate schedule revision and to an owning organization unit, so that the compilation is scoped correctly by organization and by the effective version of the rate schedule.

The table therefore sits downstream of the rate schedule revision definition and upstream of the actual multiplier application logic. From a Data Vault modeling perspective, the metadata's heuristic classification marks this object as a link. This is a reasonable suggestion: the table chiefly relates a rate schedule revision to an organization unit (and to the compilation run that produced the set), making it an associative entity rather than a pure descriptive hub or satellite. The presence of descriptive attributes such as STATUS and COST_BASE means a satellite-style treatment would also be viable for temporal tracking.

Key Information Stored

The table comprises 14 documented columns. The most significant are:

• IND_COMPILED_SET_ID — The surrogate primary key that uniquely identifies each compiled set.
• IND_RATE_SCH_REVISION_ID — Foreign key to PA_IND_RATE_SCH_REVISIONS; identifies the specific revision of the indicator rate schedule whose multipliers were compiled into this set.
• ORGANIZATION_ID — Foreign key to HR_ALL_ORGANIZATION_UNITS; scopes the compiled set to a particular organization unit (for example, an expenditure organization or a burden-cost organization).
• COST_BASE — Identifies the cost base against which the compiled multipliers apply, a key business attribute for interpreting the set.
• STATUS — Indicates the validity or processing state of the compiled set.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN — Standard Oracle EBS who-columns for auditing and concurrency.
• REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE — Concurrent program and request context columns, indicating the compilation was executed as a concurrent process.

The business-key candidates combine IND_RATE_SCH_REVISION_ID, ORGANIZATION_ID, and COST_BASE, since a given schedule revision and organization should map to a coherent set of compiled multipliers. The repeated foreign key reference to HR_ALL_ORGANIZATION_UNITS in the metadata reflects multiple organizational relationships resolved by the same column.

Common Use Cases and Queries

Typical uses include diagnosing why a rate was not applied to a transaction, verifying that compilation completed for a given schedule revision, and reporting on which organizations have active compiled sets. A representative query joining the compiled set to its revision is:

• SELECT cs.ind_compiled_set_id, cs.organization_id, cs.cost_base, cs.status FROM pa.pa_ind_compiled_sets cs WHERE cs.ind_rate_sch_revision_id = :revision_id;
• Join to HR_ALL_ORGANIZATION_UNITS on ORGANIZATION_ID to resolve organization names for reporting.
• Filter on REQUEST_ID and PROGRAM_ID to audit which concurrent program instance generated a set.
• Order by LAST_UPDATE_DATE to identify the most recently compiled sets after a rate schedule change.

Related Objects

• PA_IND_RATE_SCH_REVISIONS — referenced via IND_RATE_SCH_REVISION_ID; the parent revision definition.
• HR_ALL_ORGANIZATION_UNITS — referenced via ORGANIZATION_ID; supplies organization context.
• The underlying compiled multiplier detail tables in the PA indicator rate infrastructure, which consume the set identifier.
• Oracle Projects rate and burden calculation concurrent programs, whose run context is captured by REQUEST_ID and PROGRAM_ID.
• Project cost, revenue, and invoice distribution tables whose multiplier application depends on a successfully compiled set.