Search Results process_excise

Overview

JAI_PA_BILLING_PKG is the Oracle Projects billing localization package shipped under the APPS schema for the Oracle E-Business Suite India (JAI) localization. Its header indicates that it was originally created as part of the Projects Billing implementation to handle VAT and Excise tax processing, and was forward-ported from Release 11i to Release 12.1.1 and later 12.2.2 (script header jai_pa_billing.plb 120.3). The package is classified as OTHER within ETRM and is referenced by five other packages, indicating that it acts as a shared billing engine rather than a stand-alone utility.

The business problem it addresses is the Indian statutory requirement to calculate, validate and account for Excise Duty and VAT on project-related invoices generated through Oracle Projects. Draft invoices created in the Projects billing flow do not pass through standard Payables tax engines before release; JAI_PA_BILLING_PKG bridges that gap by processing taxes on the draft invoice, updating the payment schedule, generating distribution and journal entries, and populating the interface tables used by Payables.

Key Procedures and Functions

The package exposes eight documented entry points together with private helpers. The version identification functions GET_SPEC_VERSION and GET_BODY_VERSION report the package specification and body versions, supporting patch and diagnostic verification.

• PROCESS_DRAFT_INVOICE_RELEASE — primary driver invoked when a Projects draft invoice is released; performs the India-specific validations and tax processing before the invoice is handed to Payables.
• PROCESS_EXCISE — computes and applies Excise Duty amounts for the invoice lines, including utilization of any available Excise credit balance.
• CHECK_EXCISE_BALANCE — validates the Excise balance recorded against RG 23AC / PLA registers before Excise is applied.
• PROCESS_VAT — computes and applies VAT on the taxable invoice amounts.
• INSERT_GL_ENTRY — builds the General Ledger journal entries for the tax lines and inserts them into the GL interface.
• IMPORT_TAXES_TO_PAYABLES — posts the calculated India tax lines into the Payables interface structures so that they are recognized by the Payables invoice import.

Private forward declarations such as update_payment_schedule, update_mrc_data and insert_mrc_data support the public procedures by synchronizing AP payment schedules and multi-reporting-currency (MRC) columns. A private exception, le_org_loc_null, was added under Bug 6503813 to enforce that organization and location details are captured on the India Localization form; this validation prevents a user from releasing a draft invoice from the base form, since a missing organization or location would otherwise only be detected during auto-invoice import.

Tables Accessed

The package reads and writes across Projects, Payables and India localization tables:

• PA_DRAFT_INVOICES_ALL — the draft invoice header being processed.
• AP_INVOICES_ALL, AP_INVOICE_DISTRIBUTIONS_ALL, AP_PAYMENT_SCHEDULES_ALL — invoice, distribution and schedule records that are created or updated with the computed tax amounts.
• JAI_CMN_JOURNAL_ENTRIES, JAI_CMN_JOURNAL_ENTRIES_S, GL_INTERFACE, GL_JE_HEADERS — accounting entries generated for the tax lines and fed to General Ledger. Bug 6012570 added the JOURNAL_ENTRY_ID column to the insert into JAI_CMN_JOURNAL_ENTRIES.
• JAI_CMN_DOCUMENT_TAXES, JAI_CMN_RG_23AC_II_TRXS, JAI_RGM_DEFINITIONS — India localization tax setup, Excise register transactions and register definitions used for Excise/VAT calculation and balance checking.
• JAI_CMN_FIN_YEARS, JAI_CMN_INVENTORY_ORGS, GL_CURRENCIES, FND_CURRENCIES — supporting setup for financial years, inventory organizations and currency conversion.

Usage Notes

JAI_PA_BILLING_PKG is normally invoked indirectly: it is called when a user releases a Projects draft invoice from the India Localization invoice form, and by concurrent programs that import taxes into Payables. Because the package writes directly to GL_INTERFACE and the JAI journal entry tables, the GL source for project accounting is assigned to the seeded GL source 'Projects India' (change 3, Bug 6012570). Sites customizing the Hinduja-style India billing format should treat this package as the authoritative engine and avoid modifying it directly; validation failures raised through le_org_loc_null require users to complete organization and location fields on the India Localization form before release. Because the package is referenced by five other packages, any extension should be layered through a custom wrapper rather than an edit to the shipped body.