Search Results execute_matched_checks




Overview
Explore in AI Chat

Overview

APPS.AP_APPROVAL_MATCHED_PKG is a PL/SQL package in the Oracle E-Business Suite Payables (AP) module that governs the validation and approval logic applied specifically to matched invoices. A matched invoice is one that has been associated with a purchase order (PO), receipt, or both through the Payables matching process, and it is therefore subject to additional controls that do not apply to non-matched invoices. This package consolidates the checks that determine whether a matched invoice is eligible to proceed through the approval workflow, whether holds must be applied, and whether funds must be reserved or validated. In Oracle EBS 12.1.1 and 12.2.2, the package remains schema-resident in APPS and is documented as VALID. Its classification under ETRM is "OTHER," reflecting that it is an internal supporting package rather than a public, certified API such as AP_INVOICE_PUB. It is invoked indirectly by the core approval engine and related funds control logic rather than being called directly by end users.

Key Procedures and Functions

The package exposes eight documented procedures, each responsible for a discrete category of matched-invoice validation:

  • EXECUTE_MATCHED_CHECKS — the principal driver procedure that coordinates the execution of the individual matched-invoice checks.
  • EXEC_MATCHED_VARIANCE_CHECKS — orchestrates variance evaluation between invoiced amounts or quantities and the corresponding PO or receipt values.
  • EXEC_QTY_VARIANCE_CHECK — evaluates quantity variances between the invoice line and the matched PO or receipt quantity.
  • EXEC_AMT_VARIANCE_CHECK — evaluates price or amount variances between the invoice line and the matched PO line or receipt.
  • EXEC_PO_FINAL_CLOSE — handles final close actions on the associated purchase order or PO line when matching and approval conditions permit.
  • EXEC_PAY_WHEN_PAID_CHECK — determines applicability of Pay When Paid terms for the matched invoice.
  • EXEC_PO_DELIVERABLE_CHECK — validates deliverables associated with the PO against the invoice.
  • EXEC_PARTIAL_FUNDS_CHECK — validates available funds when only partial funding exists for the distribution amounts.

Parameter lists are not reproduced here, as the documented metadata does not enumerate them.

Tables Accessed

The package reads and writes against invoice and purchasing tables through APPS synonyms. Invoice-side tables include AP_INVOICES and AP_INVOICES_ALL, AP_INVOICE_DISTRIBUTIONS, AP_INVOICE_DISTRIBUTIONS_ALL and AP_INVOICE_DISTRIBUTIONS_S, AP_INVOICE_LINES and AP_INVOICE_LINES_ALL, and AP_HOLDS. These support hold application, variance determination, and distribution-level funds validation. Purchasing-side tables include PO_HEADERS, PO_LINES, PO_LINE_LOCATIONS and PO_LINE_LOCATIONS_ALL, and PO_DISTRIBUTIONS and PO_DISTRIBUTIONS_ALL, which supply the matched quantities, prices, delivery, and funds information against which invoice values are compared. FND_CURRENCIES supports currency-related comparisons where invoice and PO currency contexts differ.

Usage Notes

AP_APPROVAL_MATCHED_PKG is typically invoked during the invoice validation and approval cycle rather than directly by users. Its documented dependencies show that it references AP_APPROVAL_PKG and is referenced by AP_APPROVAL_PKG, AP_FUNDS_CONTROL_PKG, and itself, confirming that it is embedded within the standard approval and funds-control call stack. Customizations requiring equivalent matched-invoice validations should call these procedures through the supported approval integration points rather than reimplementing the logic. Any direct calls should be evaluated carefully, since the package is internal and subject to change between releases.