Search Results pa_compiled_multipliers




Overview
Explore in AI Chat

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.

  • Table: PA_COMPILED_MULTIPLIERS 12.2.2

    owner:PA,  object_type:TABLE,  fnd_design_data:PA.PA_COMPILED_MULTIPLIERS,  object_name:PA_COMPILED_MULTIPLIERS,  status:VALID,  product: PA - Projects ,  description: Buildup multipliers used for burdening ,  implementation_dba_data: PA.PA_COMPILED_MULTIPLIERS , 

  • Table: PA_COMPILED_MULTIPLIERS 12.1.1

    owner:PA,  object_type:TABLE,  fnd_design_data:PA.PA_COMPILED_MULTIPLIERS,  object_name:PA_COMPILED_MULTIPLIERS,  status:VALID,  product: PA - Projects ,  description: Buildup multipliers used for burdening ,  implementation_dba_data: PA.PA_COMPILED_MULTIPLIERS , 

  • Table: PA_COST_BASE_COST_CODES 12.2.2

    owner:PA,  object_type:TABLE,  fnd_design_data:PA.PA_COST_BASE_COST_CODES,  object_name:PA_COST_BASE_COST_CODES,  status:VALID,  product: PA - Projects ,  description: Burden cost codes associated with cost bases ,  implementation_dba_data: PA.PA_COST_BASE_COST_CODES , 

  • View: PA_CDL_BURDEN_DETAIL_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:IPA.PA_CDL_BURDEN_DETAIL_V PA.PA_CDL_BURDEN_DETAIL_V,  object_name:PA_CDL_BURDEN_DETAIL_V,  status:VALID,  product: PA - Projects ,  description: 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 ,  implementation_dba_data: APPS.PA_CDL_BURDEN_DETAIL_V , 

  • Table: PA_COST_BASE_COST_CODES 12.1.1

    owner:PA,  object_type:TABLE,  fnd_design_data:PA.PA_COST_BASE_COST_CODES,  object_name:PA_COST_BASE_COST_CODES,  status:VALID,  product: PA - Projects ,  description: Burden cost codes associated with cost bases ,  implementation_dba_data: PA.PA_COST_BASE_COST_CODES , 

  • View: PA_BURDEN_DETAILS_BASE_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_BURDEN_DETAILS_BASE_V,  object_name:PA_BURDEN_DETAILS_BASE_V,  status:VALID,  product: PA - Projects ,  description: View of burden cost components for a given compiled set ID, expenditure type, and expenditure organization. ,  implementation_dba_data: APPS.PA_BURDEN_DETAILS_BASE_V , 

  • View: PA_CDL_BURDEN_DETAIL_V_R 12.1.1

    product: PA - Projects ,  description: 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 ,  implementation_dba_data: Not implemented in this database , 

  • View: PA_CDL_BURDEN_DETAIL_V_R 12.2.2

    product: PA - Projects ,  description: 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 ,  implementation_dba_data: Not implemented in this database , 

  • View: PA_BURDEN_DETAILS_BASE_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_BURDEN_DETAILS_BASE_V,  object_name:PA_BURDEN_DETAILS_BASE_V,  status:VALID,  product: PA - Projects ,  description: View of burden cost components for a given compiled set ID, expenditure type, and expenditure organization. ,  implementation_dba_data: APPS.PA_BURDEN_DETAILS_BASE_V , 

  • View: PA_CDL_BURDEN_DETAIL_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:IPA.PA_CDL_BURDEN_DETAIL_V PA.PA_CDL_BURDEN_DETAIL_V,  object_name:PA_CDL_BURDEN_DETAIL_V,  status:VALID,  product: PA - Projects ,  description: 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 ,  implementation_dba_data: APPS.PA_CDL_BURDEN_DETAIL_V , 

  • View: PA_CMT_BURDEN_DETAIL_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_CMT_BURDEN_DETAIL_V,  object_name:PA_CMT_BURDEN_DETAIL_V,  status:VALID,  product: PA - Projects ,  description: 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. ,  implementation_dba_data: APPS.PA_CMT_BURDEN_DETAIL_V , 

  • View: PA_CMT_BURDEN_DETAIL_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:PA.PA_CMT_BURDEN_DETAIL_V,  object_name:PA_CMT_BURDEN_DETAIL_V,  status:VALID,  product: PA - Projects ,  description: 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. ,  implementation_dba_data: APPS.PA_CMT_BURDEN_DETAIL_V ,