Search Results othr_chrg_match

Overview

APPS.AP_OTHR_CHRG_MATCH_PKG is a PL/SQL package in the Oracle E-Business Suite Payables (AP) module that supports the matching of "other charges" — freight, taxes, and miscellaneous charges — against receipt transactions during the invoice-to-receipt matching process. In Oracle Payables, three-way and four-way matching extends beyond the base item quantity to include ancillary charges that must be validated against the corresponding receipt line before an invoice can be approved and paid. This package encapsulates the logic that evaluates those charges, reconciles them with the quantities recorded in Oracle Purchasing/Receiving, and determines whether the charge should be accepted, placed on hold, or rejected.

The object is classified as VALID and is owned by the APPS schema, which is consistent with standard seeded EBS database objects. It is designated with an API classification of OTHER, indicating it is not a formally published open interface or public API, but rather an internal utility invoked by the Payables matching framework. Because it operates on the receipt and invoice line data that underpin the matching engine, it plays a supporting role in ensuring that supplier invoices reflect only legitimate, receipt-supported charges before payment is authorized.

Key Procedures and Functions

The ETRM documentation records a single documented program unit within this package:

• OTHR_CHRG_MATCH — The core routine responsible for performing the other-charge match validation. Its purpose is to correlate non-item charges on an invoice line with the associated receipt transaction information and to apply matching rules that determine the disposition of the charge. Detailed parameter information is not exposed in the available metadata; callers should treat this as an internal routine rather than a supported entry point.

Because the package body is marked as proprietary and the metadata excerpt does not enumerate private helper programs, no additional procedures or functions are documented. Any dependent code listing would be required to fully enumerate internal logic.

Tables Accessed

The package reads and/or writes a defined set of AP and non-AP tables through APPS synonyms. The principal documented tables include:

• AP_INVOICE_LINES and AP_INVOICE_DISTRIBUTIONS (with the _ALL and _S variants) — the invoice-side lines and accounting distributions whose other-charge amounts are being validated.
• RCV_TRANSACTIONS — the receiving transaction records used as the authoritative receipt reference for match comparison.
• AP_INVOICES / AP_INVOICES_ALL and AP_BATCHES — the parent invoice and batch headers providing context and status.
• AP_SUPPLIERS and AP_SUPPLIER_SITES — supplier and supplier site information relevant to charge validation.
• AP_SYSTEM_PARAMETERS — Payables system options that influence matching behavior and tolerances.
• GL_CODE_COMBINATIONS, GL_PERIOD_STATUSES, and FA_BOOK_CONTROLS — accounting flexfield and period-related reference data used when resolving distributions and period validity.
• MTL_UNITS_OF_MEASURE — unit of measure conversions needed to align invoice charge quantities with receipt quantities.

Usage Notes

AP_OTHR_CHRG_MATCH_PKG is referenced by AP_MATCHING_UTILS_PKG, which indicates it is invoked as part of the broader Payables matching utility chain rather than directly by end users. It is typically triggered indirectly when the Invoice Workbench performs matching, when the Payables Open Interface Import processes invoice lines with other charges, or when matching-related concurrent programs execute. Because the API classification is OTHER and the package is not a formally published open interface, customizations should not call it directly; instead, integrations should rely on supported matching APIs and interfaces. Developers reviewing dependent code should note the package is internally self-referential (referenced by its own dependent code listing) and dependent on AP_MATCHING_UTILS_PKG, which governs the sequence and context in which OTHR_CHRG_MATCH executes.