Search Results cdl_denom_raw_cost

Overview

APPS.PA_CDL_BURDEN_DETAIL_V is a reporting view in Oracle E-Business Suite (12.1.1 and 12.2.2) that exposes burdened cost detail at the lowest grain of the Project Accounting cost distribution line (CDL). It is a critical object for organizations that need to reconcile raw costs with the burden (indirect cost) applied to them, particularly when a user searches on the internal column cdl_project_raw_cost. That column represents the raw, unburdened cost captured in the project currency prior to application of a compiled multiplier.

The view joins cost distribution line staging data (PA_EI_CDL_CM_GTEMP) to compiled multiplier definitions (PA_COMPILED_MULTIPLIERS) and then computes the burdened amount by multiplying each raw cost basis by the applicable compiled multiplier. Rounding is handled through the PA_CURRENCY package (round_trans_currency_amt1), producing currencies for the project, accounting, denominating, and project functional (projfunc) currencies simultaneously. Because it filters on Burden_sum_rejection_code IS NULL and Compiled_multiplier <> 0, the view presents only distributable, successfully burdened lines, making it suitable for downstream reporting and integration into costing extracts. The GET_CURRENT_SPONSORED_FLAG = 'N' predicate indicates the UNION query segregates sponsored (grant) versus non-sponsored processing.

Underlying Base Objects

The documented base objects include:

• PA_EI_CDL_CM_GTEMP (synonym): the driving global temporary table holding CDL / expenditure item rows and the raw cost columns (Cdl_amount, Cdl_denom_raw_cost, Cdl_acct_raw_cost, Cdl_project_raw_cost) joined by Ind_compiled_set_id and Cost_base.
• PA_COMPILED_MULTIPLIERS (synonym): supplies Compiled_multiplier, Cost_base, Ind_cost_code, and Ind_compiled_set_id.
• PA_IND_COST_CODES (synonym): subquery deriving Icc_expenditure_type from the indirect cost code.
• PA_CURRENCY (package): provides rounding of the multiplier products per currency.
• PA_BURDEN_COSTING (package): function call in the WHERE clause for sponsored flag logic.
• GMS_AWARD_DISTRIBUTIONS (synonym): participates in the UNION ALL grant/sponsored portion.

Key Columns

• Project_id, Task_id, Organization_id, Expenditure_item_id, Line_num: project/task/expenditure identification and line grain.
• Cdl_project_raw_cost: the raw cost in project currency, the searched column.
• Compiled_multiplier and Cost_base: the indirect rate application inputs.
• Project_burdened_cost, Acct_burdened_cost, Denom_burdened_cost, Burden_cost: computed burden amounts per currency, produced via PA_CURRENCY rounding.
• Project/Denom/Acct/Projfunc_currency_code: currency context fields for each amount.
• Billable_flag, Burden_sum_rejection_code, Adjustment_type: costing and costing-summary status attributes.
• Pa_date, Pa_period_name, Expenditure_item_date: date/period context used in period-based reporting.

Common Use Cases and Queries

Typical use is reconciling raw vs. burdened costs for a project and period, or extracting burden detail into a data warehouse. A representative query:

SELECT project_id, task_id, expenditure_item_id, line_num,
       cdl_project_raw_cost,
       compiled_multiplier,
       project_burdened_cost,
       project_currency_code
  FROM apps.pa_cdl_burden_detail_v
 WHERE project_id = :project_id
   AND pa_period_name = :period;

Because the view depends on the PA_EI_CDL_CM_GTEMP temporary table, it is populated only within the context of the burden run; outside of that process the table may be empty. Therefore the view should be consumed by the concurrent program or report that first loads the CDL compilation temp data, rather than queried ad hoc after the run completes, unless rows are persisted.