Search Results cenvat_auto_claim

Overview

APPS.JAI_MTL_TRXS_PKG is a PL/SQL package in the Oracle E-Business Suite applications schema that supports India-localization tax and costing processing for inventory and receiving transactions. Its principal business purpose is to calculate, claim, and account for domestic indirect taxes — Central Value Added Tax (CENVAT) and VAT — that arise when goods are received into inventory, consumed in manufacturing, or returned. The package bridges the Oracle Inventory and Purchasing/Receiving modules with the India tax registers maintained in the JAI (Oracle Financials for India) schema. It is catalogued in ETRM 12.2.2 with an API classification of OTHER, indicating it is an internal utility package rather than a published open interface. It holds status VALID and consists of a specification and body.

Key Procedures and Functions

The documented package exposes thirteen procedures and functions that fall into three functional groups: CENVAT processing, VAT processing, and cost/accounting integration.

• CENVAT group: CENVAT_PROCESS drives the core CENVAT calculation and posting logic for eligible transactions. CENVAT_RECPT_DET derives receipt-level CENVAT detail from receiving records. CENVAT_AUTO_CLAIM automates the creation of CENVAT claims against eligible documents. DO_CENVAT_ACCTG generates the accounting entries for CENVAT claim activity. CLAIM_BALANCE_CGVAT computes balances associated with CGVAT claims, and CGVAT_REPOSIT_ENTRY posts the corresponding repository entries.
• VAT group: RECV_VAT_PROCESS handles VAT determination on receiving transactions, while PROCESS_VAT_CLAIM_ACCTG produces the accounting for VAT claims.
• Cost and reconciliation group: DO_COSTING, AVG_COST_ENTRY, and STD_COST_ENTRY manage cost layer creation and entry for average and standard costing methods respectively. DEFAULT_TAXES assigns default tax attributes to a transaction, and SYNC_WITH_BASE_TRX reconciles the India-localization transaction record with the underlying base Oracle transaction.

Parameter lists are not reproduced here because they are not part of the documented metadata; callers should inspect the package specification in the database for exact signatures. The companion package body is referenced by JAI_MTL_TRXS_PKG itself, confirming internal helper routines are encapsulated within it.

Tables Accessed

The package reads and writes the India tax and receiving tables through APPS synonyms. JAI_CMN_TAXES_ALL holds the tax setup and rates applied during determination. JAI_RCV_TRANSACTIONS stores the localization-level receipt transaction records, while JAI_RCV_CENVAT_CLAIMS and JAI_CMN_DOCUMENT_TAXES carry claim and document tax detail. JAI_RGM_TERMS supplies the tax regime terms governing eligibility. Base receiving data is drawn from RCV_SHIPMENT_HEADERS, RCV_SHIPMENT_LINES, and RCV_TRANSACTIONS.

Costing integration uses CST_LAYER_COST_DETAILS and CST_QUANTITY_LAYERS, which represent the cost layer and quantity layer structures in inventory costing. Financial posting touches GL_INTERFACE for journal import and GL_PERIOD_STATUSES to validate open accounting periods. Customer site data is read from HZ_CUST_ACCT_SITES_ALL and HZ_CUST_SITE_USES_ALL, and JAI_CMN_FIN_YEARS supports period and fiscal-year determination.

Usage Notes

JAI_MTL_TRXS_PKG is an internal package invoked primarily from Oracle India localization flows rather than through direct user action. It is typically called from receiving and inventory transaction processing, from the India tax concurrent programs that generate CENVAT and VAT claims, and from accounting workflows that push entries to GL_INTERFACE. Because the documented metadata lists zero dependent packages — it is referenced by no other APPS package — custom development should be cautious: changes to this package can affect India tax accounting without a visible upstream dependency chain. Customizations should call the documented procedures only, respect period status checks in GL_PERIOD_STATUSES, and test in a controlled environment because the package writes tax claims and cost layers that are difficult to reverse once accounted.