Search Results source_exp_category

Overview

PA_CMT_BURDEN_SUMMARY_V is a user-customizable view owned by the APPS schema in Oracle E-Business Suite, delivered with the Projects (PA) module. It defines the summarization criteria used during burden summarization of commitment transactions. In the commitment burdening process, individual commitment distributions must be grouped into logical buckets before burden is calculated and applied; this view provides the declarative definition of those buckets by mapping source attributes to destination attributes. The view itself exposes a single source column alongside its corresponding destination column for each summarization attribute, allowing the burdening engine to compare source and target values and thereby determine which commitment transactions collapse into the same summary record. Because the view is designated user-customizable, implementers may modify the SQL behind it to alter grouping behavior without modifying Oracle's seeded burdening logic, making it a controlled extension point within the commitment burden summarization framework. The user search term "source_org_id" corresponds directly to the column ORGANIZATION_ID SOURCE_ORG_ID in the view text, which governs organization-level grouping during summarization.

Underlying Base Objects

According to the documented view metadata, PA_CMT_BURDEN_SUMMARY_V references three base objects: the package PA_BURDEN_COSTING, the package PA_CLIENT_EXTN_BURDEN_RESOURCE, and the view PA_CMT_BURDEN_DETAIL_V. The dependency on PA_CMT_BURDEN_DETAIL_V is consistent with the view's structure, which projects the same physical columns twice—for example, PROJECT_ID is selected as both SOURCE_PROJECT_ID and DEST_PROJECT_ID. This dual projection supports the source-to-destination comparison logic used by summarization. The packages PA_BURDEN_COSTING and PA_CLIENT_EXTN_BURDEN_RESOURCE provide the procedural infrastructure and client extension hooks that consume the summarization criteria defined here, allowing customers to influence burden resource derivation.

Key Columns

The view exposes paired SOURCE_ and DEST_ columns covering the summarization keys. Source and destination counterparts include SOURCE_PROJECT_ID/DEST_PROJECT_ID, SOURCE_TASK_ID/DEST_TASK_ID, SOURCE_ORG_ID/DEST_ORG_ID, SOURCE_PA_PERIOD/DEST_PA_PERIOD, SOURCE_GL_PERIOD/DEST_GL_PERIOD, SOURCE_TXN_SOURCE/DEST_TXN_SOURCE, SOURCE_LINE_TYPE/DEST_LINE_TYPE, SOURCE_IND_COST_CODE/DEST_IND_COST_CODE, SOURCE_EXP_CATEGORY/DEST_EXP_CATEGORY, and SOURCE_REVENUE_CATEGORY/DEST_REVENUE_CATEGORY. Additional attributes include the transaction references (SOURCE_TXN_REF1 through SOURCE_TXN_REF3 and their DEST counterparts), expenditure types, cost base, compiled multiplier, indirect rate schedule identifiers, burden cost, run identifier, rejection code, and the system linkage function. Resource classification is exposed through RESOURCE_CLASS. Financial columns include ACCT_RAW_COST, ACCT_BURDENED_COST, DENOM_RAW_COST, DENOM_BURDENED_COST alongside currency codes, rate dates, rate types, and exchange rates for both accounting and project currencies. Resource identifiers such as VENDOR_ID, INVENTORY_ITEM_ID, BOM_LABOR_RESOURCE_ID, and BOM_EQUIPMENT_RESOURCE_ID preserve source document references.

Common Use Cases and Queries

Typical usage involves querying the view to understand or validate how commitment transactions will be grouped during burden summarization. A developer investigating organization-level grouping might run:

• SELECT SOURCE_PROJECT_ID, SOURCE_TASK_ID, SOURCE_ORG_ID, DEST_ORG_ID FROM PA_CMT_BURDEN_SUMMARY_V WHERE SOURCE_ORG_ID IS NOT NULL;
• Joining the view to commitment detail tables to reconcile SOURCE_BURDEN_COST against calculated amounts.
• Reviewing SOURCE_BURDEN_SUM_REJ_CODE values to identify summarization rejections.
• Customizing the underlying SQL to redirect grouping—for example, forcing DEST_ORG_ID to a constant—to consolidate burden across organizations.

Because changes affect seeded burdening behavior, modifications should be thoroughly regression-tested in a non-production environment.