Search Results pa_draft_invoices




Overview
Explore in AI Chat

Overview

PA_DRAFT_INVOICES is a Single-Org reporting view in the Oracle Projects (PA) module of Oracle E-Business Suite, available in releases 12.1.1 and 12.2.2. It presents draft invoice header information generated by the Oracle Projects AutoInvoice and invoice generation process, prior to the point at which those drafts are transferred and interfaced to Oracle Receivables. In EBS multi-org architecture, the view acts as an org-striped wrapper over the underlying intersection table PA_DRAFT_INVOICES_ALL, restricting rows to the operating unit implied by the session's client information.

The view is primarily used for reporting, reconciliation, and troubleshooting of the project billing cycle. It exposes the number, date, currency, transfer status, and approval state of each draft invoice, along with retained accounting and credit memo attributes. Because it filters by ORG_ID, it is the appropriate object for operational reports and concurrent programs that must run within the context of a single operating unit.

Underlying Base Objects

The documented view text shows a single source: PA_DRAFT_INVOICES_ALL. The WHERE clause applies an ORG_ID restriction derived from USERENV('CLIENT_INFO'), with NVL handling to fall back to a default when no client information is set. This is the standard Oracle Projects multi-org view pattern and explains the "Single-Org" designation in the ETRM metadata.

The ETRM implementation note states that the view is "Not implemented in this database," meaning it was not created or validated within the reference environment captured by the documentation tool, but its definition remains the canonical published text. No other base tables are documented as referenced by the view; all enrichment such as project names, customer names, and agreement details is obtained by joining to the corresponding project, customer, and agreement entities.

Key Columns

Common Use Cases and Queries

Typical scenarios include listing untransferred draft invoices for an operating unit, reconciling transferred drafts to Receivables, and identifying credit memos linked to their credited invoices via DRAFT_INVOICE_NUM_CREDITED.

SELECT d.DRAFT_INVOICE_NUM,
       d.DRAFT_INVOICE_NUM_CREDITED,
       d.TRANSFER_STATUS_CODE,
       d.INVOICE_DATE,
       d.INV_CURRENCY_CODE,
       d.CREDIT_MEMO_REASON_CODE
FROM   PA_DRAFT_INVOICES d
WHERE  d.PROJECT_ID = :project_id
ORDER  BY d.INVOICE_DATE;

A second common query identifies outstanding drafts awaiting transfer, while a third joins to PA_PROJECTS_ALL for project names. Because the view enforces the operating unit filter automatically, callers need not add an ORG_ID predicate when running within the correct session context.