Search Results system_reference4




Overview
Explore in AI Chat

Overview

PA_COST_DISTRIBUTION_LINES is a Projects (PA) module view in Oracle E-Business Suite 12.1.1 and 12.2.2 that exposes the distribution-level detail of project expenditures. It is the publicly accessible synonym wrapper over the multiorganization base table PA_COST_DISTRIBUTION_LINES_ALL, applying the standard operating-unit (ORG_ID) security predicate derived from USERENV('CLIENT_INFO'). The view is defined as a query over that base table rather than as an independent database object, and ETRM documentation notes that it is not implemented as a standalone DBA object.

Within the Cost Distribution and Interface processes, the view represents individual accounting distribution lines generated from project expenditure items. Each row carries the debit and credit code combinations, amounts in multiple currencies, transfer status, dates, and the descriptive flexfield references needed for downstream subledger accounting. It is the principal source for reporting on which accounts project cost was distributed to, in which GL period, and whether the transfer to General Ledger or Payables has occurred.

Underlying Base Objects

The view selects from PA_COST_DISTRIBUTION_LINES_ALL, filtered by the ORG_ID predicate:

Because the view includes the ORG_ID security filter, only rows belonging to the operating unit in the session's client information are visible. Reports running under a specific responsibility therefore see only that business unit's distribution lines, which is the intended behavior for EBS's multi-org architecture.

Key Columns

The column referenced in the search, DR_CODE_COMBINATION_ID, is the debit code combination identifier pointing to the GL chart of accounts entry to be debited. It is paired with CR_CODE_COMBINATION_ID for the corresponding credit account. These are the central accounting columns and are the most commonly queried attributes for reconciliation between Projects and GL.

Common Use Cases and Queries

Typical usage includes reconciling distributed project cost to GL, auditing unposted or rejected distributions, and reviewing account assignments by expenditure item.

  • Retrieve debit accounts for a given expenditure item: SELECT EXPENDITURE_ITEM_ID, DR_CODE_COMBINATION_ID, CR_CODE_COMBINATION_ID, AMOUNT, GL_DATE FROM PA_COST_DISTRIBUTION_LINES WHERE EXPENDITURE_ITEM_ID = :item_id;
  • List lines pending transfer or rejected: SELECT * FROM PA_COST_DISTRIBUTION_LINES WHERE TRANSFER_STATUS_CODE IN ('P','R') ORDER BY GL_DATE;
  • Summarize distributed cost by period and account: SELECT GL_PERIOD_NAME, DR_CODE_COMBINATION_ID, SUM(AMOUNT) FROM PA_COST_DISTRIBUTION_LINES GROUP BY GL_PERIOD_NAME, DR_CODE_COMBINATION_ID;
  • Report individual distributions for a project: SELECT PROJECT_ID, TASK_ID, AMOUNT, DR_CODE_COMBINATION_ID FROM PA_COST_DISTRIBUTION_LINES WHERE PROJECT_ID = :project_id;

Because ORG_ID filtering is applied automatically, queries executed from a Projects responsibility return only the operating unit's data; cross-organization reporting should be performed against PA_COST_DISTRIBUTION_LINES_ALL with appropriate privileges.