Search Results pa_accum_columns




Overview
Explore in AI Chat

Overview

PA_ACCUM_COLUMNS is a system-defined configuration table in the Oracle Projects (PA) schema. Its documented purpose is to store the configurable columns used in project summarization — that is, the set of column definitions that drive how Project Accumulation (PA_ACCUM) data is aggregated and presented in summarized project reporting. The table resides in the PA schema, is marked VALID in the ETRM 12.2.2 extract, and carries a documented physical schema of twelve columns. In Oracle EBS 12.1.1 and 12.2.2, this object is most commonly encountered when troubleshooting project summarization behavior, reviewing summarization setup, or building custom reports against the accumulation structure.

From a heuristic Data Vault modeling perspective, the mined relationship data classifies this object as standalone, with no foreign key dependencies on other tables. Where a vault model is layered over the EBS source, PA_ACCUM_COLUMNS is therefore best treated as a reference or lookup-style hub rather than a link or satellite, since it defines configuration values rather than transactional relationships. This is a modeling suggestion derived from the FK structure, not a documented EBS attribute.

Key Information Stored

The primary key is documented as PA_ACCUM_COLUMNS_PK, defined on COLUMN_ID. COLUMN_ID is the surrogate identifier for each accumulation column definition; the composite of ACCUM_CATEGORY_CODE and ACCUM_COLUMN_CODE acts as the natural business-key candidate, since it names the category and column a configuration row describes. The remaining documented columns fall into functional groups:

  • ACCUM_CATEGORY_CODE — the accumulation category to which the column definition belongs.
  • ACCUM_COLUMN_CODE — the column identifier within that category.
  • ACCUM_FLAG — a control flag indicating whether the column participates in accumulation.
  • PROJECT_TYPE_CLASS_CODE — the project type class context in which the column configuration applies.
  • DESCRIPTION — the user-facing description of the configurable column.
  • ZD_EDITION_NAME — the editioning column used by Oracle EBS 12.2 online patching (Edition-Based Redefinition).
  • Audit columns — CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, and LAST_UPDATE_LOGIN.

Common Use Cases and Queries

Typical scenarios include determining which columns are active for summarization in a given category, validating setup after an upgrade or patch, and driving summarization reconciliation queries. Because ACCUM_FLAG governs participation, filtering on it is central to most retrievals.

  • List active accumulation columns for a category:
SELECT accum_category_code, accum_column_code, description
FROM   pa_accum_columns
WHERE  accum_flag = 'Y'
ORDER  BY accum_category_code, accum_column_code;
  • Review configuration by project type class:
SELECT column_id, accum_category_code, accum_column_code,
       project_type_class_code, description
FROM   pa_accum_columns
WHERE  project_type_class_code = :p_type_class;
  • Audit recent changes to summarization configuration:
SELECT column_id, accum_column_code,
       last_updated_by, last_update_date
FROM   pa_accum_columns
WHERE  last_update_date >= :since_date;

Related Objects

Although the mined relationship data marks PA_ACCUM_COLUMNS as standalone, it participates logically with the broader Project Accumulation family in the PA schema. The most significant associated objects are:

  • PA_ACCUM_HEADERS — accumulation run headers, joined by category context.
  • PA_ACCUM_LINES — summarized accumulation line data produced for configured columns.
  • PA_PROJECT_TYPES / PA_PROJECT_TYPE_CLASSES — supply PROJECT_TYPE_CLASS_CODE context.
  • PA_PROJECTS — the summarized project entities the configuration serves.
  • PA_SUMMARY_* program and API objects — the summarization processes that consume these column definitions.

Because no explicit foreign keys are documented, joins to these objects should be constructed on the business columns ACCUM_CATEGORY_CODE, ACCUM_COLUMN_CODE, and PROJECT_TYPE_CLASS_CODE rather than on COLUMN_ID.