Search Results jai_ar_tax_processing_pkg




Overview
Explore in AI Chat

Overview

JAI_AR_TAX_PROCESSING_PKG is a PL/SQL package owned by APPS in the Oracle E-Business Suite, delivered as part of the Oracle Financials for India (JAI) localization layer. Its stated purpose is to orchestrate India-specific tax processing for Oracle Receivables transactions, bridging standard EBS Receivables records with the E-Business Tax (EBTax / ZX) engine. The package is defined with AUTHID CURRENT_USER, which means its SQL statements execute under the privileges of the invoking schema rather than as definer-rights code — a relevant detail when diagnosing ORA-00942 or synonym resolution errors in customized environments. The header comment records the initial creation at version 115.1 on 13-June-2012 under bug 14040855, and the file revision string indicates the current source level is 120.0.12020000.2, dated 19-March-2013. That revision lineage is consistent with the 12.1.1 and 12.2.2 release streams, where the India localization continues to be shipped as an add-on to the core Receivables and EBTax stack.

Key Procedures and Functions

  • CALCULATE_TAX — The primary tax computation entry point. It accepts a transaction record, an event class record, a line-level action, and a transaction line identifier, and returns a return code and return message to the caller. The parameter types are drawn from ZX_API_PUB.transaction_rec_type and ZX_API_PUB.event_class_rec_type, confirming that the procedure invokes the public EBTax application programming interface rather than performing tax derivation itself.
  • IMPORT_DOCUMENT_WITH_TAX — Handles the receipt of an inbound document together with its associated tax information, persisting the combined result into the Receivables tax tables. It is the counterpart path for documents that arrive with tax already determined externally.
  • DETERMINE_RECOVERY — The procedure surfaced by the user's search term. It applies India-specific recovery rules to a transaction's tax lines, establishing the recoverable and non-recoverable portions of the tax amount in accordance with local tax credit regulations. This is the mechanism by which the India localization distinguishes creditable tax from cost-embedded tax before posting to the general ledger.

Tables Accessed

The package reads and writes Receivables transaction data through the standard base tables RA_CUSTOMER_TRX_ALL and RA_CUSTOMER_TRX_LINES_ALL, which hold the transaction header and line records being taxed. The India-specific extension tables JAI_AR_TRXS and JAI_AR_TRX_LINES store localization attributes that the standard tables do not carry, and are the principal targets of the recovery determination logic. JAI_AP_TDS_YEARS supplies the tax year definitions used to validate the applicability of rates and thresholds for the transaction date. All references are made through APPS synonyms.

Usage Notes

JAI_AR_TAX_PROCESSING_PKG is not intended for direct end-user invocation. It is called from the India-localized Receivables forms, from concurrent programs that process inbound documents, and from custom extensions that must apply India tax rules programmatically. One other package in the ETRM inventory references it, so callers should treat the public procedure signatures as a stable interface. Because the package relies on the EBTax public API record types, any upgrade to the ZX schema in 12.2.2 can affect compilation, and the return code and return message out-parameters should always be inspected rather than ignored.