Search Results jai_pa_draft_invoices




Overview
Explore in AI Chat

Overview

The JAI_PA_DRAFT_INVOICES table is a core data object within the Oracle E-Business Suite (EBS) Asia/Pacific Localizations module, specifically designed for India. It functions as an extension to the standard Project Accounting (PA) functionality, storing draft invoice header attributes that are mandated by India's localized legal and tax requirements. Its primary role is to hold supplementary regulatory information for project-related draft invoices before they are finalized, ensuring compliance with Indian excise and other statutory regulations within the EBS architecture for versions 12.1.1 and 12.2.2.

Key Information Stored

The table's central identifier is the DRAFT_INVOICE_ID, which serves as the primary key and links to the standard PA_DRAFT_INVOICES_ALL table. It stores localization-specific attributes tied to organizational and transactional context. Key columns include ORGANIZATION_ID, linking to the inventory organization (HR_ALL_ORGANIZATION_UNITS), and LOCATION_ID, referencing the party site (HZ_LOCATIONS). A critical column for excise compliance is EXCISE_REGISTER_ID, which foreign keys to the JAI_CMN_RG_23AC_II_TRXS table to associate the draft invoice with the appropriate excise register. The table also supports hierarchical invoice structures through the PARENT_DRAFT_INVOICE_ID, which is a self-referencing foreign key within the same table.

Common Use Cases and Queries

This table is central to generating India-compliant project invoices and related statutory reports. Common operational use cases include validating excise data before invoice finalization, tracing hierarchical invoice relationships, and auditing localized draft invoice data. A typical reporting query might join this table with standard PA and customer information to produce a consolidated view of draft invoices with Indian localization details:

  • SELECT jdi.DRAFT_INVOICE_NUM, pdi.DESCRIPTION, hou.NAME org_name, hl.LOCATION_CODE, jdi.EXCISE_REGISTER_ID FROM JA.JAI_PA_DRAFT_INVOICES jdi, APPS.PA_DRAFT_INVOICES_ALL pdi, APPS.HR_ALL_ORGANIZATION_UNITS hou, APPS.HZ_LOCATIONS hl WHERE jdi.PROJECT_ID = pdi.PROJECT_ID AND jdi.DRAFT_INVOICE_NUM = pdi.DRAFT_INVOICE_NUM AND jdi.ORGANIZATION_ID = hou.ORGANIZATION_ID AND jdi.LOCATION_ID = hl.LOCATION_ID;

Data integrity checks often involve verifying the existence of related excise register entries or ensuring parent-child invoice linkages are consistent.

Related Objects

JAI_PA_DRAFT_INVOICES is a nexus within the India localization schema, maintaining defined relationships with several key EBS objects. Its primary integration is with the standard PA_DRAFT_INVOICES_ALL table via the composite foreign key on PROJECT_ID and DRAFT_INVOICE_NUM. For organizational data, it references HR_ALL_ORGANIZATION_UNITS on ORGANIZATION_ID and HZ_LOCATIONS on LOCATION_ID. For excise tracking, it depends on JAI_CMN_RG_23AC_II_TRXS via EXCISE_REGISTER_ID. The table has a self-referencing relationship on PARENT_DRAFT_INVOICE_ID to manage invoice hierarchies. Crucially, it is the parent table for the line-level detail stored in JAI_PA_DRAFT_INVOICE_LINES, which foreign keys into it using DRAFT_INVOICE_ID and also references the same table for parent line information via PARENT_DRAFT_INVOICE_ID.