Search Results prev_ind_compiled_set_id




Overview
Explore in AI Chat

Overview

PA.PA_COST_DIST_LINES_AR is the archive/purge companion table to PA_COST_DIST_LINES_ALL, the core distribution-line store in the Oracle Projects (PA) module. Every row that has been extracted from the live table during an archive or purge run is written here, preserving the full cost distribution audit trail for the project, task, expenditure item, and GL account combinations involved. Because columns are duplicated verbatim from the main table, Oracle's documented guidance is to treat column-level semantics as identical to those of PA_COST_DIST_LINES_ALL; this object exists principally for retention and to allow reclaimed space in the primary table without permanently losing distribution history.

The table participates directly in the purge architecture through PURGE_BATCH_ID and PURGE_RELEASE, which associate each archived row with the PA_PURGE_BATCHES_ALL run that produced it. The documented foreign keys confirm this link and also tie archived lines back to the originating expenditure item, the organization labor schedule rule, and the GL encumbrance type. In a heuristic Data Vault sense, the table is classified as satellite-leaning: it carries descriptive, versioned attributes about a parent business entity (the expenditure/ cost distribution) rather than acting as the hub or link itself. Practitioners modeling this structure should treat the expenditure item or distribution identity as the hub and the archived detail columns as satellite attributes loaded per purge batch.

Key Information Stored

The documented schema exposes 88 columns. The most significant, grouped by function, are:

Common Use Cases and Queries

Typical usage centers on retention reporting, purge validation, and reconciliation of archived distributions to GL. A common pattern retrieves all archived lines for a given purge run:

  • SELECT * FROM pa.pa_cost_dist_lines_ar WHERE purge_batch_id = :batch_id ORDER BY project_id, expenditure_item_id, line_num;
  • SELECT project_id, SUM(project_burdened_cost) FROM pa.pa_cost_dist_lines_ar WHERE purge_release = :release GROUP BY project_id;
  • Joining to PA_PURGE_BATCHES_ALL to time-stamp archive activity, and to PA_EXPENDITURE_ITEMS_ALL (where rows still exist) to reconcile archived amounts against surviving live data.
  • Currency and COST-rate auditing across account, project, and denominated buckets, or encumbrance transfer rejection analysis using ENCUM_TRANSFER_REJ_REASON and BURDEN_SUM_REJECTION_CODE.

Related Objects

  • PA_COST_DIST_LINES_ALL — the live source table from which archived rows originate.
  • PA_PURGE_BATCHES_ALL — joined via PURGE_BATCH_ID; identifies archive runs.
  • PA_EXPENDITURE_ITEMS_ALL — referenced via EXPENDITURE_ITEM_ID.
  • PA_ORG_LABOR_SCH_RULE — referenced via ORG_LABOR_SCH_RULE_ID.
  • GL_ENCUMBRANCE_TYPES — referenced via ENCUMBRANCE_TYPE_ID.
  • PA_PURGE_BATCHES and PA purge concurrent programs — orchestrate population of this table.
  • Project costing APIs (e.g., PA_COST_DISTRIBUTION / PA_PURGE logic) and GL transfer processes that reference the corresponding live distribution table for accounting entries.