Search Results inv_rcv_dir_rcpt_apis




Overview
Explore in AI Chat

Overview

INV_RCV_DIR_RCPT_APIS is an Oracle E-Business Suite PL/SQL package owned by the APPS schema that supports the "direct receipt" flow within Oracle Inventory and Oracle Receiving. A direct receipt is a transaction that moves material into inventory or performs a receipt-to-inventory/return-to-vendor style movement without routing through the standard multi-step receiving open interface. In practice this package is used to create receiving transactions and the associated material transaction records programmatically, allowing integration points such as warehouse management, RFID-driven processes, and bespoke extensions to post receipts directly against an organization, item, and source document.

The package is classified as a general utility/API ("OTHER") rather than a public interface, meaning it is primarily intended for internal use by Oracle Receiving functionality and selected integration callers, although it is callable from custom code. In the ETRM 12.2.2 metadata the package is marked VALID and references only the SYS.STANDARD package plus underlying database objects, indicating it is a self-contained procedural unit with no dependency on other APPS packages. It is referenced by the WMS_RFID_DEVICE_PUB package, confirming its role in RFID/warehouse mobility receipt scenarios.

Key Procedures and Functions

The package exposes two documented procedures:

  • CREATE_DIRECT_RTI_REC — creates a direct receipt-to-inventory record. "RTI" denotes receipt-to-inventory, i.e., the movement of received goods directly into an inventory location without an intermediate delivery step. The procedure writes the receiving header/line transaction and the corresponding inventory material transaction.
  • CREATE_OSP_DIRECT_RTI_REC — the OSP (outside processing) variant of the same operation. It handles direct receipt-to-inventory for outside-processing receipts, where material is received back from a supplier performing a service. This variant accommodates the additional cost and distribution logic associated with outside processing.

No parameter lists are reproduced here, as the ETRM metadata documents only procedure names and purpose.

Tables Accessed

The package reads and writes the core receiving, inventory, and cost tables via APPS synonyms:

Usage Notes

INV_RCV_DIR_RCPT_APIS is typically invoked from internal Receiving logic, RFID/WMS device integrations (via WMS_RFID_DEVICE_PUB), and custom extensions that post direct receipts. It is not a user-facing concurrent program. Customers extending EBS should call it only after validating item, lot/serial, subinventory, and transaction date inputs, and should wrap calls in proper transaction control. Because it is classified as a non-public API, Oracle does not guarantee signature stability across releases, so custom code should be regression tested on any upgrade between 12.1.1 and 12.2.2.