Search Results get_qty_delivered

Overview

POA_EDW_SUPPERF is a PL/SQL package owned by the APPS schema that provides the data extraction and calculation logic behind Oracle EBS supplier performance reporting. In the Oracle E-Business Suite 12.1.1 and 12.2.2 releases, this package supports the Procurement and Spend Analytics / Enterprise Data Warehouse (EDW) content that measures how suppliers perform against purchase orders, receipts, and invoices. The package consolidates supplier performance metrics — receipt activity, shipped and delivered quantities, invoicing timing, and invoice price variance — into a form that can be consumed by the supplier performance fact collection views and dashboards.

The package is classified as OTHER in the ETRM metadata, meaning it is not a public, documented business API but an internal supporting package invoked by other EBS objects. Its status is VALID in the APPS schema, and it is referenced by three other packages: POA_EDW_SUPPLIER_PERFORM_FCV, POABV_EDW_SUPPLIER_PERFORM_FCV, and POA_CUSTOMIZATION_PKG.

Key Procedures and Functions

The package exposes twelve documented procedures and functions, each returning a discrete supplier performance metric:

• GET_FIRST_RECEIPT_DATE — Returns the date of the earliest receipt recorded for a supplier or related transaction set.
• GET_LAST_RCV_TRX_DATE — Returns the date of the most recent receiving transaction.
• GET_QTY_SHIPPED — Returns the quantity shipped against the applicable purchasing document.
• GET_QTY_DELIVERED — Returns the quantity delivered.
• GET_QTY_RECEIVED — Returns the quantity received into inventory.
• GET_QTY_PASTDUE — Returns the quantity that remains outstanding past its scheduled due date.
• GET_NUM_RECEIPTS — Returns the count of receipts associated with the transaction set.
• FIND_BEST_PRICE — Determines the best (lowest or most favorable) price for the item or supplier comparison.
• GET_RCV_TXN_QTY — Returns the quantity recorded on a specific receiving transaction.
• GET_INVOICE_DATE — Returns the invoice date associated with the matched transaction.
• GET_DAYS_TO_INVOICE — Returns the elapsed days between receipt/delivery and invoice, a key supplier responsiveness metric.
• GET_IPV — Returns the invoice price variance, measuring the difference between purchase order price and invoiced price.

Parameter lists are not documented in the ETRM metadata and are therefore not reproduced here; callers should inspect the package specification in the APPS schema.

Tables Accessed

The package reads from core Oracle Purchasing, Receiving, and Payables tables through APPS synonyms:

• PO_HEADERS_ALL, PO_LINES_ALL, PO_LINE_LOCATIONS_ALL, PO_DISTRIBUTIONS_ALL — Supply the purchase order header, line, shipment, and distribution context against which supplier performance is measured.
• RCV_SHIPMENT_LINES and RCV_TRANSACTIONS — Provide receiving shipment and transaction detail used by the quantity, receipt count, and date functions.
• AP_INVOICE_DISTRIBUTIONS_ALL — Supplies invoice distribution data for invoice date, days-to-invoice, and invoice price variance calculations.
• FINANCIALS_SYSTEM_PARAMS_ALL — Provides system-level financial parameters used to govern calculation behavior.

Usage Notes

POA_EDW_SUPPERF is not intended for direct invocation by end users or ordinary custom code. It is typically called by the supplier performance fact collection views (POA_EDW_SUPPLIER_PERFORM_FCV and POABV_EDW_SUPPLIER_PERFORM_FCV) during the load of the Procurement and Spend Analytics data warehouse, and it may be extended or overridden through POA_CUSTOMIZATION_PKG. Because it resides in the APPS schema and depends on internal EBS table structures, any customer extension should be performed through the supported customization package rather than by modifying POA_EDW_SUPPERF directly, preserving upgrade safety across 12.1.1 and 12.2.2.