Search Results pa_mc_draft_inv_details_u1

Overview

PA.PA_MC_DRAFT_INV_DETAILS_ALL is a Multi-Reporting Currency (MRC) subtable of PA.PA_DRAFT_INVOICE_DETAILS_ALL within the Oracle E-Business Suite Projects (PA) module. It stores currency-related attributes for draft invoice details, maintained separately for each reporting set of books associated with the corresponding parent record. In an ETRM 12.1.1 or 12.2.2 environment, this table allows a single set of project billing transactions to be represented in multiple functional currencies, supporting global organizations that operate with multiple sets of books.

From a data modeling perspective, the metadata's heuristic Data Vault classification suggests this object behaves as a link, since it resolves relationships between parent draft invoice details, sets of books, projects, currencies, and conversion rate types, and carries descriptive measures alongside those associations.

Key Information Stored

The table's uniqueness is enforced by the composite primary key and unique index PA_MC_DRAFT_INV_DETAILS_U1, comprising SET_OF_BOOKS_ID and DRAFT_INVOICE_DETAIL_ID. These two columns form both the surrogate identifier for MRC rows and the business-key candidate, distinguishing each reporting set of books' view of an invoice detail.

• SET_OF_BOOKS_ID — the reporting set of books unique identifier, identifying which ledger's currency view the row represents.
• DRAFT_INVOICE_DETAIL_ID — the system-generated identifier of the invoice detail, linking to the parent row in PA_DRAFT_INVOICE_DETAILS_ALL.
• PROJECT_ID — identifier of the project that will be billed; for intercompany billing this is the provider project.
• INVOICED_FLAG — indicates whether the detail line has been invoiced, defaulting to 'N'.
• ACCT_CURRENCY_CODE — functional currency code of the provider operating unit.
• BILL_AMOUNT — functional currency amount of the transfer price.
• ACCT_RATE_TYPE, ACCT_RATE_DATE, ACCT_EXCHANGE_RATE — the conversion rate type, rate date, and exchange rate used to translate the functional currency amount into the reporting currency.
• REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE — standard Who columns recording the concurrent request and program that last touched the row.

Common Use Cases and Queries

Typical usage centers on multi-currency billing reconciliation and reporting. A common pattern joins MRC detail rows back to the parent for a given set of books:

SELECT d.draft_invoice_detail_id, m.set_of_books_id, m.bill_amount, m.acct_currency_code, m.acct_exchange_rate FROM pa.pa_draft_invoice_details_all d, pa.pa_mc_draft_inv_details_all m WHERE d.draft_invoice_detail_id = m.draft_invoice_detail_id AND m.set_of_books_id = :p_sob_id;

Analysts use the ACCT_RATE_* columns to audit translation rates applied during invoicing, and filter on INVOICED_FLAG to isolate details not yet invoiced. PROJECT_ID supports cost-to-bill transfer price reporting by project or provider operating unit.

Related Objects

• PA.PA_DRAFT_INVOICE_DETAILS_ALL — parent table joined on DRAFT_INVOICE_DETAIL_ID.
• PA.PA_PROJECTS_ALL — joined on PROJECT_ID for project attributes.
• FND_CURRENCIES — joined on ACCT_CURRENCY_CODE for currency descriptions.
• GL_DAILY_CONVERSION_TYPES — joined on ACCT_RATE_TYPE for rate type definitions.
• FND_SET_OF_BOOKS / GL_SETS_OF_BOOKS — resolves SET_OF_BOOKS_ID to the reporting ledger.