Search Results pa_mc_cc_dist_lines_u2

Overview

PA.PA_MC_CC_DIST_LINES_ALL is a Multi-Reporting Currency (MRC) sub-table of PA_CC_DIST_LINES_ALL in Oracle E-Business Suite, owned by the Projects (PA) schema with FND Design Data registered as PA.PA_MC_CC_DIST_LINES_ALL. Its status is VALID in both 12.1.1 and 12.2.2. The table stores currency-related information about cost distribution lines for each reporting set of books associated with a parent record on PA_CC_DIST_LINES_ALL. It exists specifically to hold the MRC-denominated view of cross charge distribution activity, allowing a single cross charge transaction to be represented across multiple reporting sets of books without duplicating the underlying transaction in the primary ledger table.

From a dimensional modeling perspective, the mined metadata suggests this object behaves as a link table: it resolves relationships between reporting sets of books, project reporting assignments, cross charge distribution lines, and expenditure items, carrying descriptive and measurable attributes (amount, currency, transfer status) rather than serving as a standalone hub. It is physically stored in the APPS_TS_TX_DATA tablespace with PCTFREE 10, and its indexes reside in APPS_TS_TX_IDX in a normal (non-partitioned) B-tree layout.

Key Information Stored

The declared primary key is PA_MC_CC_DIST_LINES_PK on (SET_OF_BOOKS_ID, PRC_ASSIGNMENT_ID, CC_DIST_LINE_ID), though two unique indexes are documented as business-key candidates: PA_MC_CC_DIST_LINES_U1 (CC_DIST_LINE_ID, SET_OF_BOOKS_ID) — the index the user searched for — and PA_MC_CC_DIST_LINES_U2 (EXPENDITURE_ITEM_ID, LINE_NUM, SET_OF_BOOKS_ID, LINE_TYPE).

• SET_OF_BOOKS_ID — the reporting set of books unique identifier (FK to GL_SETS_OF_BOOKS_11I).
• PRC_ASSIGNMENT_ID — the assignment identifier for the project reporting currency.
• CC_DIST_LINE_ID — the system-generated number uniquely identifying the cross charge distribution (FK to PA_CC_DIST_LINES_ALL).
• EXPENDITURE_ITEM_ID — the expenditure item to which the cross charge distribution belongs (FK to PA_EXPENDITURE_ITEMS_ALL).
• LINE_NUM — sequential line number identifying the distribution line within an expenditure item.
• LINE_TYPE — the type of cross charge distribution line, such as Borrowed or Lent.
• ACCT_CURRENCY_CODE — functional currency of the reporting set of books (FK to FND_CURRENCIES).
• AMOUNT — the amount to be posted to GL in that functional currency.
• ACCT_TP_RATE_TYPE / ACCT_TP_RATE_DATE / ACCT_TP_EXCHANGE_RATE — the rate type (FK to GL_DAILY_CONVERSION_TYPES), rate date, and exchange rate used for conversion.
• TRANSFER_STATUS_CODE / TRANSFER_REJECTION_CODE / TRANSFERRED_DATE — the currency transfer state of the line to GL.
• REQUEST_ID — the concurrent request that last processed the item, indexed by the non-unique index PA_MC_CC_DIST_LINES_N1 together with TRANSFER_STATUS_CODE.
• GL_BATCH_NAME / XLA_MIGRATED_FLAG — the GL batch identifier and the flag indicating migration to the Subledger Accounting (XLA) model.
• PROGRAM_ID, PROGRAM_APPLICATION_ID, PROGRAM_UPDATE_DATE — standard Who columns.

Common Use Cases and Queries

The most frequent use is reconciling cross charge cost distributions across multiple reporting sets of books and confirming what was transferred to General Ledger. A typical query filtering on the searched index columns:

SELECT cc.SET_OF_BOOKS_ID, cc.CC_DIST_LINE_ID, cc.EXPENDITURE_ITEM_ID,
       cc.LINE_TYPE, cc.ACCT_CURRENCY_CODE, cc.AMOUNT,
       cc.TRANSFER_STATUS_CODE, cc.TRANSFERRED_DATE, cc.GL_BATCH_NAME
FROM   PA.PA_MC_CC_DIST_LINES_ALL cc
WHERE  cc.CC_DIST_LINE_ID = :p_dist_line_id
AND    cc.SET_OF_BOOKS_ID = :p_sob_id;

A second pattern is finding pending or rejected transfers via PA_MC_CC_DIST_LINES_N1 by REQUEST_ID and TRANSFER_STATUS_CODE. Analysts also join back to the parent PA_CC_DIST_LINES_ALL to compare primary-ledger amounts against each reporting book's converted AMOUNT, and join to PA_EXPENDITURE_ITEMS_ALL for expenditure detail. Because the table is MRC-specific, conversion-rate review by ACCT_TP_RATE_TYPE and ACCT_TP_RATE_DATE supports audit and revaluation reporting.

Related Objects

• PA.PA_CC_DIST_LINES_ALL — parent table; join on CC_DIST_LINE_ID.
• PA.PA_MC_CC_DIST_LINES_PK / _U1 / _U2 / _N1 — the primary key and supporting indexes on the table.
• PA.PA_EXPENDITURE_ITEMS_ALL — join on EXPENDITURE_ITEM_ID.
• GL.GL_SETS_OF_BOOKS_11I — join on SET_OF_BOOKS_ID.
• FND.FND_CURRENCIES — join on ACCT_CURRENCY_CODE.
• GL.GL_DAILY_CONVERSION_TYPES — join on ACCT_TP_RATE_TYPE.
• GL.GL_JE_BATCHES / XLA interfaces — referenced indirectly via GL_BATCH_NAME and XLA_MIGRATED_FLAG for transfer tracking.