Search Results pa_mc_exp_items_all




Overview
Explore in AI Chat

Overview

PA_MC_EXP_ITEMS_ALL is a multi-currency expenditure table within the Oracle Projects (PA) module. It stores the smallest expenditure units charged to projects and tasks, expressed in each reporting currency defined for a set of books. The "_ALL" suffix indicates that the table is partitioned by org_id or, more typically in Oracle Projects, holds data across multiple sets of books rather than being filtered by a single operating unit.

This table functions as the multi-currency companion to PA_EXPENDITURE_ITEMS_ALL. While PA_EXPENDITURE_ITEMS_ALL holds the transactional detail in the functional currency, PA_MC_EXP_ITEMS_ALL carries project-functional and reporting currency amounts, conversion rates, and rate types required for revenue recognition, forecasting, and intercompany transfer pricing. Referenced by the foreign keys, the table accommodates three distinct currency conversion contexts: cost, revenue, and project-functional (ProjFunc) invoicing and forecasting.

Under a heuristic Data Vault classification derived from the FK structure, this map is best modeled as a link entity. It resolves the many-to-many relationship between expenditure items and reporting currency contexts, keyed by the composite of SET_OF_BOOKS_ID and EXPENDITURE_ITEM_ID, while carrying descriptive rate and amount attributes that behave as link satellites.

Key Information Stored

The composite business key consists of SET_OF_BOOKS_ID and EXPENDITURE_ITEM_ID, enforced by the unique index PA_MC_EXPENDITURE_ITEMS_U1 and the primary key PA_MC_EXP_ITEMS_ALL_PK. The most significant columns include:

Common Use Cases and Queries

PA_MC_EXP_ITEMS_ALL is queried primarily for multi-currency reporting, revenue and cost reconciliation, and transfer pricing analysis. Typical use cases include reconciling a project's cost and revenue in a reporting currency versus the functional currency, and auditing conversion rates applied to specific expenditure items.

A common pattern joins this table to PA_EXPENDITURE_ITEMS_ALL to obtain transactional context:

  • SELECT m.EXPENDITURE_ITEM_ID, m.CURRENCY_CODE, m.RAW_COST, m.RAW_REVENUE FROM PA_MC_EXP_ITEMS_ALL m, PA_EXPENDITURE_ITEMS_ALL e WHERE m.EXPENDITURE_ITEM_ID = e.EXPENDITURE_ITEM_ID AND m.SET_OF_BOOKS_ID = :ledger_id
  • Report by currency: GROUP BY m.CURRENCY_CODE, SUM(m.BURDEN_COST), SUM(m.ACCRUED_REVENUE).
  • Conversion audit: filter rows where COST_RATE_TYPE or REVENUE_RATE_TYPE is null or differs from expected daily conversion types in GL_DAILY_CONVERSION_TYPES.

Related Objects

Together these objects support the multi-currency cost, revenue, and transfer pricing flows that define project financial reporting in Oracle EBS 12.1.1 and 12.2.2.