Search Results pa_draft_invoices_v




Overview
Explore in AI Chat

Overview

PA_DRAFT_INVOICES_V is an Oracle EBS Projects (PA) reporting view owned by the APPS schema. Its ETRM description records it as "10SC Only," indicating that the view is shipped for a specific regional or legislative track (the "10SC" designation) rather than as a universally supported public interface. It exposes draft invoice header information from Oracle Projects alongside denormalized project, customer, agreement, and approval context, giving report authors and integrators a single query surface for draft invoice status tracking.

In Oracle EBS 12.1.1 and 12.2.2 the object remains a view (Status: VALID) and is not a table, so it carries no storage of its own and reflects the live state of its underlying tables at query time. Because it joins PA_DRAFT_INVOICES_ALL to project, customer, agreement, and HR organization data, it is commonly used in reports that need draft invoice lifecycle status without navigating multiple joins manually. The view's most frequently queried status column, INVOICE_STATUS_CODE, is derived from PA_LOOKUPS.

Underlying Base Objects

ETRM metadata lists the referenced base objects for 12.2.2. The view is defined principally over PA_DRAFT_INVOICES_ALL (aliased I), with PA_PROJECTS_ALL (P) supplying project number, name, type, and distribution rule, PA_PROJECT_STATUSES providing the project status meaning, and HR_ALL_ORGANIZATION_UNITS supplying the project organization. Customer context comes from PA_CUSTOMERS_V and HZ_CUST_SITE_USES, agreement context from PA_AGREEMENTS_ALL and RA_TERMS, and personnel context from PER_ALL_PEOPLE_F for both the approver and releaser.

Supporting objects include PA_LOOKUPS (the source of INVOICE_STATUS_CODE and INVOICE_STATUS_M), PA_DISTRIBUTION_RULES, PA_PROJECT_CUSTOMERS, PA_PROJECT_TYPES, PA_DRAFT_INVOICE_PP_V, PA_DRAFT_INV_ITEMS_BAS, FND_LANGUAGES, and the PA_CONVERSION_TYPES_V, PA_MULTI_CURRENCY, PA_OUTPUT_TAX, and PA_SECURITY packages, PA_IMPLEMENTATIONS, and PA_MULTI_CURRENCY. The presence of PA_SECURITY is significant: access to draft invoice rows is filtered through Projects security, so a query returns only records the executing user is authorized to see.

Key Columns

Common Use Cases and Queries

Typical scenarios include reconciliation of draft invoices pending approval or release, status dashboards grouped by customer or project, and extracts feeding downstream billing or reporting systems. The following query retrieves draft invoices with their decoded status:

  • SELECT draft_invoice_num, project_number, project_name, customer_name, invoice_status_code, invoice_status_m, chk_status, invoice_date FROM apps.pa_draft_invoices_v WHERE invoice_status_code = 'X';
  • SELECT project_number, invoice_status_m, COUNT(*) FROM apps.pa_draft_invoices_v GROUP BY project_number, invoice_status_m ORDER BY project_number;
  • SELECT draft_invoice_num, chk_status, approved_by_person_name, released_by_person_name FROM apps.pa_draft_invoices_v WHERE chk_status IN ('UNAPPROVED','UNRELEASED');

Because the view is secured by PA_SECURITY and marked "10SC Only," implementers should confirm availability in their specific instance before relying on it for production reporting.