Search Results burden_sum_source_run_id

Overview

PA_CDL_BURDEN_SUMMARY_V is an Oracle E-Business Suite view owned by the APPS schema and delivered with the IPA (Capital Resource Logistics – Projects) product family. It is a database view, not a table, and holds VALID status in both 12.1.1 and 12.2.2 environments. Functionally, the view exposes the summarized output of burden costing for capital projects, aggregating burden cost, burdened cost amounts, multipliers, and rate schedule references across projects, tasks, and organizations.

The view is not a primary transactional interface. It is intended for reporting, data extraction, and integration, where external systems or custom reports require a stable, consolidated representation of burden calculations. Because the column names carry the SOURCE_ prefix, the view presents burden records from a lineage-preserving perspective, mapping identified resource transactions (expenditure items) to their summarized burden totals.

Underlying Base Objects

The view text is defined entirely over PA_CDL_BURDEN_DETAIL_V, another IPA view in the same schema. All columns in the summary view are drawn from that detail view, with selected columns aliased using the SOURCE_ prefix. A derived column, DEST_SUMMARY_GROUP, is constructed by concatenating PROJECT_ID, TASK_ID, ORGANIZATION_ID, PA_DATE, DENOM_CURRENCY_CODE (with NVL fallback to ACCT_CURRENCY_CODE), ACCT_CURRENCY_CODE, PROJECT_CURRENCY_CODE, and IND_COST_CODE.

Documented referenced objects include PA_BURDEN_COSTING (package), which performs the core burden arithmetic; PA_CLIENT_EXTN_BURDEN_RESOURCE and PA_CLIENT_EXTN_BURDEN_SUMMARY (client extension packages), which allow customizations to burden resource and summary logic; and PA_CURRENCY (package), which handles currency conversion and denomination.

Key Columns

• source_org_id — the organization identifier (typically an inventory or costing organization) for the source burdened transaction. This is the column most directly relevant to the original search query.
• source_project_id / source_task_id — the project and task to which the original expenditure belongs.
• source_pa_date / source_exp_item_date — the date used for period-based burden computation.
• source_burden_cost / source_denom_burdened_cost / source_acct_burdened_cost — burden amount expressed in transactional, denominated, and accounting currencies.
• source_compiled_multiplier — the applied burden multiplier, compiled by PA_BURDEN_COSTING.
• source_ind_rate_sch_id / source_ind_rate_sch_rev_id — the burden rate schedule and revision used.
• source_currency_code columns — denomination, accounting, and project currency codes.
• source_id / source_burden_reject — the source summary run identifier and any rejection code from burden summarization.
• dest_summary_group — the derived grouping key used to consolidate detail records into summary rows.

Common Use Cases and Queries

Typical uses include reconciliation of burdened amounts per organization, currency revaluation reporting, and feeding downstream analytics or ETL processes. A frequent query filters by the source organization:

SELECT source_project_id, source_task_id, source_org_id, source_pa_date,
  source_burden_cost, source_acct_burdened_cost, dest_summary_group
FROM apps.pa_cdl_burden_summary_v
WHERE source_org_id = :org_id
AND source_pa_date BETWEEN :start_date AND :end_date;

A second pattern aggregates burden cost by summary group to validate submitted burden summaries:

SELECT dest_summary_group, SUM(source_burden_cost) burden_total
FROM apps.pa_cdl_burden_summary_v
GROUP BY dest_summary_group;

Because the view has no WHERE clause of its own, all filtering must be applied by the calling query; the client extension packages provide designated extension points should customized burden attributes be required.