Search Results pa_draft_invoices_all

Overview

The PA_DRAFT_INVOICES_ALL table is a core transactional table within the Oracle E-Business Suite Projects (PA) module, specifically for releases 12.1.1 and 12.2.2. It serves as the central repository for all draft invoices generated for projects before they are formally interfaced to Oracle Receivables. This table is fundamental to the project billing lifecycle, capturing the complete definition and status of a draft invoice, including customer, financial, and currency information. Its multi-org structure, denoted by the "_ALL" suffix, indicates it stores data for all operating units, making it essential for enterprise-wide project invoicing operations.

Key Information Stored

The table's primary key is a composite of PROJECT_ID and DRAFT_INVOICE_NUM, uniquely identifying each draft invoice within the system. Key columns and the data they hold include customer identifiers (CUSTOMER_ID, BILL_TO_CUSTOMER_ID, SHIP_TO_CUSTOMER_ID), financial code combinations for accounting (e.g., RECEIVABLE_CODE_COMBINATION_ID, UNBILLED_CODE_COMBINATION_ID), and currency details (INV_CURRENCY_CODE, INV_RATE_TYPE). It also stores critical references such as the AGREEMENT_ID governing the invoice, address IDs for billing and shipping, and a SYSTEM_REFERENCE link to the final RA_CUSTOMER_TRX_ALL record once the draft invoice is approved and transferred.

Common Use Cases and Queries

This table is central to billing analysis, audit trails, and reconciliation processes. Common use cases include tracking the status of draft invoices before submission to Receivables, analyzing billing details for a specific project or customer, and identifying draft invoices that have been credited (via DRAFT_INVOICE_NUM_CREDITED). A typical query retrieves draft invoice headers with related project and customer information:

• SELECT pdi.draft_invoice_num, pdi.invoice_currency_code, pj.segment1 project_number, hca.account_number FROM pa_draft_invoices_all pdi, pa_projects_all pj, hz_cust_accounts hca WHERE pdi.project_id = pj.project_id AND pdi.customer_id = hca.cust_account_id AND pdi.project_id = :p_project_id;

Another critical reporting use case involves joining with PA_DRAFT_INVOICE_ITEMS to analyze billed revenue lines or with RA_CUSTOMER_TRX_ALL to reconcile draft invoices with their final, posted transaction counterparts.

Related Objects

As indicated by its extensive foreign key relationships, PA_DRAFT_INVOICES_ALL is a hub table with dependencies across multiple EBS modules. Key related objects include:

• PA_PROJECTS_ALL: The foundational projects table.
• HZ_CUST_ACCOUNTS & HZ_CUST_ACCT_SITES_ALL: Oracle Trading Community Architecture tables for customer and address data.
• RA_CUSTOMER_TRX_ALL: The Receivables transactions table, linked via SYSTEM_REFERENCE.
• GL_CODE_COMBINATIONS: Provides the accounting flexfields for revenue recognition and receivables.
• PA_DRAFT_INVOICE_ITEMS_ALL: Stores the detailed revenue lines associated with each draft invoice header.
• PA_AGREEMENTS_ALL: Links to the project funding and billing agreement.