Search Results pa_mc_draft_inv_items_pk

Overview

PA_MC_DRAFT_INV_ITEMS is a Projects (PA) module table in Oracle E-Business Suite 12.1.1 and 12.2.2 that stores draft invoice line information for each reporting currency. In an Oracle EBS context, Oracle Projects supports multiple reporting currencies, allowing draft invoices to be reviewed and reported in the functional currency of the operating unit as well as in additional reporting currencies defined at the set of books level. PA_MC_DRAFT_INV_ITEMS holds the currency-specific, per-line monetary and accounting distributions that back this multi-currency reporting requirement.

From a Data Vault modeling perspective, the heuristic classification derived from the documented foreign-key structure is a link. This suggests the table functions as an associative structure connecting a draft invoice line to a set of books, a currency, and a conversion rate type — rather than acting as a standalone hub or a descriptive satellite.

Key Information Stored

The table comprises 12 documented columns. The composite primary key, PA_MC_DRAFT_INV_ITEMS_PK, is defined on SET_OF_BOOKS_ID, PROJECT_ID, DRAFT_INVOICE_NUM, and LINE_NUM. A unique index, PA_MC_DRAFT_INVOICE_ITEMS_U1, is defined on the same four columns and serves as the primary business-key candidate.

• SET_OF_BOOKS_ID — Identifies the ledger (set of books) for which the reporting-currency amounts are held; part of the primary key.
• PROJECT_ID — The project to which the draft invoice line belongs; part of the primary key and foreign key to project-level invoice data.
• DRAFT_INVOICE_NUM — The draft invoice number; part of the primary key.
• LINE_NUM — The draft invoice line number; part of the primary key.
• AMOUNT — The reporting-currency amount for the draft invoice line.
• UNBILLED_RECEIVABLE_DR — The unbilled receivable debit distribution amount in the reporting currency.
• UNEARNED_REVENUE_CR — The unearned revenue credit distribution amount in the reporting currency.
• PRC_ASSIGNMENT_ID — References the project revenue/credit assignment associated with the line.
• CURRENCY_CODE — The reporting currency of the stored amounts; foreign key to FND_CURRENCIES.
• EXCHANGE_RATE — The rate applied to convert to the reporting currency.
• CONVERSION_DATE — The date on which the exchange rate was determined.
• RATE_TYPE — The conversion rate type; foreign key to GL_DAILY_CONVERSION_TYPES.

Common Use Cases and Queries

Typical use cases include multi-currency draft invoice review, reporting-currency reconciliation, and audit of exchange-rate application. A representative join retrieves line detail against the underlying draft invoice:

• Reporting draft invoice lines by set of books and currency, joining PA_MC_DRAFT_INV_ITEMS to PA_DRAFT_INVOICE_ITEMS on PROJECT_ID, DRAFT_INVOICE_NUM, and LINE_NUM.
• Reconciling reporting-currency amounts to the ledger via SET_OF_BOOKS_ID, joining to GL_SETS_OF_BOOKS_11I.
• Validating conversion parameters by joining CURRENCY_CODE to FND_CURRENCIES and RATE_TYPE to GL_DAILY_CONVERSION_TYPES.

Sample pattern: SELECT m.PROJECT_ID, m.DRAFT_INVOICE_NUM, m.LINE_NUM, m.CURRENCY_CODE, m.AMOUNT, m.EXCHANGE_RATE, m.CONVERSION_DATE FROM PA.PA_MC_DRAFT_INV_ITEMS m WHERE m.SET_OF_BOOKS_ID = :p_sob_id AND m.PROJECT_ID = :p_project_id; Similar filtering supports line-level audits and period reporting.

Related Objects

• PA_DRAFT_INVOICE_ITEMS — Joined on PROJECT_ID, DRAFT_INVOICE_NUM, LINE_NUM; source of functional-currency line detail.
• PA_DRAFT_INVOICES_ALL — Joined on PROJECT_ID and DRAFT_INVOICE_NUM; the draft invoice header.
• GL_SETS_OF_BOOKS_11I — Joined on SET_OF_BOOKS_ID; the ledger definition.
• FND_CURRENCIES — Joined on CURRENCY_CODE; currency validation.
• GL_DAILY_CONVERSION_TYPES — Joined on RATE_TYPE; conversion rate type definition.

These relationships confirm the table's role as a currency-specific extension of draft invoice line data, dependent on both Projects invoice structures and Oracle General Ledger reference data.