Search Results ap_po_amt_match_pkg




Overview
Explore in AI Chat

Overview

AP_PO_AMT_MATCH_PKG is a PL/SQL package in the APPS schema that supports Oracle Payables' invoice-to-purchase order matching logic when the match is performed on an amount basis rather than a strict quantity-and-price basis. Its role is to evaluate whether a supplier invoice line can be tied to an associated purchase order or receipt and whether the invoiced amount is correct against that reference. The package is part of the broader Payables matching framework and calls into AP_MATCHING_PKG, which contains the core validation routines used during invoice entry, matching, and approval.

The package is classified as an OTHER API in the ETRM metadata, indicating it is not published as a formally supported open interface but is instead an internal, dependency-driven component invoked by other Payables packages. It is referenced by AP_MATCHING_UTILS_PKG, AP_QUICK_CREDIT_PKG, and itself, confirming that amount-based matching is a shared service consumed across invoice entry, quick credit processing, and matching utility flows.

Key Procedures and Functions

  • AP_AMT_MATCH — Performs the amount-based match between an invoice line and its corresponding purchase order or receipt reference. This procedure is the entry point for evaluating whether the invoiced amount agrees with the matched PO or receipt and is used during invoice validation and matching.
  • AMOUNT_CORRECT_INV_PO — Evaluates whether the invoice amount is correct relative to the associated PO. It supports the correction or tolerance-checking path used when an amount mismatch is detected and the system must determine whether the invoice can proceed or must be adjusted.

Documented parameter lists are not published in the ETRM excerpt; consumers should rely on the package specification for exact signatures.

Tables Accessed

The package reads and writes Payables invoice and distribution data through APPS synonyms, including AP_INVOICES and AP_INVOICES_ALL (invoice headers), AP_INVOICE_LINES and AP_INVOICE_LINES_ALL (invoice lines), and the distribution tables AP_INVOICE_DISTRIBUTIONS, AP_INVOICE_DISTRIBUTIONS_ALL, and AP_INVOICE_DISTRIBUTIONS_S. Batch context is drawn from AP_BATCHES, and supplier validation uses AP_SUPPLIERS and AP_SUPPLIER_SITES_ALL. System-level and matching configuration is obtained from AP_SYSTEM_PARAMETERS, AP_SYSTEM_PARAMETERS_ALL, and FINANCIALS_SYSTEM_PARAMETERS. Withholding treatment references AP_AWT_GROUPS, and asset-related processing references FA_BOOK_CONTROLS.

Usage Notes

AP_PO_AMT_MATCH_PKG is invoked internally by Payables matching utilities and quick credit processing rather than called directly by end users. It is triggered during the invoice matching workflow when the matching basis is amount-based, typically via the Payables Invoice Workbench and the underlying matching engine. Because it is referenced by AP_QUICK_CREDIT_PKG, it also participates in quick credit and adjustment flows that reassess matched amounts. Custom code should treat it as an internal dependency and avoid direct invocation; extensions that require amount-matching behavior should integrate at the supported matching API level instead. As with all APPS packages, EXECUTE privileges should be granted with caution and changes validated against the 12.1.1 and 12.2.2 code lines.