Results for “insert_transaction_interface”

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

Overview

APPS.POR_RCV_TRANSACTION_SV is a PL/SQL server-side package in Oracle E-Business Suite that encapsulates receiving transaction logic for the Purchasing and Oracle Receiving modules. The suffix _SV denotes a "server validation" or server-side utility package that centralizes the manipulation of receiving data — principally the staging and processing of rows in the Receiving Transactions Interface. It provides a programmatic entry point for inserting receipt and delivery records into the interface tables and for driving the subsequent processing that converts those interface rows into confirmed receiving transactions. In the ETRM 12.2.2 documentation the package is classified under API type OTHER, indicating it is an internal, non-public API intended for use by other EBS components rather than as a supported external interface. Its status is VALID.

Key Procedures and Functions

• INSERT_TRANSACTION_INTERFACE — Inserts a receiving transaction record into the Receiving Transactions Interface, staging the data required for later validation and processing.
• PROCESS_TRANSACTIONS — Drives the processing of staged interface rows, invoking the receiving transaction logic that finalizes receipts, deliveries, and returns.
• GET_NET_DELIVERED_QTY — Returns the net delivered quantity for a receipt or shipment line, typically derived from confirmed receiving transactions.
• GET_NET_RETURNED_QTY — Returns the net returned quantity associated with a receipt or shipment line, accounting for return transactions.
• GET_SHIPMENT_NUM — Retrieves the shipment number associated with a given receiving or shipping record.

These routines support both the write path (staging and processing transactions) and the read path (quantity and shipment lookups used by dependent views and packages).

Tables Accessed

The package reads and writes several core EBS tables through APPS synonyms. The interface and transactional receiving data reside in RCV_TRANSACTIONS_INTERFACE, RCV_TRANSACTIONS_INTERFACE_S, RCV_TRANSACTIONS, RCV_SHIPMENT_HEADERS, and RCV_SHIPMENT_LINES. Purchasing data is drawn from PO_HEADERS_ALL and PO_LINES_ALL, with error conditions logged to PO_INTERFACE_ERRORS. Order information comes from OE_ORDER_HEADERS_ALL. Item and unit-of-measure validation use MTL_SYSTEM_ITEMS and MTL_UNITS_OF_MEASURE. FND_USER supplies user context, and DUAL is used for single-row selection.

Usage Notes

The package is referenced by POR_CONFIRM_INTERNAL_RECEIPT_V and POR_RCV_ORD_REQUESTER_V, and is referenced by two other packages, indicating it functions as an internal dependency within the Purchasing/Receiving stack. It is typically invoked indirectly through Receiving forms, the Receiving Transaction Processor concurrent program, or other EBS packages rather than being called directly from custom code. Because it is classified OTHER, direct invocation in customizations carries upgrade risk; developers should prefer supported public APIs such as the Receiving Open Interface. References to SYS.STANDARD confirm the package body is a standard compiled PL/SQL unit.