Search Results hz_cust_accounts




Overview
Explore in AI Chat

Overview

PA_DRAFT_INVOICES_ALL is the Oracle Projects (PA) transactional table that stores draft invoice header information generated for project contracts. Within Oracle EBS 12.1.1 and 12.2.2, it acts as the staging and control point for the invoice lifecycle — from draft generation through approval, release, and transfer into Oracle Receivables as an RA_CUSTOMER_TRX_ALL transaction. Each row represents a single draft invoice for a given project and draft invoice number combination.

From a dimensional modeling perspective, the FK structure suggests a satellite-leaning classification: the table is anchored to PA_PROJECTS_ALL via PROJECT_ID and carries the descriptive, mutable attributes of an invoice (amounts, dates, status flags, addresses). The presence of self-referencing FK relationships (PROJECT_ID and DRAFT_INVOICE_NUM_CREDITED, PROJECT_ID implemented as both PK and FK to itself) also makes it partially link-like, tying draft invoices to credited or predecessor invoice records.

The _ALL suffix indicates this is a multi-organization (MLS) table governed by ORG_ID, so all queries must respect the operating unit context.

Key Information Stored

The primary key is PA_DRAFT_INVOICES_PK (PROJECT_ID, DRAFT_INVOICE_NUM), and a second documented unique index, PA_DRAFT_INVOICES_U1, is defined on the same business-key pair. Among the 94 columns, the most operationally significant are:

Common Use Cases and Queries

Typical reporting scenarios include tracking draft invoices awaiting approval, identifying transfers that were rejected by AR, and reconciling project invoices to their AR transactions. A representative query joining to the customer master — directly relevant to the hz_cust_accounts search — is:

  • Listing invoices by customer: SELECT pdi.draft_invoice_num, hca.account_number, hca.account_name FROM pa.pa_draft_invoices_all pdi, hz.hz_cust_accounts hca WHERE pdi.customer_id = hca.cust_account_id AND pdi.org_id = :org_id;
  • Locating un-transferred invoices: filter on TRANSFER_STATUS_CODE IS NULL or unequal to the transferred value.
  • Reconciling to Receivables via SYSTEM_REFERENCE joined to RA_CUSTOMER_TRX_ALL.
  • Credit-memo tracing through DRAFT_INVOICE_NUM_CREDITED and CREDIT_MEMO_REASON_CODE.

Related Objects

Key dependencies and references include: