Search Results pa_mc_draft_invoice_items_u1

Overview

PA.PA_MC_DRAFT_INV_ITEMS is a Multiple Reporting Currencies (MRC) sub-table of PA.PA_DRAFT_INVOICE_ITEMS within the Oracle Projects (PA) schema. It stores currency-related information about draft invoice items for each reporting set of books associated with the parent record on PA_DRAFT_INVOICE_ITEMS. In Oracle E-Business Suite 12.1.1 and 12.2.2, MRC architecture allows a single transaction recorded in the primary set of books to be simultaneously reflected in one or more reporting sets of books, each potentially using a different functional currency. This table carries the reporting-currency equivalents of the amounts held on the parent (primary) record. The object is owned by the PA schema, is registered as VALID, and is stored in the APPS_TS_TX_DATA tablespace with PCT Free 10. Its FND Design Data reference is PA.PA_MC_DRAFT_INV_ITEMS. From a heuristic Data Vault modeling perspective, the metadata classifies this object as a link, reflecting its role as an associative structure connecting reporting set of books context to draft invoice item detail rather than acting as an independent hub of business entities.

Key Information Stored

The table has 12 documented columns and a composite primary key, PA_MC_DRAFT_INV_ITEMS_PK, defined on (SET_OF_BOOKS_ID, PROJECT_ID, DRAFT_INVOICE_NUM, LINE_NUM). A parallel unique index, PA_MC_DRAFT_INVOICE_ITEMS_U1, exists on the same four columns in the APPS_TS_TX_IDX tablespace; because it duplicates the primary key, these columns effectively serve as the business-key candidate for the row. The most significant columns are:

• SET_OF_BOOKS_ID — the reporting set of books unique identifier; the MRC discriminator that distinguishes one reporting currency context from another.
• PROJECT_ID — the identifier of the project for which the invoice is generated.
• DRAFT_INVOICE_NUM — the draft invoice number to which the invoice line belongs.
• LINE_NUM — the sequential number that identifies and orders the draft invoice item within a draft invoice.
• AMOUNT — the amount in the reporting currency to be billed for the draft invoice item.
• UNBILLED_RECEIVABLE_DR — the amount of unbilled receivables in the reporting currency debited by the draft invoice item.
• UNEARNED_REVENUE_CR — the amount of unearned revenue in the reporting currency credited by the draft invoice item.
• CURRENCY_CODE — the currency code associated with the reporting set of books.
• EXCHANGE_RATE, CONVERSION_DATE, and RATE_TYPE — the rate, date, and rate type used to convert the primary set of books amounts into the reporting currency.
• PRC_ASSIGNMENT_ID — documented as reserved for future use.

Common Use Cases and Queries

Typical uses include MRC reconciliation reporting, verifying that reporting-currency draft invoice amounts, unbilled receivable debits, and unearned revenue credits tie back to the primary set of books, and auditing conversion rate and rate type selection. A representative query joins the parent table to retrieve both primary and reporting currency values:

• SELECT m.DRAFT_INVOICE_NUM, m.LINE_NUM, m.SET_OF_BOOKS_ID, m.CURRENCY_CODE, m.AMOUNT, m.EXCHANGE_RATE, m.RATE_TYPE, m.CONVERSION_DATE FROM PA.PA_MC_DRAFT_INV_ITEMS m WHERE m.PROJECT_ID = :project_id AND m.DRAFT_INVOICE_NUM = :draft_invoice_num;
• Join to the parent to compare amounts: SELECT p.LINE_NUM, p.AMOUNT primary_amt, m.AMOUNT reporting_amt, m.CURRENCY_CODE FROM PA.PA_DRAFT_INVOICE_ITEMS p, PA.PA_MC_DRAFT_INV_ITEMS m WHERE p.PROJECT_ID = m.PROJECT_ID AND p.DRAFT_INVOICE_NUM = m.DRAFT_INVOICE_NUM AND p.LINE_NUM = m.LINE_NUM;
• Filter by reporting set of books and currency to produce reporting-currency invoice registers.

Related Objects

• PA.PA_DRAFT_INVOICE_ITEMS — the parent table; join on PROJECT_ID, DRAFT_INVOICE_NUM, and LINE_NUM. This is the primary dependency relationship.
• PA.PA_DRAFT_INVOICES_ALL — referenced via PROJECT_ID for the draft invoice header context.
• GL.GL_SETS_OF_BOOKS_11I — referenced via SET_OF_BOOKS_ID to resolve the reporting set of books name and functional currency.
• FND.FND_CURRENCIES — referenced via CURRENCY_CODE to obtain currency descriptions and precision.
• GL.GL_DAILY_CONVERSION_TYPES — referenced via RATE_TYPE to validate and describe the conversion rate type used.

These relationships confirm the table's role as an MRC satellite of the draft invoice item detail, intended to be queried alongside its parent and the general ledger currency and rate reference tables.