Search Results inv_receiving_transaction




Overview
Explore in AI Chat

Overview

INV_RECEIVING_TRANSACTION is a PL/SQL package owned by the APPS schema that forms part of the Oracle E-Business Suite receiving transaction infrastructure in Release 12.1.1 and 12.2.2. Its role is to complete and finalize receiving transactions after the receiving interface has staged the transaction data. The package bridges mobile and form-based receiving flows and the underlying Oracle Inventory transaction engine, ensuring that validated receiving records are posted to the correct inventory and lot/serial structures. It is classified under ETRM as an "OTHER" API rather than a formally published open interface, which reflects its internal, orchestrating nature: it is invoked by Oracle's own receiving and mobile processing components rather than being intended as a standalone public entry point for third-party integrations. It is marked VALID in the APPS schema and depends on the SYS STANDARD package.

Key Procedures and Functions

The ETRM metadata documents two procedures within INV_RECEIVING_TRANSACTION:

  • TXN_COMPLETE — Drives completion of a receiving transaction. It represents the point at which staged receipt, delivery, or return data is committed against the receiving transaction tables so that inventory balances and associated lot, serial, and LPN records are updated consistently.
  • TXN_MOBILE_TIMEOUT_CLEANUP — Handles cleanup of mobile receiving sessions that have timed out. Mobile receiving allows operators to accumulate transaction data on a handheld device; if a session is abandoned, this procedure clears the stale temporary data so that incomplete or orphaned records do not interfere with subsequent processing.

Consistent with ETRM practice, no parameter signatures are documented here; the documented purpose is at the transaction-completion and session-cleanup level rather than the individual argument level.

Tables Accessed

The package operates across the receiving, inventory, and warehouse management data model. It writes to and reads RCV_TRANSACTIONS and RCV_TRANSACTIONS_INTERFACE, the core receipt and interface tables, and to PO_INTERFACE_ERRORS for error handling on the purchasing side. It interacts with MTL_MATERIAL_TRANSACTIONS_TEMP as the transactional staging area for inventory movements. Serial and lot control are handled through MTL_SERIAL_NUMBERS, MTL_SERIAL_NUMBERS_INTERFACE, MTL_SERIAL_NUMBERS_TEMP, MTL_TRANSACTION_LOTS_INTERFACE, and MTL_TRANSACTION_LOTS_TEMP. Item validation references MTL_SYSTEM_ITEMS, and move-order linkage uses MTL_TXN_REQUEST_LINES. Warehouse Management support is provided through WMS_LICENSE_PLATE_NUMBERS, WMS_LPN_CONTENTS, WMS_LPN_HISTORIES, and WMS_LPN_INTERFACE, reflecting LPN-based receiving in 12.2.2.

Usage Notes

INV_RECEIVING_TRANSACTION is invoked indirectly rather than called directly by end users. The ETRM dependency listing shows that it is referenced by INV_RCV_MOBILE_PROCESS_TXN, RCV_ROI_PREPROCESSOR, and by INV_RECEIVING_TRANSACTION itself, indicating use from the mobile receiving path, from the ROI-based receiving preprocessor flow, and from recursive internal calls. In practice this means the package is exercised when users complete receipts through the Receiving forms, when mobile receiving handlers finalize transactions, and when receiving preprocessors submit records for posting. Because it is not a documented open interface, custom code should call the supported receiving public APIs and open interfaces rather than invoking this package directly; doing so risks bypassing validation and upgrade-sensitive logic. Data written by the package ultimately feeds the Oracle Inventory transaction processor through the temporary transaction tables listed above.