Search Results get_received_quantity

Overview

APPS.RCV_ACCRUAL_SV is a server-side PL/SQL package in Oracle E-Business Suite that supports period-end accrual processing and retroactive price adjustment accounting within the Receiving (RCV) and Purchasing (PO) modules. The package is declared with AUTHID CURRENT_USER, meaning its SQL statements execute with the privileges of the invoking user rather than the package owner, a standard convention for Oracle EBS public APIs to preserve invoker's rights semantics. Its central responsibility is to resolve and return transaction quantities — ordered, received, corrected, delivered, returned to vendor, billed, and accepted — in the purchase order's unit of measure, given a transaction identifier and an accrual cutoff date. These quantities feed downstream accounting logic, notably the period end accruals concurrent program and the accounting events API used when accounting for retroactive price changes. The package is classified under the ETRM "OTHER" API classification, indicating it is an internal service routine rather than a formally published open interface or public API.

Key Procedures and Functions

The ETRM metadata documents three callable units in this package:

• GET_QUANTITIES — The core procedure. Given a transaction identifier, it returns the full set of transaction quantities: ordered, received, corrected, delivered, returned to vendor, billed, and accepted. The two public functions below are described in the source header as wrappers that call this API, making GET_QUANTITIES the foundational routine for quantity resolution in this package.
• GET_RECEIVED_QUANTITY — A function that accepts a RECEIVE or MATCH transaction identifier and returns the quantity received in the PO's unit of measure. It is documented as a function wrapper over GET_QUANTITIES and is invoked from the period end accruals concurrent program when the match option is set to match to receipt. The source includes a PRAGMA RESTRICT_REFERENCES declaration (WNDS), confirming the function performs no database writes.
• GET_DELIVERED_QUANTITY — A function that accepts a DELIVER transaction identifier and returns the quantity delivered in the PO's unit of measure. Like GET_RECEIVED_QUANTITY, it is a wrapper over GET_QUANTITIES, and is documented as being called from the accounting events API during accounting for retroactive price changes.

Each of these units operates on the purchaser's unit of measure, ensuring that quantity values returned are directly usable by purchasing and accounting processes without additional UOM conversion steps. The package metadata lists only these three documented units; no undocumented public entry points are asserted here.

Tables Accessed

The package operates against three core Receiving and Purchasing tables, accessed through APPS synonyms:

• RCV_TRANSACTIONS — The primary source of receiving transaction detail, including receipts, deliveries, corrections, returns, and matches. Transaction identifiers passed into the package routines resolve against this table to derive the requested quantities.
• RCV_SHIPMENT_LINES — Provides shipment-level receiving information associated with the transaction, supporting reconciliation of received and delivered quantities against the expected shipment.
• PO_LINE_LOCATIONS — Supplies the purchase order shipment/schedule context, most importantly the ordered quantity and the PO unit of measure used to normalize the returned quantity values.

The package is documented as read-oriented in practice: the RESTRICT_REFERENCES pragma on GET_RECEIVED_QUANTITY guarantees no writes to package or database state, consistent with a query service whose role is to supply quantity facts to accrual and accounting logic rather than to create or modify receiving records.

Usage Notes

RCV_ACCRUAL_SV is an internal service package rather than an end-user API. It is typically invoked indirectly by Oracle EBS application logic and by custom extensions rather than from a receiving form directly. Primary invocation paths include the period end accruals concurrent program (through GET_RECEIVED_QUANTITY when the match option is set to match to receipt) and the accounting events API during retroactive price change accounting (through GET_DELIVERED_QUANTITY). The package is referenced by two other packages within the APPS schema, confirming its role as a shared quantity-resolution dependency. Custom developers extending accrual or receiving-related processes may call these routines directly, but should treat them as internal interfaces subject to change across releases. As with all ETRM-cataloged objects, the documented version reflects the 12.1.1 / 12.2.2 code line; the source header revision string dates the package lineage to 2005, indicating a long-stable internal interface within RCV.