Search Results pa_mc_cost_dist_lines_all




Overview
Explore in AI Chat

Overview

PA_MC_COST_DIST_LINES_ALL is a Projects (PA) module table in Oracle E-Business Suite 12.1.1 and 12.2.2 that stores the multi-currency cost distribution detail for expenditure items. Its documented description states that it holds "information about the cost distribution of expenditure items for each reporting set of books." This makes the table the mechanism by which a single expenditure item can be distributed across multiple reporting set of books, with each row representing one distribution line within a given set of books.

From a Data Vault modeling perspective, the FK structure suggests this object behaves as a link. It resolves and connects several reference dimensions — set of books (GL_SETS_OF_BOOKS_11I), expenditure items (PA_EXPENDITURE_ITEMS_ALL), cost distribution lines (PA_COST_DISTRIBUTION_LINES_ALL), currencies (FND_CURRENCIES), and conversion rates (GL_DAILY_CONVERSION_TYPES) — through foreign key relationships rather than acting as a standalone hub or descriptive satellite. The table is owned by the PA schema and is documented with 21 columns. It is important not to confuse PA_MC_COST_DIST_LINES_ALL with PA_COST_DISTRIBUTION_LINES_ALL; the "MC" designator indicates the multi-currency, multi-set-of-books view of cost distribution, not the baseline distribution itself.

Key Information Stored

The table defines its primary key as PA_MC_COST_DIST_LINES_ALL_PK, comprising SET_OF_BOOKS_ID, EXPENDITURE_ITEM_ID, and LINE_NUM. A separate unique index, PA_MC_COST_DIST_LINES_ALL_U1, covers EXPENDITURE_ITEM_ID, LINE_NUM, and SET_OF_BOOKS_ID, which represents the business-key candidate. The surrogate/primary key in effect is composite: it requires the set of books context in addition to the expenditure item and line, whereas the unique index presents the same attributes in a different column order.

  • SET_OF_BOOKS_ID — identifies the reporting set of books for the distribution line; part of the primary key.
  • EXPENDITURE_ITEM_ID — the expenditure item being distributed; part of the primary key and a FK to PA_EXPENDITURE_ITEMS_ALL.
  • LINE_NUM — the distribution line number; part of the primary key and a FK to PA_COST_DISTRIBUTION_LINES_ALL.
  • LINE_TYPE — classifies the nature of the distribution line.
  • TRANSFER_STATUS_CODE — indicates whether the line has been transferred, typically to GL.
  • AMOUNT — the distributed cost amount for the line.
  • QUANTITY — the quantity associated with the distribution.
  • BURDENED_COST — the burdened cost component of the distributed amount.
  • CURRENCY_CODE — the currency of the distribution; FK to FND_CURRENCIES.
  • EXCHANGE_RATE and CONVERSION_DATE — the rate applied and the date used for currency conversion.
  • RATE_TYPE — the daily conversion rate type; FK to GL_DAILY_CONVERSION_TYPES.
  • PRC_ASSIGNMENT_ID — reference to the associated project cost assignment.
  • REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, and PROGRAM_UPDATE_DATE — the standard concurrent program audit columns identifying the process that created or last updated the row.
  • TRANSFERRED_DATE, TRANSFER_REJECTION_REASON, and BATCH_NAME — transfer tracking information.
  • XLA_MIGRATED_FLAG — flags migration into the Subledger Accounting (XLA) model.

Common Use Cases and Queries

Typical scenarios include reconciling multi-currency cost distribution back to expenditure items, auditing which lines have been transferred or rejected, querying converted amounts for a reporting set of books, and reporting burdened versus raw cost by currency. A representative pattern retrieves all distribution lines for a given expenditure item within a set of books:

  • SELECT mc.LINE_NUM, mc.LINE_TYPE, mc.AMOUNT, mc.BURDENED_COST, mc.CURRENCY_CODE, mc.EXCHANGE_RATE, mc.TRANSFER_STATUS_CODE FROM PA.PA_MC_COST_DIST_LINES_ALL mc WHERE mc.EXPENDITURE_ITEM_ID = :expenditure_item_id AND mc.SET_OF_BOOKS_ID = :set_of_books_id ORDER BY mc.LINE_NUM;
  • Joining to PA_EXPENDITURE_ITEMS_ALL on EXPENDITURE_ITEM_ID to obtain item context, and to GL_SETS_OF_BOOKS_11I on SET_OF_BOOKS_ID to resolve the ledger/book name.
  • Filtering on TRANSFER_REJECTION_REASON IS NOT NULL to identify lines that failed transfer to the general ledger.
  • Aggregating AMOUNT by CURRENCY_CODE and SET_OF_BOOKS_ID to produce multi-currency distribution summaries.
  • Checking XLA_MIGRATED_FLAG to distinguish migrated versus non-migrated accounting records.

Related Objects

The documented foreign keys anchor this table to the following significant objects:

  • PA_EXPENDITURE_ITEMS_ALL — joined on EXPENDITURE_ITEM_ID; the parent expenditure item for the distribution.
  • PA_COST_DISTRIBUTION_LINES_ALL — joined on LINE_NUM (with EXPENDITURE_ITEM_ID); the baseline distribution lines.
  • GL_SETS_OF_BOOKS_11I — joined on SET_OF_BOOKS_ID; the reporting set of books.
  • FND_CURRENCIES — joined on CURRENCY_CODE; validates the distribution currency.
  • GL_DAILY_CONVERSION_TYPES — joined on RATE_TYPE; supplies the conversion rate type used for currency translation.

These relationships, together with the primary key and unique index, define the principal join paths used when integrating multi-currency cost distribution data with expenditure, cost distribution, currency, and conversion-rate data across EBS Projects.