Results for “get_net_delivered_qty”

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

Overview

POR_RCV_TRANSACTION_SV is an Oracle E-Business Suite PL/SQL package body owned by the APPS schema. Its name identifies it as a server-side validation and processing utility ("_SV") within the Purchasing/Receiving module family (POR prefix). The package encapsulates the logic Oracle Receiving uses to accept receipt and delivery transactions submitted through the Receiving Open Interface and to derive shipment-level quantity information. It acts as a buffer between inbound transaction data staged in RCV_TRANSACTIONS_INTERFACE and the validated records that ultimately post to RCV_TRANSACTIONS, the core receiving transaction table.

The package fetches user identity, organization context, item and unit-of-measure validation data, purchase order and shipment detail, and error messaging services through the APPS synonym layer. This design allows Receiving forms, concurrent interface processors, and custom integrations to submit receiving transactions through a single, controlled code path rather than inserting directly into the receiving transaction tables.

Key Procedures and Functions

• INSERT_TRANSACTION_INTERFACE — Populates RCV_TRANSACTIONS_INTERFACE with transaction rows, preparing the inbound receipt or delivery data structures that the Receiving Open Interface subsequently processes.
• PROCESS_TRANSACTIONS — Drives the main processing flow that validates and transfers staged interface records toward RCV_TRANSACTIONS, applying the applicable business rules and error handling.
• GET_NET_DELIVERED_QTY — Returns the net quantity delivered for a shipment or transaction reference, netting deliveries against returns.
• GET_NET_RETURNED_QTY — Returns the net quantity returned, used to reconcile against delivered quantities.
• GET_SHIPMENT_NUM — Resolves and returns the shipment number associated with a receiving transaction or its source order.

These five documented procedures constitute the public surface of the package. Parameter lists are intentionally not enumerated here; refer to the installed package specification in the APPS schema for exact signatures.

Tables Accessed

• RCV_TRANSACTIONS_INTERFACE / RCV_TRANSACTIONS_INTERFACE_S — The staging area for inbound receipt transactions and its sequence; written by INSERT_TRANSACTION_INTERFACE.
• RCV_TRANSACTIONS, RCV_SHIPMENT_HEADERS, RCV_SHIPMENT_LINES — Core receiving tables consulted to validate shipments and derive delivered and returned quantities.
• PO_HEADERS_ALL, PO_LINES_ALL, PO_VENDOR_SITES, PO_UOM_S — Purchase order, supplier site, and unit-of-measure reference data used for validation.
• MTL_SYSTEM_ITEMS, MTL_UNITS_OF_MEASURE — Item and UOM validation against the inventory master.
• OE_ORDER_HEADERS_ALL — Source order context for RMA or sales-order-driven receipts.
• FND_USER, HR_EMPLOYEES_CURRENT_V, FND_PROFILE, FND_MESSAGE, FND_GLOBAL, MO_GLOBAL, ERROR_STACK — User identity, profile option, messaging, multi-org, and error-stack services.
• PO_INTERFACE_ERRORS — Error records captured when validation fails.

Usage Notes

POR_RCV_TRANSACTION_SV is typically invoked by the Receiving Open Interface concurrent program and by the Receiving forms when transactions are entered or corrected. It is also a valid call point for custom PL/SQL that must stage receiving transactions without direct DML against the interface or transaction tables. The package is not referenced by other database objects, indicating it sits near the top of its call chain; it is referenced by two other packages that consume its quantity and shipment-number functions. Because it depends on MO_GLOBAL, callers should ensure the correct operating unit context is initialized before invocation. Organizations running 12.1.1 and 12.2.2 should treat the package as Oracle-owned and avoid modification; extensions should call the documented procedures rather than replicate their logic.