Search Results compiled_multiplier

Overview

PA_BC_COMMITMENTS is a single-organization view within the Oracle EBS Projects (PA) module that exposes burden cost commitment and encumbrance data used by the Project Burdening and Commitment Cost processes. It presents transaction-level detail for commitment amounts, burdened totals, transfer status, and the associated accounting identifiers (CCIDs) generated when commitment costs are compiled and later relieved against actual expenditures. The view is central to the flow that moves supplier commitments and encumbrances through the Projects subledger into General Ledger.

The view is documented as Not implemented in this database, meaning the compiled definition is derived rather than stored in the sample environment from which the ETRM metadata was captured. Its defining characteristic is the ORG_ID predicate applied at the end of the view text, which performs a multi-organization security filter using USERENV('CLIENT_INFO') truncated to ten characters. This mechanism restricts rows to the operating unit (ORG_ID) currently set in the user session, converting the underlying multi-org table into a single-org presentation suitable for reporting and concurrent processing.

Underlying Base Objects

The ETRM metadata documents no base objects for this view, but the SELECT text unambiguously identifies the source as PA_BC_COMMITMENTS_ALL. The _ALL suffix indicates a multi-organization table that carries ORG_ID and is secured by the standard multi-org partition logic. PA_BC_COMMITMENTS is therefore a filtered projection of PA_BC_COMMITMENTS_ALL, exposing the same column list while applying the client-info ORG_ID restriction at runtime. Process EX_PROCESS — a unique key involving BC_COMMITMENT_ID, BC_PACKET_ID, PARENT_BC_PACKET_ID, PACKET_ID, and PROCESS_EXP_ITEM_ID — identifies individual rows within the table.

Key Columns

The column list is broad and supports both transactional and accounting processing. The COMPILED_MULTIPLIER column, the term the user searched for, is the factor applied to the commitment raw amount to derive the burdened commitment amount during compilation. It sits alongside COMM_TOT_RAW_AMT, COMM_TOT_BD_AMT, COMM_RAW_AMT_RELIEVED, and COMM_BD_AMT_RELIEVED, which together track raw and burdened commitment totals and their relieved portions. Other notable columns include:

BC_COMMITMENT_ID, PACKET_ID, BC_PACKET_ID, PARENT_BC_PACKET_ID — primary and packet grouping identifiers for the commitment record.
PROJECT_ID, TASK_ID, TOP_TASK_ID, BUD_TASK_ID — project and task context, including top task and budgeted task references.
EXPENDITURE_TYPE, EXPENDITURE_ITEM_DATE, EXP_ITEM_ID, PROCESS_EXP_ITEM_ID — expenditure classification and linkage to the expenditure item being matched or relieved.
TRANSFER_STATUS_CODE, BURDEN_COST_FLAG, COMM_TRANSFER_REJ_REASON, PROJ_TRANSFER_REJ_REASON — status and rejection details for the transfer of commitments into GL or Projects costs.
TXN_CCID, PROCESS_CCID, BUDGET_CCID — code combinations for transaction, processing, and budget accounting.
ENTERED_DR, ENTERED_CR, ACCOUNTED_DR, ACCOUNTED_CR — entered and accounted debit/credit amounts in the functional currency.
GL_DATE, PA_DATE, LIQUIDATE_GL_DATE, TRANSFERRED_DATE, FC_START_DATE, FC_END_DATE — key dates governing accrual, liquidation, and transfer.
SET_OF_BOOKS_ID, PERIOD_NAME, PERIOD_YEAR, PERIOD_NUM — ledger and period context for reporting.
ACTUAL_FLAG, SUMMARY_RECORD_FLAG, REFERENCE1–3 — control flags and descriptive references.
ORG_ID — operating unit, used by the view's security predicate.

Common Use Cases and Queries

The view supports reconciliation of commitment and burden amounts, analysis of transfer status, and investigation of the multiplier applied during burdens compilation. A typical query examining the compiled multiplier against the raw and burdened totals is:

Burden reconciliation: SELECT BC_COMMITMENT_ID, PROJECT_ID, TASK_ID, EXPENDITURE_TYPE, COMM_TOT_RAW_AMT, COMPILED_MULTIPLIER, COMM_TOT_BD_AMT, COMM_RAW_AMT_RELIEVED, COMM_BD_AMT_RELIEVED FROM PA_BC_COMMITMENTS WHERE PROJECT_ID = :p_project_id ORDER BY BC_COMMITMENT_ID;
Transfer status review: SELECT PACKET_ID, TRANSFER_STATUS_CODE, COMM_TRANSFER_REJ_REASON, PROJ_TRANSFER_REJ_REASON, COUNT(*) FROM PA_BC_COMMITMENTS GROUP BY PACKET_ID, TRANSFER_STATUS_CODE, COMM_TRANSFER_REJ_REASON, PROJ_TRANSFER_REJ_REASON;
Period accounting detail: SELECT PERIOD_NAME, GL_DATE, TXN_CCID, ENTERED_DR, ENTERED_CR, ACCOUNTED_DR, ACCOUNTED_CR FROM PA_BC_COMMITMENTS WHERE PERIOD_NAME = :p_period AND SET_OF_BOOKS_ID = :p_sob;
Unrelieved burdened commitments: SELECT BC_COMMITMENT_ID, COMM_TOT_BD_AMT - COMM_BD_AMT_RELIEVED AS BALANCE FROM PA_BC_COMMITMENTS WHERE ACTUAL_FLAG = 'C' AND COMM_TOT_BD_AMT <> COMM_BD_AMT_RELIEVED;

Because the view enforces ORG_ID filtering through CLIENT_INFO, reports must ensure the correct operating unit is initialized in the session before querying, otherwise rows may be excluded or unexpectedly included.

View: PA_BC_COMMITMENTS 12.1.1
product: PA - Projects , description: Single-Org , implementation_dba_data: Not implemented in this database ,
View: PA_BC_COMMITMENTS 12.2.2
product: PA - Projects , description: Single-Org , implementation_dba_data: Not implemented in this database ,
View: PA_BURDEN_COMPONENT_CMT_V 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:PA.PA_BURDEN_COMPONENT_CMT_V, object_name:PA_BURDEN_COMPONENT_CMT_V, status:VALID, product: PA - Projects , description: This view displays commitment burden components for each transaction , implementation_dba_data: APPS.PA_BURDEN_COMPONENT_CMT_V ,
View: PA_BURDEN_COMPONENT_COST_V 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:PA.PA_BURDEN_COMPONENT_COST_V, object_name:PA_BURDEN_COMPONENT_COST_V, status:VALID, product: PA - Projects , description: This view displays actual burden components for each transaction , implementation_dba_data: APPS.PA_BURDEN_COMPONENT_COST_V ,
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_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_BURDEN_COMPONENT_CMT_V 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:PA.PA_BURDEN_COMPONENT_CMT_V, object_name:PA_BURDEN_COMPONENT_CMT_V, status:VALID, product: PA - Projects , description: This view displays commitment burden components for each transaction , implementation_dba_data: APPS.PA_BURDEN_COMPONENT_CMT_V ,
View: PA_BURDEN_COMPONENT_COST_V 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:PA.PA_BURDEN_COMPONENT_COST_V, object_name:PA_BURDEN_COMPONENT_COST_V, status:VALID, product: PA - Projects , description: This view displays actual burden components for each transaction , implementation_dba_data: APPS.PA_BURDEN_COMPONENT_COST_V ,
View: PA_COST_BURDEN_DETAILS_V 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:PA.PA_COST_BURDEN_DETAILS_V, object_name:PA_COST_BURDEN_DETAILS_V, status:VALID, product: PA - Projects , description: View of individual burden cost components of the burdened cost of each expenditure item that is burdened. , implementation_dba_data: APPS.PA_COST_BURDEN_DETAILS_V ,
View: PA_REV_BURDEN_DETAILS_V 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:PA.PA_REV_BURDEN_DETAILS_V, object_name:PA_REV_BURDEN_DETAILS_V, status:VALID, product: PA - Projects , description: PA_REV_BURDEN_DETAILS_V shows the individual burden cost components of the revenue amount for expenditure items that accrue revenue using burden schedules. , implementation_dba_data: APPS.PA_REV_BURDEN_DETAILS_V ,
View: PA_REV_BURDEN_DETAILS_V 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:PA.PA_REV_BURDEN_DETAILS_V, object_name:PA_REV_BURDEN_DETAILS_V, status:VALID, product: PA - Projects , description: PA_REV_BURDEN_DETAILS_V shows the individual burden cost components of the revenue amount for expenditure items that accrue revenue using burden schedules. , implementation_dba_data: APPS.PA_REV_BURDEN_DETAILS_V ,
View: PA_INV_BURDEN_DETAILS_V 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:PA.PA_INV_BURDEN_DETAILS_V, object_name:PA_INV_BURDEN_DETAILS_V, status:VALID, product: PA - Projects , description: View of individual burden cost components of invoice amount of expenditure items. , implementation_dba_data: APPS.PA_INV_BURDEN_DETAILS_V ,
View: PA_INV_BURDEN_DETAILS_V 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:PA.PA_INV_BURDEN_DETAILS_V, object_name:PA_INV_BURDEN_DETAILS_V, status:VALID, product: PA - Projects , description: View of individual burden cost components of invoice amount of expenditure items. , implementation_dba_data: APPS.PA_INV_BURDEN_DETAILS_V ,
View: PA_COST_BURDEN_DETAILS_V 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:PA.PA_COST_BURDEN_DETAILS_V, object_name:PA_COST_BURDEN_DETAILS_V, status:VALID, product: PA - Projects , description: View of individual burden cost components of the burdened cost of each expenditure item that is burdened. , implementation_dba_data: APPS.PA_COST_BURDEN_DETAILS_V ,
View: PA_CMT_BURDEN_SUMMARY_V 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:PA.PA_CMT_BURDEN_SUMMARY_V, object_name:PA_CMT_BURDEN_SUMMARY_V, status:VALID, product: PA - Projects , description: This user customizable view defines the summarization criteria for burden summarization of commitment transactions. , implementation_dba_data: APPS.PA_CMT_BURDEN_SUMMARY_V ,
View: PA_CMT_BURDEN_SUMMARY_V 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:PA.PA_CMT_BURDEN_SUMMARY_V, object_name:PA_CMT_BURDEN_SUMMARY_V, status:VALID, product: PA - Projects , description: This user customizable view defines the summarization criteria for burden summarization of commitment transactions. , implementation_dba_data: APPS.PA_CMT_BURDEN_SUMMARY_V ,
View: PA_INV_BURDEN_DETAILS_LM_V 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:PA.PA_INV_BURDEN_DETAILS_LM_V, object_name:PA_INV_BURDEN_DETAILS_LM_V, status:VALID, product: PA - Projects , description: View of individual burden cost components, along with the labor multiplier, of the bill amount. , implementation_dba_data: APPS.PA_INV_BURDEN_DETAILS_LM_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 ,
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_INV_BURDEN_DETAILS_LM_V 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:PA.PA_INV_BURDEN_DETAILS_LM_V, object_name:PA_INV_BURDEN_DETAILS_LM_V, status:VALID, product: PA - Projects , description: View of individual burden cost components, along with the labor multiplier, of the bill amount. , implementation_dba_data: APPS.PA_INV_BURDEN_DETAILS_LM_V ,
View: PA_CDL_BURDEN_SUMMARY_V 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:IPA.PA_CDL_BURDEN_SUMMARY_V PA.PA_CDL_BURDEN_SUMMARY_V, object_name:PA_CDL_BURDEN_SUMMARY_V, status:VALID, product: PA - Projects , description: Summarization criteria for burden summarization of expenditure items. , implementation_dba_data: APPS.PA_CDL_BURDEN_SUMMARY_V ,
View: PA_CDL_BURDEN_SUMMARY_V 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:IPA.PA_CDL_BURDEN_SUMMARY_V PA.PA_CDL_BURDEN_SUMMARY_V, object_name:PA_CDL_BURDEN_SUMMARY_V, status:VALID, product: PA - Projects , description: Summarization criteria for burden summarization of expenditure items. , implementation_dba_data: APPS.PA_CDL_BURDEN_SUMMARY_V ,
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 ,
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_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 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 ,