Search Results update_rcv_lines




Overview
Explore in AI Chat

Overview

JAI_RCV_RGM_CLAIMS_PKG is an Oracle E-Business Suite PL/SQL package owned by the APPS schema that supports the Oracle India Localization (JAI) tax and claims processing requirements associated with receipt accounting. Its primary business function is to create and manage VAT processing and tax claim accounting entries for receipts, returns to vendor (RTV), and return material authorizations (RMA) originating in Oracle Receiving. The package was originally introduced in January 2005 to support VAT processing and has since been maintained to comply with case-sensitivity standards, the elimination of Receiving Transactions descriptive flexfields, and corrections to VAT claim accounting entry generation.

The package interacts closely with the companion source and body files jai_rcv_rgm_clm.pls and jai_rcv_rgm_clm.plb, on which it has a documented high dependency. It resides within the JAI Receiving/Regime claims module and is referenced by one other package, indicating that it serves as a foundational utility for downstream tax claim processing logic.

Key Procedures and Functions

The package exposes ten documented procedures and functions:

  • GET_LOCATION — Retrieves location information, typically deriving the ship-to or receiving location needed to determine applicable tax regimes.
  • GENERATE_SCHEDULE — Builds the schedule used for claim processing against receipt lines.
  • INSERT_RCV_LINES — Inserts the receiving lines that form the basis for claim and VAT processing records.
  • UPDATE_RCV_LINES — Updates receiving line records and sets the process status flag. It accepts a shipment header identifier parameter, added to resolve a defect in which partial-versus-full claim determination failed when a full claim occurred in the first installment.
  • PROCESS_VAT — Handles VAT computation and processing for the receipt lines.
  • PROCESS_CLAIM — Executes claim logic for lines determined to be claimable.
  • PROCESS_NO_CLAIM — Handles lines that are determined not to be claimable.
  • PROCESS_BATCH — Drives batch processing across multiple lines or organizations.
  • DO_RTV_ACCOUNTING — Generates the accounting entries associated with return-to-vendor transactions.
  • DO_RMA_ACCOUNTING — Generates the accounting entries associated with RMA transactions.

Tables Accessed

The package reads and writes a range of Receiving, Inventory, and tax reference tables, accessed through APPS synonyms. On the receiving side, it references RCV_SHIPMENT_HEADERS, RCV_SHIPMENT_LINES, and RCV_TRANSACTIONS, together with JAI_RCV_LINES, JAI_RCV_RGM_LINES, and JAI_RCV_TRANSACTIONS, which store the localization claim and transaction detail. Claim definitions and terms come from JAI_RGM_DEFINITIONS and JAI_RGM_TERMS. Tax reference data is obtained from JAI_CMN_TAXES_ALL. Organizational and location context is resolved via HR_ALL_ORGANIZATION_UNITS and HR_LOCATIONS_ALL. Accounting output is routed through GL_INTERFACE, while payable-side tax matching uses AP_INVOICE_DISTRIBUTIONS_ALL, JAI_AP_MATCH_INV_TAXES, and JAI_INV_SUBINV_DTLS.

Usage Notes

JAI_RCV_RGM_CLAIMS_PKG is invoked in the context of Receiving transaction processing and claim accounting for the India Localization. It is typically called from concurrent programs, localization forms, or custom code that automates VAT claim generation immediately after receipt, RTV, or RMA activity. Because the package maintains shipment-level state and writes accounting entries into GL_INTERFACE, it should not be modified or called outside supported localization flows. Customers implementing or supporting Oracle EBS 12.1.1 or 12.2.2 who search on "insert_rcv_lines" should note that INSERT_RCV_LINES and UPDATE_RCV_LINES form the core line-maintenance pair, with the latter requiring the shipment header identifier to correctly set claim status.