Search Results accum_column_m




Overview
Explore in AI Chat

Overview

APPS.PA_ACCUM_COLUMN_VALUES_V is a supplementary Oracle EBS view owned by the APPS schema that consolidates accumulation column definitions and their permitted values into a flat, denormalized structure. In Oracle Projects, "accumulation columns" (often abbreviated as "accum columns") define the set of attributes that the Projects Accumulation engine tracks when summarising project transaction data for reporting, capitalisation, and burdening. The column reference ACCUM_COLUMN_M, which the user searched for, is the descriptive name field exposed by this view.

The view is documented at FND Design Data level as PA.PA_ACCUM_COLUMN_VALUES_V and its status is VALID. Its View Type is classified as "A supplementary view used to simplify forms coding," with an explicit Oracle warning that customers should not query or alter data using this view because it may change dramatically in subsequent minor or major releases. This positions the object as an internal form-support mechanism rather than a certified public reporting interface.

Underlying Base Objects

The view is defined over three documented base objects: PA_ACCUM_COLUMNS, PA_ACCUM_COLUMN_VALUES, and PA_LOOKUPS, all accessed through APPS synonyms. PA_ACCUM_COLUMNS stores the master definition of each accumulation column, including its category and code. PA_ACCUM_COLUMN_VALUES stores the discrete values that each accumulation column may take for a given project type class. PA_LOOKUPS supplies the decoded, translated descriptions referenced through the project type class code, keeping the display values consistent with Oracle lookups and multi-language installations. The view performs a straightforward join across these objects and is not referenced by any other database object, confirming it is a leaf-level convenience construct consumed by Oracle Projects forms rather than a dependency of further database logic.

Key Columns

  • PROJECT_TYPE_CLASS_CODE — classifies the project type to which the accumulation column values apply; drives the lookup-based decoding.
  • COLUMN_ID — surrogate identifier for the accumulation column instance.
  • ACCUM_CATEGORY_CODE — the category grouping of the accumulation column.
  • ACCUM_COLUMN_CODE — the short code of the accumulation column.
  • ACCUM_COLUMN_M — the user-facing name of the accumulation column (the "M" suffix denotes the meaning/name field), which is the attribute the user searched for.
  • COLUMN_VALUE — the permitted value assigned to the column for the given type class.
  • ACCUM_FLAG — a control flag indicating whether the accumulation column is active for the row's context.

Common Use Cases and Queries

Because this is a forms-support view, its principal use is reading column-to-value mappings during investigation of accumulation setup, not for production reporting. A typical diagnostic query lists the columns and their names for a given project type class:

SELECT PROJECT_TYPE_CLASS_CODE, ACCUM_CATEGORY_CODE, ACCUM_COLUMN_CODE, ACCUM_COLUMN_M, COLUMN_VALUE FROM APPS.PA_ACCUM_COLUMN_VALUES_V WHERE PROJECT_TYPE_CLASS_CODE = :class_code ORDER BY ACCUM_CATEGORY_CODE, ACCUM_COLUMN_CODE;

A second scenario verifies that a specific accumulation column name exists and is enabled:

SELECT ACCUM_COLUMN_CODE, ACCUM_COLUMN_M, COLUMN_VALUE, ACCUM_FLAG FROM APPS.PA_ACCUM_COLUMN_VALUES_V WHERE ACCUM_COLUMN_M = :name;

For any certified or persistent integration requirement, Oracle recommends querying the underlying PA_ACCUM_COLUMNS and PA_ACCUM_COLUMN_VALUES tables directly, since the view's structure is subject to change between releases.