Search Results system_reference1




Overview
Explore in AI Chat

Overview

APPS.PA_CDL_BURDEN_SUMMARY_V is a reporting and integration view within the Oracle E-Business Suite Projects (PA) module, belonging to the burden costing and summarization infrastructure. It presents burden cost summary records in a dual-source structure, exposing a complete set of source columns (prefixed source_) alongside a restricted set of destination columns (prefixed dest_). The view acts as the standardized interface through which burden summarization data—including multipliers, cost bases, burdened amounts, and currency attributes—is passed between the burden costing engine and downstream consumers such as client extensions, external costing applications, and integration programs.

The presence of both source and destination aliases reflects its role in mapping expenditure and burden detail into the summarization structures used by the PA_BURDEN_COSTING package. The system_reference1 column warrants particular attention: within this view it is aliased as source_vendor_id, indicating that the system reference attribute carries supplier or vendor identification when the burden context relates to supplier-originated costs.

Underlying Base Objects

The view is documented over the following referenced objects in ETRM 12.2.2 (and applies equivalently to 12.1.1):

  • PA_BURDEN_COSTING (PACKAGE) — the core costing engine that compiles multipliers, computes burdened costs, and populates the summary structures this view exposes.
  • PA_CDL_BURDEN_DETAIL_V (VIEW) — the detail-level counterpart supplying line-level expenditure and burden attributes.
  • PA_CLIENT_EXTN_BURDEN_RESOURCE (PACKAGE) — hook package for client extensions at the resource level.
  • PA_CLIENT_EXTN_BURDEN_SUMMARY (PACKAGE) — the client extension hook invoked in the summary path, into which this view feeds.
  • PA_CURRENCY (PACKAGE) — supplies currency conversion and denomination attributes such as denom, acct, project, and projfunc currency codes.

The view therefore does not resolve against a single physical table but rather composes the burden detail and currency logic maintained by these packages and views, presenting the summarized, currency-aware result set.

Key Columns

  • source_project_id, source_task_id, source_org_id — the project, task, and organization context of the burdened expenditure.
  • source_pa_date, source_pa_period_name, source_exp_item_date — accounting date, GL period, and expenditure item date driving period-based summarization.
  • attribute1 through attribute10, source_attribute_category — the descriptive flexfield context preserved from the expenditure.
  • source_system_linkage_function, source_ind_cost_code, source_expenditure_type, source_ind_expenditure_type — costing classification and burden linkage drivers.
  • source_cost_base, source_compiled_multiplier — the base amount against which burden is applied and the compiled multiplier value.
  • source_burden_cost, source_denom_burdened_cost, source_acct_burdened_cost, source_project_burdened_cost — burdened amounts across denomination, accounting, and project currency bases.
  • source_vendor_id (system_reference1) — supplier identifier carried through the system reference attribute.
  • dest_org_id, dest_pa_date, dest_attribute1, dest_ind_expenditure_type — the destination-side mapping target fields.
  • billable_flag, source_adjustment_type, source_burden_reject_code — billability status, adjustment classification, and any rejection reason from summarization.

Common Use Cases and Queries

This view is typically queried during burden costing diagnostics, integration extracts, and reconciliation of summarized burden amounts. A representative query filtering on the system reference attribute is:

  • SELECT source_project_id, source_task_id, source_vendor_id, source_pa_period_name, source_burden_cost FROM apps.pa_cdl_burden_summary_v WHERE source_vendor_id = :vendor_id;
  • SELECT source_org_id, source_cost_base, source_compiled_multiplier, billable_flag FROM apps.pa_cdl_burden_summary_v WHERE source_project_id = :project_id AND source_pa_period_name = :period;
  • Reconciliation of source_burden_cost against source_acct_burdened_cost and source_project_burdened_cost to confirm currency-basis consistency.

These patterns support burden auditing and external system integration where summary-level burdened figures, classified by project, task, organization, and supplier reference, are required.