Search Results accumulation_column




Overview
Explore in AI Chat

Overview

APPS.PA_ACCUM_COLUMNS_V is an Oracle E-Business Suite view in the Projects (PA) application that exposes the definition of accumulation columns used by Project Resource Management and project accounting processes. Accumulation columns determine which transaction measures — raw cost, burdened cost, quantity, revenue, and similar amounts — are captured, stored, and summarized for a given project type class. The view joins the configuration table PA_ACCUM_COLUMNS against the lookup view PA_LOOKUPS so that each accumulation column code is presented together with its user-facing lookup meaning.

Because the view carries the ROWID of the underlying PA_ACCUM_COLUMNS row and only published, translated attributes, it serves as the canonical read-only interface for both reporting (Oracle Reports, Oracle BI Publisher, Discoverer, OBIEE) and integration/extension code. Developers needing to check which accumulation columns are enabled for a project type class — for example, before writing custom cost distribution or summarization logic — query this view rather than the base table directly.

Underlying Base Objects

  • PA_ACCUM_COLUMNS (referenced via a SYNONYM in the APPS schema) — the driving table holding one row per accumulation column definition, including the project type class, column identifier, accumulation category, accumulation column code, and the accumulation flag.
  • PA_LOOKUPS (referenced via a VIEW) — the lookup repository supplying the translated MEANING for each accumulation column code where LOOKUP_TYPE = 'ACCUMULATION_COLUMN'.

The join is an equi-join between A.ACCUM_COLUMN_CODE and B.LOOKUP_CODE restricted to the accumulation column lookup type, producing a denormalized, human-readable projection of the accumulation column configuration.

Key Columns

  • ROWID — the row identifier of the parent row in PA_ACCUM_COLUMNS; useful for precise updates or reference in custom PL/SQL.
  • PROJECT_TYPE_CLASS_CODE — the project type class to which the accumulation column applies, scoping configuration by project classification.
  • COLUMN_ID — the internal identifier linking the accumulation column to its defined storage position/semantics.
  • ACCUM_CATEGORY_CODE — the category grouping the accumulation column (for example, cost, revenue, or quantity categories).
  • ACCUM_COLUMN_CODE — the code of the accumulation column; this is the value matched to the lookup code.
  • MEANING — the translated display name for the accumulation column, sourced from PA_LOOKUPS, suitable for user-facing reports.
  • ACCUM_FLAG — indicates whether accumulation for that column is active/enabled for the given definition.

Common Use Cases and Queries

Typical uses include validating accumulation configuration per project type class, generating reference listings for implementation documentation, and driving conditional logic in extensions that must know whether a given accumulation column is enabled. A representative query listing all accumulation columns and their meanings is:

  • SELECT accum_column_code, meaning, project_type_class_code, accum_category_code, accum_flag FROM apps.pa_accum_columns_v ORDER BY project_type_class_code, accum_category_code;
  • SELECT meaning, accum_flag FROM apps.pa_accum_columns_v WHERE project_type_class_code = :p_type_class AND accum_category_code = :p_category;
  • SELECT column_id, accum_column_code, meaning FROM apps.pa_accum_columns_v WHERE accum_flag = 'Y' AND accum_column_code = :p_column_code;

Because the view embeds a ROWID and joins to PA_LOOKUPS, it is best treated as read-only. Configuration changes should be made through the supported Projects setup forms or the base PA_ACCUM_COLUMNS table, after which this view reflects the updated accumulation column definitions.