Search Results ap_rect_match_pkg




Overview
Explore in AI Chat

Overview

AP_RECT_MATCH_PKG is a PL/SQL package owned by the APPS schema within Oracle E-Business Suite Release 12.1.1 and 12.2.2. Its name derives from "receipt match," and it forms part of the Payables (AP) subsystem responsible for reconciling supplier invoices against receiving transactions. The package supports the receipt-matching workflow, whereby an invoice line is validated against goods or services actually received, and it assists in correcting discrepancies in price or quantity that arise after an invoice has been matched. In practical terms, this package enables the matching engine to accept, adjust, or reverse receipt-based matches and to keep Payables and Purchasing records synchronized.

The package is classified as VALID in the ETRM repository and is documented under an API classification of OTHER, indicating it is primarily a supporting internal utility rather than a fully published public API.

Key Procedures and Functions

The documented metadata identifies two procedures within the package:

  • BASE_CREDIT_RCV_MATCH — Handles the baseline processing required to credit a receipt match. It supports reversal or offsetting of amounts previously matched to a receipt, ensuring the Payables records reflect the corrected match position.
  • PRICE_QUANTITY_CORRECT_INV_RCV — Addresses corrections to an invoice-to-receipt match where either price or quantity differs from the original match. It applies the adjustment so that the invoice line and the receipt aligned correctly.

These two procedures reflect the correction-oriented purpose of the package. Parameter lists are not documented in the available metadata and should be confirmed directly against the package specification in the target instance.

Tables Accessed

The package reads and writes a range of APPS synonyms, including AP_INVOICES, AP_INVOICES_ALL, AP_INVOICE_DISTRIBUTIONS, AP_INVOICE_DISTRIBUTIONS_ALL and the corresponding _S sequence-based synonyms, AP_INVOICE_LINES and AP_INVOICE_LINES_ALL. These tables hold the invoice header, distribution, and line detail that are adjusted during a receipt-match correction. AP_SUPPLIERS and AP_SUPPLIER_SITES_ALL supply supplier and site context. AP_SYSTEM_PARAMETERS and AP_SYSTEM_PARAMETERS_ALL, together with FINANCIALS_SYSTEM_PARAMETERS, provide Payables configuration values such as matching tolerances and accounting options. FA_BOOK_CONTROLS and AP_BATCHES support associated batch and asset book processing. AP_AWT_GROUPS relates to withholding tax handling.

Usage Notes

AP_RECT_MATCH_PKG is referenced by several other packages, notably AP_AUTO_DM_CREATION_PKG, AP_MATCHING_UTILS_PKG, and AP_QUICK_CREDIT_PKG, and it in turn depends on AP_MATCHING_PKG. This layering indicates that the package is invoked indirectly by the broader matching and quick-credit processes rather than being called directly from end-user forms in most cases. It is typically executed during invoice matching, automatic debit memo creation, or quick credit processing, where receipt matches must be reversed or corrected. Custom extensions should call the documented procedures only with a full understanding of the expected matching state, because these routines modify core Payables and matching records directly. Testing in a non-production environment is therefore recommended before deployment.