Search Results insert_lot_supply

Overview

RCV_PROCESSOR_PVT is a private (PVT-classified) PL/SQL package owned by the APPS schema in Oracle E-Business Suite. It forms part of the Receiving Open Interface (ROI) processor infrastructure, which is responsible for validating, defaulting, and applying inbound receiving transaction data submitted through RCV_TRANSACTIONS_INTERFACE. The package encapsulates the low-level logic used to persist and maintain supplementary receiving entities — lot and serial supply records, lot transaction rows, and license plate number (LPN) group validations — that accompany standard receipt, delivery, and return transactions.

The PVT classification indicates that the package is intended for internal use by Oracle's own receiving programs rather than as a public integration API. Custom code should generally target the RCV_*_PUB packages or the Receiving Open Interface itself, treating RCV_PROCESSOR_PVT as an implementation detail. The package is documented as VALID in both 12.1.1 and 12.2.2, meaning it is compiled and operational in the ETRM reference environment.

Key Procedures and Functions

Nine procedures are documented. Their purposes are as follows:

• INSERT_RCV_LOTS_SUPPLY — Creates lot supply records in RCV_LOTS_SUPPLY, associating on-hand lot quantities with a receiving transaction for subsequent application.
• INSERT_RCV_SERIALS_SUPPLY — Creates serial supply records in RCV_SERIALS_SUPPLY, capturing serialized units tied to an inbound transaction.
• INSERT_LOT_SUPPLY — A lower-level helper that inserts an individual lot supply row, typically invoked by the higher-level lot supply procedure.
• INSERT_SERIAL_SUPPLY — The equivalent single-row helper for serial supply insertion.
• INSERT_LOT_TRANSACTIONS — Populates RCV_LOT_TRANSACTIONS, recording the lot-level detail of the receiving transaction for audit and downstream inventory updates.
• UPDATE_RCV_LOTS_SUPPLY — Maintains existing lot supply rows when quantities or attributes change during processing.
• UPDATE_RCV_SERIALS_SUPPLY — Maintains existing serial supply rows under the same circumstances.
• SPLIT_SERIAL_NUMBER — Handles serial number splitting, supporting scenarios where a serialized quantity must be divided across multiple receiving lines.
• VALIDATE_LPN_GROUPS — Validates LPN (license plate number) group consistency before transaction application, preventing invalid container hierarchies from being processed.

Tables Accessed

The package reads and writes through APPS synonyms. RCV_TRANSACTIONS_INTERFACE and RCV_HEADERS_INTERFACE supply the inbound interface data being processed. RCV_LOTS_SUPPLY, RCV_SERIALS_SUPPLY, RCV_LOT_TRANSACTIONS, and RCV_SUPPLY are the primary output tables where supply and lot transaction detail is materialized. RCV_TRANSACTIONS and RCV_SHIPMENT_HEADERS/RCV_SHIPMENT_LINES provide the applied receiving transaction and shipment context. MTL_SYSTEM_ITEMS, MTL_TRANSACTION_LOTS_TEMP, and MTL_SERIAL_NUMBERS_TEMP support item validation and temporary lot/serial staging. PO_INTERFACE_ERRORS is used to record validation failures that must be reported back to the submitting process or user.

Usage Notes

RCV_PROCESSOR_PVT is invoked by Oracle's receiving processor framework — notably the Receiving Transaction Processor concurrent program and the Receiving Open Interface — rather than directly from Oracle Forms. It is not referenced by any other APPS package according to the dependency metadata, indicating that it sits near the leaf of the call hierarchy and is driven by the processor that consumes RCV_TRANSACTIONS_INTERFACE rows. Because it is a PVT package with no public API wrapper, direct invocation from custom code is strongly discouraged; developers requiring equivalent functionality should use the published Receiving APIs or the open interface tables. Its only documented dependency is on the STANDARD package and the APPS synonyms listed, reflecting its narrow, transactional role.