Results for “compiled_multiplier”
50+ results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
PA_COMPILED_MULTIPLIERS is a Projects (PA) module table in Oracle E-Business Suite 12.1.1 and 12.2.2 that stores the compiled buildup multipliers used for burdening calculations. Burdening is the process by which indirect costs — overhead, fringe, general and administrative (G&A), and similar allocations — are applied to raw project costs and distributed across expenditure types and organizations. Rather than computing the full multiplicative chain at transaction time, Oracle Projects pre-compiles the effective multipliers and retains them in this table, allowing burden cost generation to resolve a single stored value per cost base and cost code combination. The table is owned by the PA schema and is documented as VALID in the ETRM repository.
Under a heuristic Data Vault classification mined from the foreign key structure, this table is satellite-leaning. It carries descriptive and numeric attributes (the compiled multiplier, precedence, and cost base information) attached to the natural business key formed by an indirect compiled set and a cost base cost code. The single documented foreign key — from COST_BASE_COST_CODE_ID to PA_COST_BASE_COST_CODES — anchors the satellite to its parent reference entity. This classification should be treated as a modeling suggestion rather than a physical design assertion.
Key Information Stored
The documented physical schema comprises 16 columns. The most significant are the following:
- IND_COMPILED_SET_ID — Identifier of the indirect compiled set to which the multiplier belongs. Together with COST_BASE_COST_CODE_ID, it forms the unique business key.
- COST_BASE_COST_CODE_ID — Foreign key to PA_COST_BASE_COST_CODES, identifying the cost base / cost code definition against which the multiplier applies.
- COST_BASE — The cost base value or category used in the burdening buildup logic.
- IND_COST_CODE — The indirect cost code being compiled, indicating which burden or indirect cost the multiplier resolves to.
- PRECEDENCE — Ordering value determining the sequence in which multipliers are applied when multiple buildup levels exist.
- COMPILED_MULTIPLIER — The pre-compiled, effective multiplier resulting from the full burden buildup chain.
- MULTIPLIER — The individual or source multiplier value contributing to the compiled result.
- Audit columns — LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATED_BY, CREATION_DATE, and LAST_UPDATE_LOGIN record who created and last modified each row and when.
- Concurrent program columns — REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, and PROGRAM_UPDATE_DATE identify the concurrent request and program that generated or refreshed the row.
The unique index PA_COMPILED_MULTIPLIERS_U1 on (IND_COMPILED_SET_ID, COST_BASE_COST_CODE_ID) is the documented business-key candidate. No separate single-column surrogate primary key is enumerated in the metadata; the unique index serves as the row discriminator for integration purposes.
Common Use Cases and Queries
The primary use case is burden cost generation and audit. Project accountants and integrators query this table to verify which multiplier was applied to a given cost base, to reconcile burdened expenditure, and to troubleshoot unexpected burden amounts. A typical pattern joins the table to its parent cost base definition:
- Multipliers for a compiled set:
SELECT ind_compiled_set_id, cost_base_cost_code_id, ind_cost_code, precedence, compiled_multiplier FROM pa.pa_compiled_multipliers WHERE ind_compiled_set_id = :set_id ORDER BY precedence; - Join to cost base definitions:
SELECT m.* FROM pa.pa_compiled_multipliers m, pa.pa_cost_base_cost_codes c WHERE m.cost_base_cost_code_id = c.cost_base_cost_code_id; - Refresh audit: filter on REQUEST_ID or PROGRAM_UPDATE_DATE to identify multipliers produced by a specific concurrent request.
Reporting typically surfaces precedence-ordered multiplier chains for a compiled set, enabling comparison of MULTIPLIER against the aggregated COMPILED_MULTIPLIER to confirm buildup integrity.
Related Objects
The following objects are the most significant for integration and analysis:
- PA_COST_BASE_COST_CODES — Parent table referenced via PA_COMPILED_MULTIPLIERS.COST_BASE_COST_CODE_ID; defines the cost bases and cost codes used in burdening.
- PA_IND_COMPILED_SETS — Source of IND_COMPILED_SET_ID; defines the compiled indirect cost set (join implied by column, not documented FK).
- PA_IND_COST_CODES — Reference for IND_COST_CODE values carried on the multiplier rows.
- PA_BURDEN_COST_DETAILS and PA_BURDEN_COSTS — Downstream burden results generated using these compiled multipliers.
- PA_COST_DISTRIBUTION_LINES_ALL — Distribution records whose burdened amounts trace back to compiled multiplier values.
- PA_IND_COMPILED_SETS concurrent program (PRC: Compile Multipliers) — the process that populates and refreshes this table, identified by REQUEST_ID and PROGRAM_ID.
-
Buildup multipliers used for burdening
-
This view displays commitment burden components for each transaction
APPS.PA_BURDEN_COMPONENT_CMT_V·↳ FND_PROFILE·↳ HR_GENERAL·↳ HR_SECURITY·Explore PA module →
-
View of burden cost components for a given compiled set ID, expenditure type, and expenditure organization.
APPS.PA_BURDEN_DETAILS_BASE_V·↳ HR_GENERAL·↳ HR_ORGANIZATION_UNITS·↳ HR_SECURITY·Explore PA module →
-
This view displays actual burden components for each transaction
APPS.PA_BURDEN_COMPONENT_COST_V·↳ FND_PROFILE·↳ HR_GENERAL·↳ HR_SECURITY·Explore PA module →
-
Buildup multipliers used for burdening
-
View of individual burden cost components of the burdened cost of each expenditure item that is burdened.
APPS.PA_COST_BURDEN_DETAILS_V·↳ HR_GENERAL·↳ HR_SECURITY·↳ PA_BURDEN_DETAILS_BASE_V·Explore PA module →
-
View of burden cost components for a given compiled set ID, expenditure type, and expenditure organization.
APPS.PA_BURDEN_DETAILS_BASE_V·↳ HR_GENERAL·↳ HR_ORGANIZATION_UNITS·↳ HR_SECURITY·Explore PA module →
-
This view displays commitment burden components for each transaction
APPS.PA_BURDEN_COMPONENT_CMT_V·↳ FND_PROFILE·↳ HR_GENERAL·↳ HR_SECURITY·Explore PA module →
-
This view displays actual burden components for each transaction
APPS.PA_BURDEN_COMPONENT_COST_V·↳ FND_PROFILE·↳ HR_GENERAL·↳ HR_SECURITY·Explore PA module →
-
PA_REV_BURDEN_DETAILS_V shows the individual burden cost components of the revenue amount for expenditure items that accrue revenue using burden schedules.
APPS.PA_REV_BURDEN_DETAILS_V·↳ HR_GENERAL·↳ HR_SECURITY·↳ PA_BURDEN_DETAILS_BASE_V·Explore PA module →
-
PA_BC_PACKETS holds all the transactions that copied from GL_BC_PACKETS. This a type of temporary table which holds all the relevant attributes of a transaction in addition to some other attribute values which are derived before they are p
-
APPS.GMS_CDL_BURDEN_DETAIL_V·↳ GMS_AWARD_DISTRIBUTIONS·↳ GMS_BURDEN_COSTING·↳ PA_COMPILED_MULTIPLIERS·Explore GMS module →
-
PA_BC_PACKETS holds all the transactions that copied from GL_BC_PACKETS. This a type of temporary table which holds all the relevant attributes of a transaction in addition to some other attribute values which are derived before they are p
-
APPS.GMS_CDL_BURDEN_DETAIL_V·↳ GMS_AWARD_DISTRIBUTIONS·↳ GMS_BURDEN_COSTING·↳ PA_COMPILED_MULTIPLIERS·Explore GMS module →
-
View of individual burden cost components, along with the labor multiplier, of the bill amount.
APPS.PA_INV_BURDEN_DETAILS_LM_V·↳ HR_GENERAL·↳ HR_SECURITY·↳ PA_CURRENCY·Explore PA module →
-
PA_REV_BURDEN_DETAILS_V shows the individual burden cost components of the revenue amount for expenditure items that accrue revenue using burden schedules.
APPS.PA_REV_BURDEN_DETAILS_V·↳ HR_GENERAL·↳ HR_SECURITY·↳ PA_BURDEN_DETAILS_BASE_V·Explore PA module →
-
View of individual burden cost components of the burdened cost of each expenditure item that is burdened.
APPS.PA_COST_BURDEN_DETAILS_V·↳ HR_GENERAL·↳ HR_SECURITY·↳ PA_BURDEN_DETAILS_BASE_V·Explore PA module →
-
View: PA_CMT_BURDEN_DETAIL_V 12.1.1
This view displays the indirect cost components of all the non-summarized Commitment transactions of a project using the proper indirect rate schedules and revisions.
APPS.PA_CMT_BURDEN_DETAIL_V·↳ PA_BURDEN_COSTING·↳ PA_COMMITMENT_TXNS·↳ PA_COMPILED_MULTIPLIERS·Explore PA module →
-
View: PA_CMT_BURDEN_DETAIL_V 12.2.2
This view displays the indirect cost components of all the non-summarized Commitment transactions of a project using the proper indirect rate schedules and revisions.
APPS.PA_CMT_BURDEN_DETAIL_V·↳ PA_BURDEN_COSTING·↳ PA_COMMITMENT_TXNS·↳ PA_COMPILED_MULTIPLIERS·Explore PA module →
-
View: PA_CDL_BURDEN_DETAIL_V 12.2.2
APPS.PA_CDL_BURDEN_DETAIL_V·↳ GMS_AWARD_DISTRIBUTIONS·↳ PA_BURDEN_COSTING·↳ PA_COMPILED_MULTIPLIERS·Explore IPA module →
-
View: PA_CDL_BURDEN_DETAIL_V 12.1.1
Summarization criteria for burden summarization of expenditure items.This view is based on PA_CDL_BURDEN_DETAIL_V. It is a User customizable view defined over the PA_CDL_BURDEN_DETAIL_V. User can change the columns to be included in summary
APPS.PA_CDL_BURDEN_DETAIL_V·↳ GMS_AWARD_DISTRIBUTIONS·↳ PA_BURDEN_COSTING·↳ PA_COMPILED_MULTIPLIERS·Explore PA module →
-
View of individual burden cost components, along with the labor multiplier, of the bill amount.
APPS.PA_INV_BURDEN_DETAILS_LM_V·↳ HR_GENERAL·↳ HR_SECURITY·↳ PA_CURRENCY·Explore PA module →
-
View of individual burden cost components of invoice amount of expenditure items.
APPS.PA_INV_BURDEN_DETAILS_V·↳ HR_GENERAL·↳ HR_SECURITY·↳ PA_BURDEN_DETAILS_BASE_V·Explore PA module →
-
View of individual burden cost components of invoice amount of expenditure items.
APPS.PA_INV_BURDEN_DETAILS_V·↳ HR_GENERAL·↳ HR_SECURITY·↳ PA_BURDEN_DETAILS_BASE_V·Explore PA module →
-
PA_BC_COMMITMENTS holds all the commitment transactions (Req, PO and Payables) that are funds checked. When maintain project balances programs sweeps the commitment records to project balances, the commitments are inserted into this table.
-
View: PA_CDL_BURDEN_DETAIL_V 12.1.1
APPS.PA_CDL_BURDEN_DETAIL_V·↳ GMS_AWARD_DISTRIBUTIONS·↳ PA_BURDEN_COSTING·↳ PA_COMPILED_MULTIPLIERS·Explore IPA module →
-
View: PA_CDL_BURDEN_DETAIL_V 12.2.2
Summarization criteria for burden summarization of expenditure items.This view is based on PA_CDL_BURDEN_DETAIL_V. It is a User customizable view defined over the PA_CDL_BURDEN_DETAIL_V. User can change the columns to be included in summary
APPS.PA_CDL_BURDEN_DETAIL_V·↳ GMS_AWARD_DISTRIBUTIONS·↳ PA_BURDEN_COSTING·↳ PA_COMPILED_MULTIPLIERS·Explore PA module →
-
PA_BC_COMMITMENTS holds all the commitment transactions (Req, PO and Payables) that are funds checked. When maintain project balances programs sweeps the commitment records to project balances, the commitments are inserted into this table.
-
View: PA_BC_COMMITMENTS 12.2.2
Single-Org
Not implemented in this database·Explore PA module →
-
View: PA_BC_COMMITMENTS 12.1.1
Single-Org
Not implemented in this database·Explore PA module →
-
VIEW: PA.PA_BC_PACKETS_HIST# 12.2.2
-
VIEW: PA.PA_BC_PACKETS# 12.2.2