Search Results pa_deduction_summary_base_v

View: PA_DEDUCTION_SUMMARY_BASE_V

Overview

PA_DEDUCTION_SUMMARY_BASE_V is a reporting view owned by the APPS schema in Oracle E-Business Suite, belonging to the Projects (PA) product family. It exposes summarized burden deduction data captured against project and task expenditure, aggregating the project functional currency amounts associated with deduction transactions. The view serves as an analytical layer over the deduction transaction and deduction header tables, allowing implementers and report developers to present deduction totals by project, task, expenditure type, and expenditure organization without directly joining the underlying transactional tables.

The view is classified as VALID in the documented metadata and is available in both Oracle EBS 12.1.1 and 12.2.2 environments. Its role is primarily informational and reporting-oriented rather than transactional; it is typically consumed by custom reports, extracts, and integration interfaces that require a consolidated picture of deductions applied to project costs. Because it is a view rather than a table, the data is derived at query time and always reflects the current state of the base tables.

Underlying Base Objects

The view is defined over four documented base objects, all referenced through APPS synonyms:

• PA_DEDUCTION_TRANSACTIONS_ALL – the principal source of deduction transaction lines, providing task, expenditure type, expenditure organization, and project functional currency amounts.
• PA_DEDUCTIONS_ALL – the deduction request header, supplying the CI_ID, the deduction request identifier, and processing status.
• PA_TASKS – provides the human-readable task number associated with each transaction task.
• HR_ALL_ORGANIZATION_UNITS – provides the expenditure organization name used to label each aggregated row.

The view joins deduction transactions to their deduction headers on DEDUCTION_REQ_ID, to tasks on TASK_ID, and to organizations on EXPENDITURE_ORG_ID. A correlated subquery against PA_DEDUCTION_TRANSACTIONS_ALL and PA_DEDUCTIONS_ALL further derives the processed deduction amount for the matching CI_ID, expenditure organization, task, and expenditure type combination.

Key Columns

• CI_ID – the cost collection / interface identifier linking the row to the deduction header; the view filters on CI_ID IS NOT NULL.
• PROJECT_ID – the project to which the deduction applies.
• TASK_ID / TASK_NUMBER – the task identifier and its display number.
• EXPENDITURE_TYPE – the expenditure type category of the deducted cost.
• EXPENDITURE_ORG_ID / EXPENDITURE_ORG – the expenditure organization identifier and name.
• PFC_DEDUCTIONS_AMOUNT – the sum of project functional currency deduction amounts, using the override amount where present and otherwise the original amount.
• PFC_PROC_DED_AMOUNT – the corresponding total for deductions whose header status is 'PROCESSED'.

Common Use Cases and Queries

Typical uses include reconciling deductions by organization and expenditure type, and reporting processed versus total deduction amounts for a project.

SELECT project_id,
       task_number,
       expenditure_type,
       expenditure_org,
       pfc_deductions_amount,
       pfc_proc_ded_amount
FROM   apps.pa_deduction_summary_base_v
WHERE  project_id = :p_project_id
ORDER BY task_number, expenditure_type;

A second common pattern aggregates at project level to compare total deductions against processed deductions:

SELECT project_id,
       SUM(pfc_deductions_amount) total_ded,
       SUM(pfc_proc_ded_amount)  processed_ded
FROM   apps.pa_deduction_summary_base_v
GROUP BY project_id;

Because the view references organization and task tables, queries should be run with appropriate MO security and organization access to ensure rows are not inadvertently restricted or exposed.