Search Results jai_pa_draft_invoice_lines




Overview
Explore in AI Chat

Overview

The JAI_PA_DRAFT_INVOICE_LINES table is a core data object within the Oracle E-Business Suite (EBS) Asia/Pacific Localizations module, specifically designed for the India localization. It functions as a staging table for transactional line-level data during the creation and validation of draft invoices. Its primary role is to temporarily hold detailed line attributes—such as amounts, quantities, and tax classifications—before the invoice is finalized and posted to the standard Oracle Projects (PA) tables. This interim storage is critical for supporting India-specific statutory and tax compliance requirements during the invoice generation workflow in releases 12.1.1 and 12.2.2.

Key Information Stored

The table's structure is defined by its primary and foreign keys, which delineate its relationships and the nature of the data it contains. The primary key, DRAFT_INVOICE_LINE_ID, uniquely identifies each line record. Key stored attributes, as indicated by the foreign key relationships, include the DRAFT_INVOICE_ID linking the line to its parent header in JAI_PA_DRAFT_INVOICES, and the TAX_CATEGORY_ID referencing JAI_CMN_TAX_CTGS_ALL for India-specific tax categorization. The table also stores ORGANIZATION_ID and LOCATION_ID for legal entity and place of supply context. Furthermore, the presence of PARENT_DRAFT_INVOICE_ID and PARENT_DRAFT_INVOICE_LINE_ID columns suggests the table supports hierarchical line structures, such as for line-level adjustments or credit memos linked to original draft invoice lines.

Common Use Cases and Queries

A primary use case is the review and adjustment of draft invoice data before final submission. Users or automated processes can query this table to validate tax calculations, line amounts, and compliance rules. Common reporting SQL patterns involve joining to its related tables to produce a comprehensive draft invoice document. For example:

  • Retrieving all lines for a specific draft invoice for validation: SELECT * FROM jai_pa_draft_invoice_lines WHERE draft_invoice_id = <ID> ORDER BY line_number;
  • Analyzing tax categories applied across draft lines: SELECT tax_category_id, COUNT(*), SUM(line_amount) FROM jai_pa_draft_invoice_lines GROUP BY tax_category_id;
  • Identifying hierarchical line relationships (e.g., adjustments): SELECT child.* FROM jai_pa_draft_invoice_lines child, jai_pa_draft_invoice_lines parent WHERE child.parent_draft_invoice_line_id = parent.draft_invoice_line_id;

Related Objects

JAI_PA_DRAFT_INVOICE_LINES is centrally connected to several key localization objects. Its most direct relationship is with the JAI_PA_DRAFT_INVOICES table, which stores the corresponding invoice header information. For tax determination, it references JAI_CMN_TAX_CTGS_ALL. The table also integrates with core EBS entities: HR_ALL_ORGANIZATION_UNITS for the operating unit and HZ_LOCATIONS for the supply location. It maintains a recursive relationship with itself via the PARENT_DRAFT_INVOICE_LINE_ID column to model line-level hierarchies. This network of relationships positions the table as a critical junction between draft transactional data and master data within the India localization framework.