Search Results create_osp_std_rcvtxn_intf_rec




Overview
Explore in AI Chat

Overview

INV_RCV_STD_DELIVER_APIS is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite. It belongs to the Oracle Inventory and Receiving (INV/RCV) module family and forms part of the receiving transaction API stack. Its role is to construct and manage the receiving transaction interface records that the standard receiving engine uses to process deliveries, put-aways, and related inventory movements. In Oracle EBS 12.1.1 and 12.2.2 the package is documented as VALID with an API classification of OTHER, indicating an internal utility API layer rather than a formally published open interface.

The package is tightly coupled with APPS.INV_RCV_COMMON_APIS, which it both references and is referenced by, and it depends on the SYS.STANDARD package for standard PL/SQL constructs. The relationship with INV_RCV_COMMON_APIS is significant: the two packages cooperate to populate and validate the receiving transaction interface tables before the receiving processor consumes them.

Key Procedures and Functions

Seven documented routines are associated with this package:

  • INSERT_LOT_SERIAL — Inserts lot and/or serial number information into the interface structures used during receiving, supporting lot-controlled and serial-controlled item transactions.
  • CREATE_OSP_STD_RCVTXN_INTF_REC — Creates standard receiving transaction interface records for outside processing (OSP) scenarios, where receipt is tied to a supplier service or processing step.
  • CREATE_STD_RCVTXN_INTF_REC — Creates standard receiving transaction interface records for ordinary purchase order and internal receipts.
  • CREATE_PUTAWAY_RCVTXN_INTF_REC — Creates interface records for put-away transactions, moving received material into its final stocking location.
  • RCVTXN_CLEAR_GLOBAL — Clears package-level global variables, resetting internal state between receiving transaction invocations.
  • UPDATE_RCV_SERIALS_SUPPLY — Updates serial number supply information as part of the receiving flow, keeping serial supply records synchronized with receipt processing.
  • MATCH_PUTAWAY_RCVTXN_INTF_REC — Matches put-away interface records, reconciling generated put-away rows against existing receiving transaction data.

Parameter lists are not reproduced here; only the documented routine names and their functional intent are described.

Tables Accessed

The package reads and writes inventory and receiving base tables through APPS synonyms. Key tables include MTL_MATERIAL_TRANSACTIONS_S and MTL_MATERIAL_TRANSACTIONS_TEMP for transaction staging, MTL_LOT_NUMBERS and MTL_SERIAL_NUMBERS for lot/serial control, MTL_SERIAL_NUMBERS_INTERFACE and MTL_SERIAL_NUMBERS_TEMP for serial interface staging, MTL_TRANSACTION_LOTS_INTERFACE and MTL_TRANSACTION_LOTS_TEMP for lot interface staging, and MTL_TXN_REQUEST_LINES for move order lines. Setup and validation tables include MTL_PARAMETERS, MTL_SYSTEM_ITEMS, MTL_SECONDARY_INVENTORIES, MTL_UNITS_OF_MEASURE, HR_ORGANIZATION_INFORMATION, and MO_GLOB_ORG_ACCESS_TMP for organization access checking.

Usage Notes

This package is invoked internally by the standard receiving flow, including the Receiving Transactions and Receiving Open Interface processes, and by warehouse management components. It is referenced by GML_RCV_DIR_RCPT_APIS, INV_RCV_COMMON_APIS, INV_RCV_DIR_RCPT_APIS, INV_RCV_STD_TRANSFER_APIS, and WMS_TASK_DISPATCH_PUT_AWAY, confirming its role as a shared dependency in receiving and put-away processing. Custom code should generally call the supported Receiving APIs or open interfaces rather than this package directly, since it is an internal utility layer without a documented public contract.