Results for “inv_rcv_std_transfer_apis”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

INV_RCV_STD_TRANSFER_APIS is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite. It provides the application programming interface layer for the standard transfer flow between Receiving (RCV) and Inventory (INV). Its central role is to create and match receiving transaction records that represent the movement of material from a receiving location into inventory, enabling standard receipt-based transfers to be processed programmatically rather than only through the Receiving forms. The package is documented as VALID in the ETRM metadata for release 12.2.2, and the same object exists in 12.1.1, confirming its status as a supported, production-critical component of the logistics and inventory stack.

Key Procedures and Functions

The ETRM metadata documents two entry points for this package:

• CREATE_TRANSFER_RCVTXN_REC — Builds the receiving transaction record that drives a standard transfer. It assembles the receiving transaction data required to represent the transfer of goods, validating source information such as the purchase order line, order line, and lot or serial attributes before staging the record for downstream processing.
• MATCH_TRANSFER_RCVTXN_REC — Matches a previously constructed transfer receiving transaction record against the corresponding inbound receipt or interface record. This procedure is responsible for reconciling the recorded transfer transaction with the expected receiving data so that quantity and valuation processing can proceed consistently.

No parameter lists are published in the ETRM metadata, so callers should rely on the current Oracle documentation and the package specification for signature details.

Tables Accessed

The package reads and writes through APPS synonyms. The core transactional tables are MTL_MATERIAL_TRANSACTIONS_TEMP and MTL_MATERIAL_TRANSACTIONS_S, which hold the staged and posted material transaction rows for the transfer. Lot and serial control is supported through MTL_LOT_NUMBERS, MTL_TRANSACTION_LOTS_INTERFACE, MTL_SERIAL_NUMBERS, and MTL_SERIAL_NUMBERS_INTERFACE. Item and unit-of-measure validation uses MTL_SYSTEM_ITEMS and MTL_UNITS_OF_MEASURE, while location and warehouse context come from MTL_SECONDARY_INVENTORIES, HR_ORGANIZATION_INFORMATION, and MO_GLOB_ORG_ACCESS_TMP. Source document detail is drawn from OE_ORDER_LINES_ALL, PO_LINES, PO_LINE_LOCATIONS, and RCV_INTERFACE_GROUPS_S, which links the transfer to its originating order or receipt interface grouping.

Usage Notes

INV_RCV_STD_TRANSFER_APIS is not exposed as a concurrent program or form in its own right; it is invoked programmatically. Its documented reference relationships show that it is referenced by WMS_RCV_PUP_PVT and WMS_TASK_DISPATCH_PUT_AWAY, indicating that Warehouse Management System put-away and receiving processing logic calls into this package to stage and match transfer transactions. Custom extensions that automate receiving-to-inventory transfers, such as inbound integration interfaces, may also call the documented procedures. Because the package manipulates interface and temporary transaction tables before posting to MTL_MATERIAL_TRANSACTIONS_S, callers must supply properly validated inventory items, lots, serials, and source document references. All activity should execute under a valid APPS responsibility with the required organization context set, and the package should be called within the standard transaction control framework to preserve inventory accuracy.