Search Results accum_column_code

Overview

PA_ACCUM_COLUMNS_V is an APPS-owned view in the Oracle E-Business Suite Projects (PA) module. The ETRM metadata classifies this object with the description "10Sc Only," indicating that the view is a legacy construct retained for backward compatibility and originally introduced to support accumulation column configuration in earlier Oracle Projects releases. In Oracle EBS 12.1.1 and 12.2.2 the view remains VALID in the APPS schema, but it is not part of the primary functional data model for current Projects reporting.

The view exposes the relationship between project type class codes and the accumulation columns that govern how project amounts are summarized by category and column. Because it joins a Projects lookup source to resolve a user-facing meaning for each accumulation column code, the view is best understood as a configuration/reference view rather than a transactional reporting view. Reporting and integration developers searching for "accum_column_code" encounter this view when tracing how accumulation categories and columns are defined and labeled within Oracle Projects.

Underlying Base Objects

The documented definition of the view references two base objects:

• PA_ACCUM_COLUMNS (documented as a SYNONYM in the ETRM metadata) — the driving table supplying the accumulation configuration rows, including project type class code, column identifier, category code, accumulation column code, and the accumulation flag.
• PA_LOOKUPS (a VIEW) — the lookup source used to resolve the descriptive meaning of each accumulation column code from the seeded lookup type ACCUMULATION_COLUMN.

The join condition is A.ACCUM_COLUMN_CODE = B.LOOKUP_CODE with B.LOOKUP_TYPE = 'ACCUMULATION_COLUMN'. The view also selects A.ROWID, a common Oracle Projects pattern used for row identification and downstream update processing. A notable inconsistency in the documented output is that the column list includes both ACCUM_COLUMN_CODE and ACCUM_COLUMN_M, while the view text selects only ACCUM_COLUMN_CODE; this discrepancy is characteristic of legacy metadata and should be verified against the live database definition before use.

Key Columns

• ROW_ID — the ROWID of the underlying PA_ACCUM_COLUMNS row, used for unique identification.
• PROJECT_TYPE_CLASS_CODE — the project type class the accumulation configuration applies to.
• COLUMN_ID — identifier of the accumulation column.
• ACCUM_CATEGORY_CODE — the accumulation category associated with the column.
• ACCUM_COLUMN_CODE — the key column referenced in the join to PA_LOOKUPS; this is the value most commonly queried by developers.
• ACCUM_FLAG — flag indicating whether accumulation is enabled for the configuration row.
• MEANING — the translatable descriptive text for the accumulation column code, sourced from PA_LOOKUPS.

Common Use Cases and Queries

Typical usage involves confirming valid accumulation column codes, mapping codes to descriptive meanings, and inspecting the accumulation configuration applicable to a project type class.

• Retrieve all configured accumulation columns with their meanings:

SELECT accum_column_code, meaning, accum_flag
FROM   apps.pa_accum_columns_v
ORDER BY accum_column_code;

• Restrict to a specific project type class:

SELECT project_type_class_code, accum_column_code, meaning
FROM   apps.pa_accum_columns_v
WHERE  project_type_class_code = :p_class_code;

Because the metadata designates this view as "10Sc Only," implementations on 12.1.1 and 12.2.2 should treat it as a compatibility artifact. New development should prefer the underlying current Projects tables and lookup mechanisms, while using this view only to interpret legacy accumulation column configuration.