Search Results pa_mc_cc_dist_lines_ar




Overview
Explore in AI Chat

Overview

The PA_MC_CC_DIST_LINES_AR table is a Projects (PA) module table in Oracle E-Business Suite 12.1.1 and 12.2.2. The "_AR" suffix conventionally designates an archive or staging companion to the primary distribution lines table, and its presence in the documented schema—owned by the PA schema and marked VALID—confirms it as a persistent archive structure used during the multi-currency cost collection and purge lifecycle. In practice, this table stores Cost Collection distribution line records that have been selected for archival prior to purging from the active PA_CC_DIST_LINES_ALL table. It captures the accounting-relevant attributes required to reconstruct cost distribution for general ledger transfer, audit, and reconciliation purposes.

From a Data Vault modeling perspective, the metadata classifies this object heuristically as standalone. That is a modeling suggestion rather than a physical constraint: the table carries foreign keys to parent purge batch, cost collection distribution, and expenditure item records, and includes a composite unique index that behaves as a business key. A practitioner modeling this source might therefore treat it as a satellite attached to a cost-collection distribution hub, with the purge batch acting as an additional contextual link.

Key Information Stored

The table comprises 22 documented columns. The most significant are:

The surrogate primary key is not separately documented; the business key is the composite unique index above.

Common Use Cases and Queries

Typical uses include auditing purged cost distributions, reconstructing historical GL transfers, and reporting archived expenditure by project.

SELECT a.cc_dist_line_id, a.set_of_books_id, a.amount,
       a.acct_currency_code, a.transfer_status_code
FROM   pa.pa_mc_cc_dist_lines_ar a
WHERE  a.purge_batch_id = :p_purge_batch_id;

Reconciliation against the active source uses the shared key:

SELECT ar.cc_dist_line_id, ar.amount archived_amount,
       act.amount active_amount
FROM   pa.pa_mc_cc_dist_lines_ar ar,
       pa.pa_cc_dist_lines_all  act
WHERE  ar.cc_dist_line_id  = act.cc_dist_line_id
AND    ar.set_of_books_id  = act.set_of_books_id;

Related Objects

  • PA_PURGE_BATCHES_ALL — joined on PURGE_BATCH_ID; defines the purge run.
  • PA_CC_DIST_LINES_ALL — joined on CC_DIST_LINE_ID; the active distribution line.
  • PA_EXPENDITURE_ITEMS_ALL — joined on EXPENDITURE_ITEM_ID; the source expenditure.
  • PA_MC_CC_DIST_LINES_ALL — the active multi-currency counterpart typically purged alongside this table.
  • GL_JE_BATCHES / GL_JE_HEADERS — referenced via GL_BATCH_NAME for posted journals.
  • PA_ACCOUNTING_EVENTS / PA_COST_DIST_OL — upstream accounting and cost distribution sources.