Search Results pa_mc_draft_inv_dets_ar_u1

Overview

PA.PA_MC_DRAFT_INV_DETS_AR is a transactional table in the Oracle E-Business Suite Projects (PA) schema that stores draft invoice detail lines generated by the Multi-Currency (MC) intercompany billing process. It serves as the submission-time staging area for transfer-price amounts expressed in the provider operating unit's functional currency and in the reporting (set of books) currency, capturing the conversion rate type, rate date, and exchange rate applied to each draft invoice detail. Records are held here until the draft invoice is finalized, purged, or transferred into the permanent drafting and invoicing structures.

The table is owned by the PA schema, resides in the APPS_TS_TX_DATA tablespace, and is documented as VALID in ETRM for both 12.1.1 and 12.2.2. It carries the standard Oracle "Internal Use Only" warning: supported access is through Oracle Applications programs, not through direct SQL, and any custom read must be treated as read-only.

Heuristic Data Vault classification mined from the foreign-key structure indicates a standalone object. Under a Data Vault modeling suggestion this would be treated as a satellite-like or link-adjacent staging entity rather than a true hub, because its natural business key depends on a composite of parent identifiers and it has no downstream child tables of its own.

Key Information Stored

The table contains 16 documented columns. The most significant are:

• SET_OF_BOOKS_ID, PROJECT_ID, and DRAFT_INVOICE_DETAIL_ID — the three columns forming the unique index PA_MC_DRAFT_INV_DETS_AR_U1, which is the business-key candidate for the table.
• DRAFT_INVOICE_DETAIL_ID — the system-generated surrogate identifier inherited from PA_DRAFT_INVOICE_DETAILS_ALL, uniquely identifying the invoice detail line.
• PROJECT_ID — the project used to bill the transaction; for intercompany billing this is the provider project.
• SET_OF_BOOKS_ID — the reporting set of books unique identifier.
• BILL_AMOUNT — the functional-currency amount of the transfer price for the detail line.
• ACCT_CURRENCY_CODE — the functional currency code of the provider operating unit.
• ACCT_RATE_TYPE, ACCT_RATE_DATE, and ACCT_EXCHANGE_RATE — the rate type, rate date, and exchange rate used to convert the functional-currency amount into the reporting currency.
• INVOICED_FLAG — indicates whether the detail line has been included on an invoice; defaults to N.
• PURGE_BATCH_ID, PURGE_RELEASE, and PURGE_PROJECT_ID — purge-processing attributes recording the purge batch, release version, and purged project.
• REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, and PROGRAM_UPDATE_DATE — standard concurrent-program and Who columns used for audit and process tracking.

Common Use Cases and Queries

Typical use is reconciliation and audit of intercompany draft invoice amounts before finalization: reporting on unconverted or failed conversion lines, verifying the exchange rate applied against the corporate rate table, and identifying draft details still awaiting invoicing. A representative pattern joins the table back to its parents on the composite key:

• SELECT d.draft_invoice_detail_id, d.project_id, d.bill_amount, d.acct_currency_code, d.acct_exchange_rate FROM pa.pa_mc_draft_inv_dets_ar d WHERE d.set_of_books_id = :p_sob AND d.invoiced_flag = 'N';
• Join to PA_DRAFT_INVOICE_DETAILS_ALL on DRAFT_INVOICE_DETAIL_ID to retrieve the parent draft invoice detail context.
• Join to PA_PURGE_BATCHES_ALL on PURGE_BATCH_ID to report on records scheduled or processed by a purge batch.

Because access is restricted to Oracle Applications programs, any ad hoc query should be confined to a read-only reporting user.

Related Objects

• PA_DRAFT_INVOICE_DETAILS_ALL — referenced via PA_MC_DRAFT_INV_DETS_AR.DRAFT_INVOICE_DETAIL_ID; the primary parent supplying the draft invoice detail context.
• PA_PURGE_BATCHES_ALL — referenced via PA_MC_DRAFT_INV_DETS_AR.PURGE_BATCH_ID; groups records for purge processing.
• PA_DRAFT_INVOICES_ALL — header-level parent of the draft invoice detail lines, reached through the detail table.
• PA_PROJECTS_ALL — the provider project identified by PROJECT_ID.
• GL_SETS_OF_BOOKS (and the 12.2.2 replacement GL_LEDGERS) — resolves SET_OF_BOOKS_ID to the reporting ledger.
• FND_CURRENCIES — validates ACCT_CURRENCY_CODE.

Collectively these relationships place PA_MC_DRAFT_INV_DETS_AR within the intercompany draft invoicing and purge lifecycle managed by the PA schema.