Search Results jai_encum_prc




Overview
Explore in AI Chat

Overview

JAI_ENCUM_PRC is an Oracle E-Business Suite PL/SQL package owned by the APPS schema. It belongs to the Oracle Financials for India (JAI) product family and provides encumbrance-related processing logic that integrates Indian localizations with the standard Purchasing and Cost Management encumbrance functionality. Its primary business purpose is to calculate, fetch, and reverse encumbrance amounts associated with tax lines on purchase orders, requisitions, and their distributions. In Oracle EBS releases 12.1.1 and 12.2.2, encumbrance accounting allows organizations to reserve funds at the time of commitment (requisition or purchase order) and relieve those reserves upon actual receipt, invoice, or cancellation. JAI_ENCUM_PRC extends this model so that Indian tax components are properly included when encumbrance balances are computed and reversed.

Key Procedures and Functions

The ETRM metadata documents two public program units:

  • FETCH_NR_TAX — Retrieves non-recoverable (NR) tax amounts applicable to a purchase order or requisition line. Non-recoverable taxes represent a real cost to the organization and therefore must be encumbered alongside the base line amount. This function supports that determination for downstream encumbrance calculations.
  • FETCH_ENCUM_REV_AMT — Retrieves or computes the encumbrance reversal amount. This is used when commitments are relieved, ensuring that the tax-inclusive portion of the encumbrance is correctly backed out during receipt, invoicing, or cancellation processing.

Both units rely on package-level SQL statements and reference the PL/SQL types PO_TBL_NUMBER and PO_TBL_VARCHAR30, which are standard Oracle Purchasing collection types used to pass arrays of numeric and character values between program units. The package also depends on the SYS.STANDARD package.

Tables Accessed

The package reads and writes across Purchasing, encumbrance, and India localization tables through APPS synonyms. Documented references include:

Usage Notes

JAI_ENCUM_PRC is not typically invoked directly by end users. It is referenced by other packages including CST_COMMON_HOOKS, PO_DOCUMENT_FUNDS_PVT, and JAI_ENCUM_PRC itself (recursive or nested calls), confirming its role as a shared utility layer within the encumbrance and funds-check flow. It is therefore executed indirectly when Purchasing processes requisitions and purchase orders, when funds are reserved or relieved, and when Cost Management distributes encumbrance amounts. Customizations that modify Indian tax encumbrance behavior should extend or wrap this package rather than alter it, since it sits beneath standard funds-check logic. Because it manipulates persistent reversal-detail tables, changes should be tested in a controlled environment with full encumbrance accounting enabled.