Search Results pa_compiled_multipliers

Overview

The PA_COMPILED_MULTIPLIERS table is a core data object within the Oracle E-Business Suite (EBS) Projects (PA) module, specifically for releases 12.1.1 and 12.2.2. It serves as the foundational repository for pre-calculated burdening multipliers. In the context of project costing, burdening refers to the process of applying indirect costs (overhead) to direct project costs. This table stores the compiled, or "buildup," multipliers that are applied to raw cost transactions to calculate their fully burdened cost. Its role is critical for ensuring accurate project accounting, cost accumulation, and financial reporting, as it holds the definitive rates used to derive total project expenses.

Key Information Stored

While the provided metadata does not list specific columns, the table's description and foreign key relationship define its core data structure. The table is fundamentally a cross-reference linking multipliers to specific cost bases. A primary column is COST_BASE_COST_CODE_ID, which is a foreign key to the PA_COST_BASE_COST_CODES table. This links each multiplier record to a specific cost classification or code. The table then stores one or more multiplier values (likely in columns such as MULTIPLIER, RATE, or similar) associated with that cost base. These multipliers are typically numeric factors used in calculations. The compilation implies these values are the final, applicable rates derived from potentially complex burden schedule hierarchies and effective date rules.

Common Use Cases and Queries

The primary use case is the real-time burdening of project expenditure items, such as labor, equipment, or materials. When a cost is incurred, the system references this table to find the appropriate multiplier for the transaction's cost base and applies it to compute burden. For reporting and reconciliation, common queries involve joining this table to cost base and transaction data. A typical analytical query might be:

• Listing all active multipliers for a set of cost codes to audit burden rates.
• Comparing compiled multipliers across different burden schedules or effective periods.
• Tracing the fully burdened cost of a project by joining transaction lines to their source multipliers.

For example: SELECT pcbc.cost_code, pcm.multiplier FROM pa_compiled_multipliers pcm, pa_cost_base_cost_codes pcbc WHERE pcm.cost_base_cost_code_id = pcbc.cost_base_cost_code_id;

Related Objects

The PA_COMPILED_MULTIPLIERS table is central to the burdening engine and integrates with several key objects. As documented, it has a direct foreign key relationship with PA_COST_BASE_COST_CODES, which defines the valid cost codes for burdening. It is inherently linked to burden schedule definition tables (e.g., PA_BURDEN_COST_CODES, PA_BURDEN_STRUCTURES), from which the multipliers are originally sourced and compiled. Furthermore, transaction tables like PA_EXPENDITURE_ITEMS_ALL or costing engine tables will reference the compiled multipliers, either directly or via APIs, to perform the actual burden cost calculations during transaction processing.