Search Results txn_complete

Overview

The APPS.INV_RECEIVING_TRANSACTION package body is a receiving-side PL/SQL component within Oracle E-Business Suite Inventory (INV). It provides the transactional processing logic used to validate, stage, and complete receiving transactions that originate from mobile receiving devices and standard receiving flows. In Oracle EBS 12.1.1 and 12.2.2, this package operates against the receiving interface tables (RCV_TRANSACTIONS_INTERFACE, MTL_MATERIAL_TRANSACTIONS_TEMP) and the receiving base tables (RCV_TRANSACTIONS), serving as the programmatic bridge between inbound receipt data and the Inventory/Receiving transaction processor. The package is classified as an OTHER API in the ETRM repository, meaning it is not a formal public API but is referenced and invoked internally by other packaged logic.

Key Procedures and Functions

Two documented procedures are exposed by this package body:

• TXN_COMPLETE — Drives the completion of a receiving transaction. This is the procedure most commonly associated with the search term "txn_complete," which reflects the internal completion step executed once receipt data has been staged and validated. It finalizes the transaction record, advancing processing and transaction status codes and triggering downstream writes to the Inventory transaction tables.
• TXN_MOBILE_TIMEOUT_CLEANUP — Performs housekeeping for mobile receiving sessions that have timed out. It cleans up stale or abandoned interface records left by mobile receiving users so that incomplete transactions do not block subsequent processing or corrupt interface state.

The package body also contains internal helper procedures, including print_debug (gated by the INV_DEBUG_TRACE profile option via FND_PROFILE.VALUE) and create_errors, which inserts diagnostic rows into PO_INTERFACE_ERRORS and marks interface rows as COMPLETED with a transaction status of ERROR when validation fails. Parameter lists are not reproduced here; the documented behavior is limited to the purposes described.

Tables Accessed

The package reads and writes a broad set of receiving, inventory, serial, lot, and warehouse management tables through APPS synonyms:

• Interface and error tables: RCV_TRANSACTIONS_INTERFACE, MTL_MATERIAL_TRANSACTIONS_TEMP, PO_INTERFACE_ERRORS, MTL_SERIAL_NUMBERS_INTERFACE, MTL_TRANSACTION_LOTS_INTERFACE, MTL_SERIAL_NUMBERS_TEMP, MTL_TRANSACTION_LOTS_TEMP, WMS_LPN_INTERFACE — staged input and error capture.
• Base transaction tables: RCV_TRANSACTIONS — the confirmed receipt record written on completion.
• Master and serial/lot data: MTL_SYSTEM_ITEMS, MTL_SERIAL_NUMBERS, MTL_TXN_REQUEST_LINES — item validation and serial/move-order line resolution.
• Warehouse management: WMS_LICENSE_PLATE_NUMBERS, WMS_LPN_CONTENTS, WMS_LPN_HISTORIES — LPN tracking within WMS-enabled organizations.

Usage Notes

INV_RECEIVING_TRANSACTION is typically invoked from mobile receiving forms, the receiving transaction processor, and custom code that stages receipts into the interface tables before calling TXN_COMPLETE to finalize them. Because it is classified as OTHER and referenced by only two other packages, it is intended for internal, version-coupled use rather than as a stable public API. Customizations that call it directly should be aware that its procedures and internal logic may change between point releases of 12.1.1 and 12.2.2. Debug tracing is controlled through the INV_DEBUG_TRACE profile option, and failures are surfaced through PO_INTERFACE_ERRORS rather than raised exceptions in all paths.