Search Results rcv_shipment_object_sv




Overview
Explore in AI Chat

Overview

APPS.RCV_ASN_TRX_INSERT is a PL/SQL package within the Oracle E-Business Suite Receiving (RCV) application schema. Its principal business function is to process Advance Shipment Notice (ASN) data and convert it into receiving transactions within the RCV transaction interface. The package participates in the inbound logistics flow where suppliers or trading partners transmit shipment notifications ahead of physical goods, allowing the receiving organization to pre-stage the expected receipts. RCV_ASN_TRX_INSERT is responsible for inserting transactional records that represent ASN activity, including the handling of cancelled ASN lines, so downstream receiving processes can reconcile expected versus actual quantities. In the context of EBS 12.1.1 and 12.2.2, the package sits in the integration layer between the ASN staging structures and the standard RCV transaction interface, forming part of the chain that feeds the receiving transaction processor.

Key Procedures and Functions

The ETRM registry documents two procedures for this package, classified under the generic API classification "OTHER":

  • HANDLE_RCV_ASN_TRANSACTIONS — The primary driver procedure. It orchestrates the processing of ASN-related records and is responsible for inserting the appropriate rows into the RCV transaction interface based on the ASN data passed or staged. It represents the main entry point for converting ASN information into receiveable transactions.
  • INSERT_CANCELLED_ASN_LINES — A supporting procedure that specifically addresses cancelled ASN lines. When an ASN line is cancelled, this procedure ensures the corresponding cancellation record is inserted into the transaction interface so that the receiving process can account for the reduction or reversal of the expected quantity.

No parameter lists are documented in the metadata, and none are asserted here. The two procedures operate together to cover both the normal and cancellation paths of ASN transaction generation.

Tables Accessed

The package references the following base tables through APPS synonyms:

  • RCV_SHIPMENT_LINES — The receiving shipment lines table, holding the line-level detail of expected shipments. The package reads shipment line information to determine the quantity and item context for transactions it generates.
  • RCV_TRANSACTIONS_INTERFACE — The inbound interface table into which receiving transactions are loaded before processing. The package inserts ASN-derived rows here for subsequent validation and processing by the standard receiving transaction processor.
  • RCV_TRANSACTIONS_INTERFACE_S — The sequence backing the interface table, used to generate unique interface identifiers for each inserted row.
  • PLITBLM — A standard Oracle Applications character-table structure, typically used for passing lists of values between PL/SQL constructs.

Usage Notes

RCV_ASN_TRX_INSERT is not a user-facing form package. It is invoked programmatically as part of ASN processing. Its dependencies include RCV_SHIPMENT_HEADER_SV and RCV_SHIPMENT_OBJECT_SV, and it is itself referenced by those same packages plus RCV_ASN_TRX_INSERT itself, confirming it operates within the Shipment Server-View API layer. The user search term "rcv_shipment_object_sv" reflects this relationship; RCV_SHIPMENT_OBJECT_SV is the object-oriented shipment view API that, together with RCV_SHIPMENT_HEADER_SV, participates in the circular dependency with this package. In practice, custom ASN integrations and Oracle's own ASN workflows call this package to load interface rows, after which the Receiving Transaction Processor is run to validate and post them into the receiving tables. Because it writes directly into the interface tables, any custom invocation must respect interface integrity and commit semantics expected by the downstream processor.