Search Results pa_draft_inv_dets_ar

Overview

PA.PA_DRAFT_INV_DETS_AR is a Projects (PA) module table in Oracle E-Business Suite 12.1.1 and 12.2.2 that stores the "AR" (Accounts Receivable-side) draft invoice detail lines generated by the Oracle Projects billing and transfer price processes. It is the counterpart detail table to PA_DRAFT_INVOICE_DETAILS_ALL and captures the accounting-currency amounts, transfer-price amounts, and tax attributes associated with each draft invoice line before the draft is finalized and transferred to Oracle Receivables. The table has 63 documented columns and holds a purge batch ID, indicating it participates in the PA purge routines that clean up draft invoice data.

Under the heuristic Data Vault classification mined from the foreign-key structure, this object is modeled as a standalone table — it is not identified as a hub, link, or satellite by the mining heuristic. From a dimensional modeling perspective, it behaves more like a fact/detail table keyed to a parent draft invoice detail, rather than a pure reference or lookup.

Key Information Stored

The table's row identity is carried by DRAFT_INVOICE_DETAIL_ID, which is the foreign key back to PA_DRAFT_INVOICE_DETAILS_ALL and serves as the effective parent reference for the "AR" detail. Business-key candidates for a draft invoice line are the combination of DRAFT_INVOICE_NUM and DRAFT_INVOICE_LINE_NUM (with LINE_NUM/LINE_NUM_REVERSED supporting reversal tracking).

• EXPENDITURE_ITEM_ID — links the detail to the source expenditure item in PA_EXPENDITURE_ITEMS_ALL, the key traceability column from billing back to cost.
• PROJECT_ID, CC_PROJECT_ID, PURGE_PROJECT_ID — the project and cross-charge/purge context for the line.
• BILL_AMOUNT, BILL_RATE, BILL_MARKUP_PERCENTAGE — the billable amount, rate applied, and markup percentage.
• BASE_AMOUNT, ACCT_CURRENCY_CODE — the base/accounting amount and its currency.
• DENOM_BILL_AMOUNT, DENOM_CURRENCY_CODE — the denominated (invoice) bill amount and currency.
• PROJACCT_BILL_AMOUNT, PROJACCT_COST_AMOUNT, PROJACCT_CURRENCY_CODE — project accounting currency amounts.
• PROJECT_TP_EXCHANGE_RATE, PROJECT_TRANSFER_PRICE, PROJFUNC_TRANSFER_PRICE, TP_AMT_TYPE_CODE — transfer-price amounts and rate types for both project and project-functional views.
• ACCT_EXCHANGE_RATE, ACCT_RATE_DATE, ACCT_RATE_TYPE — the accounting currency conversion rate details.
• OUTPUT_TAX_CLASSIFICATION_CODE, OUTPUT_VAT_TAX_ID, OUTPUT_TAX_EXEMPT_FLAG — output tax attributes carried into AR.
• REVERSED_FLAG, INVOICED_FLAG, LINE_NUM_REVERSED, DETAIL_ID_REVERSED — reversal and invoicing status flags.
• PURGE_BATCH_ID — FK to PA_PURGE_BATCHES_ALL, tracking which purge batch owns the row.
• ORG_ID, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE — standard multi-org and audit columns.

Common Use Cases and Queries

Typical uses center on reporting draft invoice detail in accounting and invoice currency, reconciling transfer-price amounts, and auditing tax classification before the draft is transferred to Oracle Receivables.

• Reporting draft invoice detail by project and expenditure item:

  SELECT d.DRAFT_INVOICE_NUM, d.DRAFT_INVOICE_LINE_NUM,
         d.BILL_AMOUNT, d.DENOM_BILL_AMOUNT, d.ACCT_CURRENCY_CODE
    FROM PA.PA_DRAFT_INV_DETS_AR d
   WHERE d.PROJECT_ID = :p_project_id
     AND d.ORG_ID = :p_org_id;

• Joining to the parent draft invoice detail to reconcile line totals:

  SELECT a.DRAFT_INVOICE_NUM, a.LINE_NUM, b.BILL_AMOUNT
    FROM PA.PA_DRAFT_INVOICE_DETAILS_ALL a,
         PA.PA_DRAFT_INV_DETS_AR b
   WHERE a.DRAFT_INVOICE_DETAIL_ID = b.DRAFT_INVOICE_DETAIL_ID;

• Auditing tax classification (OUTPUT_TAX_CLASSIFICATION_CODE, OUTPUT_VAT_TAX_ID) for draft lines prior to AR transfer.
• Tracing cost-to-bill via EXPENDITURE_ITEM_ID back to PA_EXPENDITURE_ITEMS_ALL for revenue and margin reporting.
• Purge housekeeping: filtering by PURGE_BATCH_ID and PURGE_RELEASE to identify rows eligible for cleanup.

Related Objects

The following are the most significant related objects, based on the documented foreign-key relationships:

• PA.PA_DRAFT_INVOICE_DETAILS_ALL — parent draft invoice detail, joined on DRAFT_INVOICE_DETAIL_ID.
• PA.PA_EXPENDITURE_ITEMS_ALL — source expenditure item, joined on EXPENDITURE_ITEM_ID.
• PA.PA_PURGE_BATCHES_ALL — purge batch control, joined on PURGE_BATCH_ID.
• PA.PA_DRAFT_INVOICES_ALL — the draft invoice header that the parent detail rolls up to (via the parent detail).
• PA.PA_PROJECTS_ALL — project master, keyed by PROJECT_ID / CC_PROJECT_ID.
• PA.PA_DRAFT_INVOICE_ITEMS — invoice item grouping that feeds the draft invoice detail lines.
• Oracle Projects Billing and Funds Capture/AR interface programs that consume draft invoice data when transferring to Receivables.