Results for “pa_draft_invoice_items”

50+ results




Overview
Explore in AI Chat

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

PA_DRAFT_INVOICE_ITEMS is a core table in the Oracle Projects (PA) module of Oracle E-Business Suite 12.1.1 / 12.2.2. It stores the individual line-level records that make up draft invoices generated by the Project Billing process. When Oracle Projects generates a draft invoice for a project or contract, the header-level information is written to PA_DRAFT_INVOICES_ALL, while the corresponding detail lines — one row per billable line item, retention line, credit, or tax line — are stored in PA_DRAFT_INVOICE_ITEMS. These lines are subsequently reviewed, adjusted, released, and eventually transferred to Oracle Receivables as transactions.

Because the table holds transactional attributes that describe individual invoice lines and inherit their identity from the parent draft invoice, the heuristic Data Vault classification supplied in the metadata is satellite-leaning. In a dimensional or Data Vault model, PA_DRAFT_INVOICE_ITEMS is best treated as a satellite attached to the PA_DRAFT_INVOICES_ALL hub/link, carrying descriptive and quantitative line attributes rather than acting as a standalone hub. The parent-child dependency is enforced through the composite primary key and foreign keys to the invoice header.

Key Information Stored

The table contains 98 documented columns. The most operationally significant are listed below; the primary key is composite and business-meaningful rather than a meaningless surrogate:

Common Use Cases and Queries

Typical reporting and troubleshooting activities involve reconciling generated draft invoice lines, verifying retention and credit handling, and confirming amounts before transfer to Receivables. A representative query joining the line to its header follows:

  • Listing all lines for a draft invoice: SELECT line_num, invoice_line_type, amount, task_id FROM pa_draft_invoice_items WHERE project_id = :p_id AND draft_invoice_num = :num ORDER BY line_num;
  • Summarizing draft invoice amounts by line type for a project to verify revenue and retention balances.
  • Identifying retention lines by querying RETN_DRAFT_INVOICE_NUM and RETENTION_RULE_ID, then tracing them to the originating line.
  • Auditing credit processing by filtering on CREDIT_PROCESS_FLAG and CREDIT_AMOUNT.
  • Extracting tax-related lines using OUTPUT_VAT_TAX_ID and OUTPUT_TAX_CLASSIFICATION_CODE prior to Receivables transfer.

Because the table is written during the draft invoice generation concurrent program, ROW records can be traced using REQUEST_ID and PROGRAM_ID for a specific run.

Related Objects

The table is tightly coupled to several parent and child objects in the PA schema: