Results for “pa_ind_rate_sch_revisions”

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

Overview

PA_IND_RATE_SCH_REVISIONS is a Projects (PA) module table that stores the individual revisions defined within burden schedules — otherwise known as indirect rate schedules. In Oracle EBS 12.1.1 and 12.2.2, burden schedules assign indirect cost rates and multipliers to projects, and each schedule may pass through one or more revisions as rates are updated, recompiled, or superseded. This table captures the header-level identity and control attributes for each such revision, serving as the anchor point for the compiled sets, cost multipliers, and rate multipliers that define how the schedule calculates burden at any given point in time.

From a dimensional modeling perspective, the table's foreign-key topology and its role as the target of multiple dependent child tables suggest a hub classification. It holds the durable business key of a schedule revision and is referenced by several satellites and link-style dependents rather than storing the full descriptive payload itself. This classification is a modeling heuristic, not an Oracle-prescribed designation.

Key Information Stored

The table contains 23 documented columns. The most consequential are:

• IND_RATE_SCH_REVISION_ID — the surrogate primary key (PA_IND_RATE_SCH_REVISIONS_PK) and the value propagated to every dependent child table.
• IND_RATE_SCH_ID — foreign key to PA_IND_RATE_SCHEDULES_ALL_BG, identifying the parent burden schedule. Together with the next two columns it forms the unique business key PA_IND_RATE_SCH_REVISIONS_U2.
• IND_RATE_SCH_REVISION — the revision identifier or name of the schedule revision.
• IND_RATE_SCH_REVISION_TYPE — the classification of the revision, distinguishing standard and alternative revision types.
• START_DATE_ACTIVE / END_DATE_ACTIVE — the effective date range during which the revision applies, central to date-effective rate resolution.
• COMPILED_FLAG and COMPILED_DATE — indicate whether the revision's rate structures have been compiled and when, controlling whether the revision is usable for burden calculation.
• READY_TO_COMPILE_FLAG — marks whether the revision is eligible for the compilation process.
• COST_PLUS_STRUCTURE — foreign key to PA_COST_PLUS_STRUCTURES, tying the revision to its cost-plus burden structure.
• ACTUAL_SCH_REVISION_ID — a self-referencing foreign key relating a revision to another revision, typically the actual or source revision.
• ORGANIZATION_STRUCTURE_ID and ORG_STRUCTURE_VERSION_ID — foreign keys to PER_ORGANIZATION_STRUCTURES and PER_ORG_STRUCTURE_VERSIONS, scoping the revision to an organization hierarchy version.
• START_ORGANIZATION_ID — the starting organization for the applicable range.
• Standard audit columns — LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN, REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, and PROGRAM_UPDATE_DATE.

Common Use Cases and Queries

Typical reporting and diagnostics center on identifying which revision of a burden schedule is active on a given date, whether it has been compiled, and which child multipliers it owns. A representative query joins revisions to their parent schedule:

SELECT r.ind_rate_sch_revision_id, r.ind_rate_sch_id, r.ind_rate_sch_revision, r.ind_rate_sch_revision_type, r.start_date_active, r.end_date_active, r.compiled_flag FROM pa.pa_ind_rate_sch_revisions r JOIN pa.pa_ind_rate_schedules_all_bg s ON s.ind_rate_sch_id = r.ind_rate_sch_id WHERE TRUNC(SYSDATE) BETWEEN r.start_date_active AND NVL(r.end_date_active, TRUNC(SYSDATE)+1);

Other frequent patterns include auditing uncompiled revisions (WHERE compiled_flag = 'N'), reconciling effective-date gaps or overlaps within a schedule, and tracing burden applied to transactions by walking from PA_ALLOC_TXN_DETAILS back to the owning revision.

Related Objects

• PA_IND_RATE_SCHEDULES_ALL_BG — parent schedule; joined on IND_RATE_SCH_ID.
• PA_COST_PLUS_STRUCTURES — cost-plus structure; joined on COST_PLUS_STRUCTURE.
• PER_ORGANIZATION_STRUCTURES — organization hierarchy; joined on ORGANIZATION_STRUCTURE_ID.
• PER_ORG_STRUCTURE_VERSIONS — hierarchy version; joined on ORG_STRUCTURE_VERSION_ID.
• PA_IND_COMPILED_SETS — compiled rate sets; references IND_RATE_SCH_REVISION_ID.
• PA_IND_COST_MULTIPLIERS — cost multipliers; references IND_RATE_SCH_REVISION_ID.
• PA_CINT_RATE_MULTIPLIERS — rate multipliers; references IND_RATE_SCH_REVISION_ID.
• PA_ALLOC_TXN_DETAILS — allocation transaction detail; references IND_RATE_SCH_REVISION_ID.
• PA_IND_RATE_SCH_REVISIONS (self) — self-reference via ACTUAL_SCH_REVISION_ID.