Search Results pa_cost_dist_lines_all_mrc_v2

Overview

PA_COST_DIST_LINES_ALL_MRC_V2 is a Projects (PA) module view in Oracle EBS 12.1.1 and 12.2.2 that exposes multi-reporting-currency (MRC) cost distribution lines. Per the ETRM metadata, this object is formally described as a "Multi-org, single currency view." This description reflects its design intent: it is one member of the family of MRC-related views generated by Oracle's Multiple Reporting Currencies architecture, in which a base transactional table is mirrored for each additional reporting currency set defined at the ledger level. The "_V2" suffix indicates a versioned variant of the view, typically introduced to align the view definition with later table structures or to expose additional columns.

The view is used primarily for reporting and enquiry against project cost distribution data expressed in a reporting currency, rather than the functional currency of the operating unit. It joins MRC-specific distribution columns (prefixed MC.) with the primary cost distribution columns (prefixed PA.), producing a consolidated projection that supports cross-currency cost analysis without requiring the caller to join the MRC shadow table manually.

Underlying Base Objects

The ETRM record states that this view is "Not implemented in this database" and documents no referenced base objects. The view text, however, shows a clear join pattern between two logical sources: an MRC side aliased MC and a primary Projects cost distribution side aliased PA. Column naming conventions strongly indicate that PA corresponds to PA_COST_DIST_LINES_ALL (or its transactional counterpart, PA_COST_DISTRIBUTIONS_ALL / EXPENDITURE_ITEMS_ALL lineage), while MC corresponds to the MRC-enabled variant of the same distribution table for a reporting currency. The two are correlated on expenditure item identity and line number, with the MRC side supplying currency, conversion and transfer attributes and the primary side supplying cost, burden, code combination and period attributes.

Because the ETRM documentation records no base objects, DBAs should confirm the actual underlying objects in their instance by querying DBA_VIEWS / DBA_DEPENDENCIES, as view composition can differ between 12.1.1 and 12.2.2 and depends on whether MRC is enabled for the operating unit's ledger.

Key Columns

• MC.EXPENDITURE_ITEM_ID, MC.LINE_NUM — Identifiers linking the MRC row back to the expenditure item and distribution line.
• MC.TRANSFER_STATUS_CODE, MC.TRANSFERRED_DATE, MC.TRANSFER_REJECTION_REASON — Status of the transfer of the MRC distribution line to the reporting-currency GL.
• MC.CURRENCY_CODE, MC.CONVERSION_DATE, MC.RATE_TYPE, MC.EXCHANGE_RATE, MC.AMOUNT, MC.BURDENED_COST — Reporting-currency amounts and the conversion attributes used to derive them.
• PA.AMOUNT, PA.BURDENED_COST, PA.QUANTITY — Functional-currency cost, burdened cost and quantity of the distribution line.
• PA.ORG_ID, PA.PROJECT_ID, PA.TASK_ID — Multi-org partitioning and project/task context.
• PA.DR_CODE_COMBINATION_ID, PA.CR_CODE_COMBINATION_ID, PA.CODE_COMBINATION_ID — Accounting flexfield references for debit, credit and transfer lines.
• PA.GL_DATE, PA.PA_DATE, PA.GL_PERIOD_NAME, PA.PA_PERIOD_NAME — Accounting and project accounting dates and periods.
• PA.PROJECT_CURRENCY_CODE, PA.PROJECT_EXCHANGE_RATE, PA.PROJFUNC_CURRENCY_CODE, PA.PROJFUNC_COST_EXCHANGE_RATE — Project and project functional currency conversion attributes.
• PA.PROJECT_RAW_COST, PA.PROJECT_BURDENED_COST, PA.DENOM_RAW_COST, PA.DENOM_BURDENED_COST — Cost values expressed in project, denominated and functional currencies.
• PA.ACCT_EVENT_..., PA.PRC_GENERATED_FLAG, PA.UTIL_SUMMARIZED_FLAG, PA.PJI_SUMMARIZED_FLAG — Processing and summarization flags used by downstream cost, utilisation and Project Intelligence interfaces.

Common Use Cases and Queries

Typical uses include reconciling functional and reporting currency cost distributions, investigating rejected MRC transfers, and feeding custom reporting or reconciliation extracts where the reporting-currency view is required.

Sample query to list MRC distribution lines for a project:

• SELECT expenditure_item_id, line_num, currency_code, amount, burdened_cost, transfer_status_code, gl_date, pa_period_name FROM pa_cost_dist_lines_all_mrc_v2 WHERE project_id = :project_id;

Sample query to identify rejected transfers in a reporting currency:

• SELECT expenditure_item_id, line_num, currency_code, transfer_rejection_reason, transferred_date FROM pa_cost_dist_lines_all_mrc_v2 WHERE transfer_status_code = 'R' AND org_id = :org_id;

Because the view is documented as not implemented in the reference database, availability and column presence should be validated against the target instance before use in concurrent programs, OBIEE extracts or integrations.