Search Results rcv_invoice_matching_sv




Overview
Explore in AI Chat

Overview

RCV_INVOICE_MATCHING_SV is a server-side PL/SQL package owned by the APPS schema in Oracle E-Business Suite. It provides the core receiving-side logic that supports Oracle Payables invoice matching against purchase order receipts. When an invoice is matched to a receipt in the Payables module, the application must determine how much of the ordered quantity has actually been received and delivered, and the corresponding amounts that may be matched. RCV_INVOICE_MATCHING_SV encapsulates this calculation logic and exposes it through a small set of public functions.

The package is classified as an "OTHER" API rather than a formal public interface, meaning it is primarily an internal implementation component. Its status is VALID, and it is compiled and present in both Oracle EBS 12.1.1 and 12.2.2 environments. The package relies on FND_API and the SYS.STANDARD package for its foundational services.

Key Procedures and Functions

ETRM documents four callable units within the package:

  • NAMES — Returns the package or object name identifier, consistent with the standard EBS convention used by many server-side packages to expose their own name programmatically for diagnostics and logging.
  • NAME — A companion function that returns the name of the current package or module, typically used in error handling and message construction.
  • GET_RECEIVEAMOUNT — Returns the received amount associated with a given receipt or shipment line. This value drives the quantity and amount available for invoice matching on the receiving side.
  • GET_DELIVERAMOUNT — Returns the delivered amount for a receipt or shipment line. Delivered amounts, as distinct from received amounts, are the basis used when two-way or three-way matching rules are applied in Payables.

No parameter lists are documented in the ETRM metadata, and callers should reference the actual package specification for the precise signature. The two GET functions form the functional core; the NAME and NAMES utilities support internal diagnostics.

Tables Accessed

The package reads from several key purchasing and receiving tables through APPS synonyms:

  • RCV_SHIPMENT_LINES — The receiving shipment line table, which stores quantity received and delivered information used by GET_RECEIVEAMOUNT and GET_DELIVERAMOUNT.
  • RCV_TRANSACTIONS — Detailed receiving transaction records, providing the underlying movement data that drives shipment line quantities.
  • PO_LINE_LOCATIONS — Purchase order shipment and distribution schedule lines, linking the receipt back to the ordered quantity.
  • PO_DISTRIBUTIONS — Purchase order distribution records, used to relate receipt quantities to accounting distributions for matching purposes.

These tables are read to reconcile received quantities against ordered quantities and to compute the amounts that Payables may match.

Usage Notes

RCV_INVOICE_MATCHING_SV is referenced by seven other packages, including AP_APPROVAL_MATCHED_PKG, AP_MATCHING_PKG, AP_MATCHING_UTILS_PKG, AP_RCT_AMT_MATCH_PKG, AP_RECT_MATCH_PKG, and INL_SHIPMENT_PVT. This dependency pattern confirms that the package is invoked indirectly by the Payables matching engine and by receiving-related processes rather than being called directly by end users.

Typical invocation occurs during invoice validation and matching when Oracle Payables must determine the matchable received or delivered amount for a receipt line. Custom code that needs to reproduce the same amount logic should call the GET_RECEIVEAMOUNT and GET_DELIVERAMOUNT functions rather than reimplementing the calculations. Because the package is an internal component, Oracle does not guarantee API stability, and customizations should be validated against each target release during upgrades from 12.1.1 to 12.2.2.