Search Results ap_matching_pkg




Overview
Explore in AI Chat

Overview

APPS.AP_MATCHING_PKG is a core Oracle E-Business Suite Payables package responsible for invoice-to-purchase-order matching logic. In Oracle EBS 12.1.1 and 12.2.2 it centralizes the rules that determine whether an invoice line, distribution, or receipt can be matched against the corresponding purchasing documents — purchase order headers, lines, line locations, releases, and receiving transactions. The package is the shared engine behind manual matching in the Payables Invoice Workbench and behind automated matching processes executed by concurrent programs and complementary packages.

The ETRM metadata classifies the object as VALID under the APPS schema, with an API classification of OTHER. It is a dependent, internal-style package rather than a published open interface, meaning it is not intended as a formally supported extension point but is instead referenced extensively by other Payables matching packages. Nine tables sourced from the Purchasing and Payables schemas are documented as referenced, reflecting the cross-module nature of the matching process.

Key Procedures and Functions

The 12.2.2 ETRM documentation records four procedures or functions within AP_MATCHING_PKG:

  • BASE_CREDIT_PO_MATCH — Supports credit memo and negative adjustment matching against purchase order documents, providing the base logic for reversing or offsetting previously matched invoice quantities and amounts.
  • PRICE_QUANTITY_CORRECT_INV_PO — Handles price and quantity corrections between invoice lines and purchase order lines, recalculating matched values when invoices deviate from ordered or received quantities.
  • QUICK_MATCH_LINE_GENERATION — Generates invoice line candidates for the Quick Match feature, deriving matches from open purchase order shipments and receipts.
  • BUILD_PREPAY_ACCOUNT — Constructs the accounting distribution for prepayment-related matching, determining the correct prepayment account to apply against the matched purchase order.

These four routines represent the documented callable surface. No parameter signatures are published in the ETRM excerpt, and callers should treat invocation details as internal implementation.

Tables Accessed

The package reads and writes against both Payables and Purchasing tables via APPS synonyms:

Access to these tables allows the package to determine match eligibility, recalculate quantities and prices, and persist the resulting match state on invoice distributions.

Usage Notes

AP_MATCHING_PKG is invoked indirectly. The ETRM metadata shows it is referenced by seven other packages, including AP_AUTO_DM_CREATION_PKG, AP_MATCHING_UTILS_PKG, AP_PO_AMT_MATCH_PKG, AP_QUICK_CREDIT_PKG, AP_RCT_AMT_MATCH_PKG, AP_RECT_MATCH_PKG, and AP_RECURRING_INVOICES_PKG. It also contains internal self-references.

In practice, this means the package is triggered when users perform Quick Match or manual matching in the Payables Invoice Workbench, when the Payables AutoMatch concurrent program runs, and when receiving-based matching processes execute during invoice validation. Custom code should not call these procedures directly unless the dependency chain is fully understood, because the routines operate on in-progress invoice data and expect the calling package to manage the surrounding transaction and validation context. For supported extensions, Oracle directs developers to the documented Open Interfaces and public APIs rather than this internal matching package.