Search Results pa_accum_column_values_v




Overview
Explore in AI Chat

Overview

PA_ACCUM_COLUMN_VALUES_V is a Projects (PA) module view owned by the APPS schema in Oracle E-Business Suite. Its documented description is "10Sc Only," indicating that the view was introduced to support functionality specific to Oracle Projects 10Sc (a formerly distinct costing/accumulation product line that was later folded into the core Oracle Projects application). The view presents the configured accumulation column values that Oracle Projects uses to control how expenditure, burden, and cost accumulation are grouped, labeled, and flagged for reporting purposes.

In EBS 12.1.1 and 12.2.2, the view remains available and VALID in the APPS schema. It is generally classified as a reporting and reference view rather than a transactional one. Its primary role is to expose the relationship between project type classification, accumulation column definitions, accumulation categories, and the lookup meanings that drive user-facing display of accumulation columns. Because it joins configuration tables rather than transaction tables, it is typically used in reporting, data validation, and interface development scenarios.

Underlying Base Objects

The view is defined over three documented base objects:

The join conditions are documented as: PA_ACCUM_COLUMNS.COLUMN_ID = PA_ACCUM_COLUMN_VALUES.COLUMN_ID, and PA_ACCUM_COLUMNS.ACCUM_COLUMN_CODE = PA_LOOKUPS.LOOKUP_CODE with PA_LOOKUPS.LOOKUP_TYPE constrained to 'ACCUMULATION_COLUMN'. The view text is a simple three-table equijoin with no aggregation or outer joins.

Key Columns

  • PROJECT_TYPE_CLASS_CODE — the project type class to which the accumulation column configuration applies, allowing different accumulation behavior per project classification.
  • COLUMN_ID — the surrogate primary key linking PA_ACCUM_COLUMNS to PA_ACCUM_COLUMN_VALUES.
  • ACCUM_CATEGORY_CODE — the accumulation category grouping the column belongs to.
  • ACCUM_COLUMN_CODE — the code identifying the accumulation column; also the lookup code resolved through PA_LOOKUPS.
  • ACCUM_COLUMN_M — the lookup MEANING (user-facing display name) for the accumulation column code.
  • COLUMN_VALUE — the configured value stored for the column.
  • ACCUM_FLAG — a flag indicating the accumulation setting or state for the column.

Note that the view text aliases PA_LOOKUPS.MEANING as the column meaning, while the documented column list labels it ACCUM_COLUMN_M.

Common Use Cases and Queries

Typical uses include reporting on accumulation column configuration by project type class, validating that accumulation column codes have matching lookup meanings, and building interfaces that must resolve accumulation column codes to display values.

Sample query listing accumulation columns with their meanings:

SELECT v.project_type_class_code,
       v.accum_category_code,
       v.accum_column_code,
       v.accum_column_m,
       v.column_value,
       v.accum_flag
FROM   apps.pa_accum_column_values_v v
WHERE  v.project_type_class_code = :p_type_class
ORDER BY v.accum_category_code, v.accum_column_code;

Sample query filtering by a specific accumulation column code:

SELECT v.column_id, v.project_type_class_code, v.column_value
FROM   apps.pa_accum_column_values_v v
WHERE  v.accum_column_code = :p_accum_column_code;

Because the view depends on configuration tables and the PA_LOOKUPS view, queries should be executed with APPS or an appropriately privileged reporting responsibility. Given its "10Sc Only" designation, it is primarily relevant where legacy 10Sc-derived accumulation configuration is still referenced within the EBS 12.1.1 or 12.2.2 instance.