Search Results pa_draft_invoice_items_mrc_v

Overview

PA_DRAFT_INVOICE_ITEMS_MRC_V is a single-currency reporting view within the Oracle Projects (PA) module of Oracle E-Business Suite 12.1.1 and 12.2.2. The view presents draft invoice line items while collapsing the multiple reporting currencies (MRC) structures that previously existed in the underlying schema. Its purpose is to expose draft invoice item data in the functional currency of the set of books, rather than repeating each line across every reporting currency. This makes it a critical object for reporting, reconciliation, and integration routines that need to read draft invoice line details without processing the full MRC expansion.

The view is documented as a "Single currency view," and the reference documentation indicates it is not implemented in the database with its underlying physical objects in the same manner as MRC views previously were. This is consistent with the 12.2.x architectural shift away from multiple reporting sets of books toward subledger accounting (SLA) and secondary ledgers.

Underlying Base Objects

The view is defined over three base objects:

• PA_DRAFT_INVOICE_ITEMS (alias PADII) — the primary draft invoice line items table, providing amounts, tax attributes, retention details, and who-columns.
• PA_MC_DRAFT_INV_ITEMS (alias MC) — the multi-currency draft invoice items table, supplying the unbilled receivable debit and unearned revenue credit figures in the reporting context.
• GL_SETS_OF_BOOKS (alias GLSOB) — the set of books definition, supplying the functional CURRENCY_CODE.

The join links PADII to MC on PROJECT_ID, DRAFT_INVOICE_NUM, and LINE_NUM, with MC constrained by PRC_ASSIGNMENT_ID = -99, which identifies the functional-currency assignment row in the MRC structure. GL_SETS_OF_BOOKS is joined on SET_OF_BOOKS_ID, so the currency returned matches the ledger context of the invoice.

Key Columns

The view exposes a broad set of draft invoice attributes. Central to the user's search term is ROUNDING_AMOUNT, which carries the rounding adjustment applied to the line during amount calculations. Two further rounding columns are exposed: UNBILLED_ROUNDING_AMOUNT_DR and UNEARNED_ROUNDING_AMOUNT_CR, which capture rounding effects on the unbilled receivable debit and unearned revenue credit respectively. Together these support reconciliation of rounded invoice totals against accounting entries.

Other significant columns include AMOUNT (the draft invoice line amount), ACCT_AMOUNT (accounted amount), INV_AMOUNT (invoice amount), CREDIT_AMOUNT and CREDIT_PROCESS_FLAG, TASK_ID and EVENT_TASK_ID, TAXABLE_FLAG and the output tax classification columns, and the retention columns such as RETN_TOTAL_RETENTION and RETAINED_AMOUNT. Currency-related columns include PROJECT_CURRENCY_CODE, FUNDING_CURRENCY_CODE, BILL_TRANS_CURRENCY_CODE, INVPROC_CURRENCY_CODE, and GLSOB.CURRENCY_CODE, along with the associated exchange rate and rate-type columns used for currency conversion and funding scenarios.

Common Use Cases and Queries

Typical uses include reconciling rounded draft invoice line amounts against transferred invoice lines, investigating currency and rate discrepancies, and auditing retention and tax handling on draft invoices.

• Investigating rounding variances on draft invoice lines.
• Reconciling unbilled receivable and unearned revenue balances by project and invoice number.
• Reporting line-level draft invoice detail in the ledger functional currency.

A representative query selecting the rounding and amount columns is:

SELECT PROJECT_ID,
       DRAFT_INVOICE_NUM,
       LINE_NUM,
       AMOUNT,
       ACCT_AMOUNT,
       ROUNDING_AMOUNT,
       UNBILLED_ROUNDING_AMOUNT_DR,
       UNEARNED_ROUNDING_AMOUNT_CR,
       CURRENCY_CODE
FROM   PA_DRAFT_INVOICE_ITEMS_MRC_V
WHERE  ROUNDING_AMOUNT <> 0
AND    PROJECT_ID = :project_id;

Because the view is defined with the functional-currency assignment constraint, results reflect the single reporting currency of the ledger, simplifying comparisons between line amounts and their rounding adjustments without needing to filter across multiple currency rows.