Search Results system_reference5




Overview
Explore in AI Chat

Overview

PA_COST_DISTRIBUTION_LINES_ALL is the core Oracle Projects table that stores the distribution of expenditure item costs across general ledger accounts, projects, tasks, and reporting currencies. Its documented description is "Information about expenditure item cost distribution." Each row represents one cost distribution line for an expenditure item, identifying the debit and credit accounting flexfield combinations, the amounts in denominator, project, project functional, and accounting currencies, and the transfer status to Oracle General Ledger. The table sits at the intersection of Oracle Projects costing and subledger accounting: it is populated during the cost distribution and burdening process and is the source from which project costs are transferred to GL and summarized for capitalization and asset generation.

From a modeling perspective, the FK structure suggests a satellite-leaning classification: the table holds descriptive, mutable attributes (amounts, status codes, dates, flags) that hang off the central EXPENDITURE_ITEM_ID business key rather than acting as a standalone hub or link. The _ALL suffix indicates multi-organization partitioning by ORG_ID, which must be considered in every query.

Key Information Stored

The primary key is PA_COST_DISTRIBUTION_LINES_PK, composed of LINE_NUM and EXPENDITURE_ITEM_ID. A separate unique index, PA_COST_DISTRIBUTION_LINES_U1 (EXPENDITURE_ITEM_ID, LINE_NUM), serves as the business-key candidate, confirming that line number is only unique within an expenditure item.

The most significant columns include:

Common Use Cases and Queries

Typical reporting involves reconciling project costs to GL, auditing untransferred or rejected distributions, and validating burdened versus raw cost amounts.

  • Identify distributions not yet transferred to GL: filter on TRANSFER_STATUS_CODE and null GL_DATE.
  • Reconcile project currency to accounting currency by comparing PROJECT_BURDENED_COST and ACCT_BURDENED_COST.
  • Trace reversed lines using LINE_NUM_REVERSED against the same EXPENDITURE_ITEM_ID.

A representative query pattern:

  • SELECT pcdl.expenditure_item_id, pcdl.line_num, pcdl.acct_burdened_cost, pcdl.transfer_status_code FROM pa_cost_distribution_lines_all pcdl WHERE pcdl.org_id = :org_id AND pcdl.gl_date IS NULL;

These queries are common in period-end close reporting, cost transfer audits, and capital project asset reconciliation.

Related Objects

The following objects are the most significant dependencies based on documented foreign keys: