Search Results ap_othr_chrg_match_pkg
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.
-
PACKAGE: APPS.AP_OTHR_CHRG_MATCH_PKG
12.1.1
owner:APPS, object_type:PACKAGE, object_name:AP_OTHR_CHRG_MATCH_PKG, status:VALID,
-
PACKAGE: APPS.AP_OTHR_CHRG_MATCH_PKG
12.2.2
owner:APPS, object_type:PACKAGE, object_name:AP_OTHR_CHRG_MATCH_PKG, status:VALID,
-
PACKAGE BODY: APPS.AP_OTHR_CHRG_MATCH_PKG
12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:AP_OTHR_CHRG_MATCH_PKG, status:VALID,
-
PACKAGE: APPS.AP_OTHR_CHRG_MATCH_PKG
12.2.2
-
PACKAGE: APPS.AP_OTHR_CHRG_MATCH_PKG
12.1.1
-
PACKAGE BODY: APPS.AP_OTHR_CHRG_MATCH_PKG
12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:AP_OTHR_CHRG_MATCH_PKG, status:VALID,
-
SYNONYM: APPS.ZX_ACCT_TX_CLS_DEFS
12.1.1
owner:APPS, object_type:SYNONYM, object_name:ZX_ACCT_TX_CLS_DEFS, status:VALID,
-
SYNONYM: APPS.AP_INVOICE_LINES
12.2.2
owner:APPS, object_type:SYNONYM, object_name:AP_INVOICE_LINES, status:VALID,
-
SYNONYM: APPS.AP_INVOICE_LINES
12.1.1
owner:APPS, object_type:SYNONYM, object_name:AP_INVOICE_LINES, status:VALID,
-
SYNONYM: APPS.ZX_ACCT_TX_CLS_DEFS
12.2.2
owner:APPS, object_type:SYNONYM, object_name:ZX_ACCT_TX_CLS_DEFS, status:VALID,
-
PACKAGE: APPS.AP_ETAX_UTILITY_PKG
12.2.2
owner:APPS, object_type:PACKAGE, object_name:AP_ETAX_UTILITY_PKG, status:VALID,
-
PACKAGE: APPS.AP_ETAX_SERVICES_PKG
12.2.2
owner:APPS, object_type:PACKAGE, object_name:AP_ETAX_SERVICES_PKG, status:VALID,
-
PACKAGE: APPS.ZX_AP_TAX_CLASSIFICATN_DEF_PKG
12.1.1
owner:APPS, object_type:PACKAGE, object_name:ZX_AP_TAX_CLASSIFICATN_DEF_PKG, status:VALID,
-
PACKAGE: APPS.ZX_AP_TAX_CLASSIFICATN_DEF_PKG
12.2.2
owner:APPS, object_type:PACKAGE, object_name:ZX_AP_TAX_CLASSIFICATN_DEF_PKG, status:VALID,
-
PACKAGE: APPS.AP_ETAX_UTILITY_PKG
12.1.1
owner:APPS, object_type:PACKAGE, object_name:AP_ETAX_UTILITY_PKG, status:VALID,
-
SYNONYM: APPS.AP_BATCHES
12.2.2
owner:APPS, object_type:SYNONYM, object_name:AP_BATCHES, status:VALID,
-
PACKAGE: APPS.AP_ETAX_SERVICES_PKG
12.1.1
owner:APPS, object_type:PACKAGE, object_name:AP_ETAX_SERVICES_PKG, status:VALID,
-
SYNONYM: APPS.AP_BATCHES
12.1.1
owner:APPS, object_type:SYNONYM, object_name:AP_BATCHES, status:VALID,
-
PACKAGE: APPS.AP_DBI_PKG
12.2.2
owner:APPS, object_type:PACKAGE, object_name:AP_DBI_PKG, status:VALID,
-
PACKAGE: APPS.AP_DBI_PKG
12.1.1
owner:APPS, object_type:PACKAGE, object_name:AP_DBI_PKG, status:VALID,
-
PACKAGE BODY: APPS.AP_MATCHING_UTILS_PKG
12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:AP_MATCHING_UTILS_PKG, status:VALID,
-
SYNONYM: APPS.AP_SUPPLIER_SITES
12.1.1
owner:APPS, object_type:SYNONYM, object_name:AP_SUPPLIER_SITES, status:VALID,
-
SYNONYM: APPS.AP_INVOICE_DISTRIBUTIONS_S
12.1.1
owner:APPS, object_type:SYNONYM, object_name:AP_INVOICE_DISTRIBUTIONS_S, status:VALID,
-
SYNONYM: APPS.AP_INVOICE_DISTRIBUTIONS_S
12.2.2
owner:APPS, object_type:SYNONYM, object_name:AP_INVOICE_DISTRIBUTIONS_S, status:VALID,
-
PACKAGE BODY: APPS.AP_MATCHING_UTILS_PKG
12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:AP_MATCHING_UTILS_PKG, status:VALID,
-
SYNONYM: APPS.ZX_TRANSACTION_LINES_GT
12.1.1
owner:APPS, object_type:SYNONYM, object_name:ZX_TRANSACTION_LINES_GT, status:VALID,
-
SYNONYM: APPS.AP_SUPPLIER_SITES
12.2.2
owner:APPS, object_type:SYNONYM, object_name:AP_SUPPLIER_SITES, status:VALID,
-
SYNONYM: APPS.ZX_TRANSACTION_LINES_GT
12.2.2
owner:APPS, object_type:SYNONYM, object_name:ZX_TRANSACTION_LINES_GT, status:VALID,
-
SYNONYM: APPS.ZX_LINES_DET_FACTORS
12.1.1
owner:APPS, object_type:SYNONYM, object_name:ZX_LINES_DET_FACTORS, status:VALID,
-
12.1.1 DBA Data
12.1.1
-
12.2.2 DBA Data
12.2.2
-
12.2.2 DBA Data
12.2.2
-
12.1.1 DBA Data
12.1.1
-
SYNONYM: APPS.ZX_LINES_DET_FACTORS
12.2.2
owner:APPS, object_type:SYNONYM, object_name:ZX_LINES_DET_FACTORS, status:VALID,
-
PACKAGE: APPS.AP_UTILITIES_PKG
12.1.1
owner:APPS, object_type:PACKAGE, object_name:AP_UTILITIES_PKG, status:VALID,
-
PACKAGE: APPS.AP_UTILITIES_PKG
12.2.2
owner:APPS, object_type:PACKAGE, object_name:AP_UTILITIES_PKG, status:VALID,
-
VIEW: APPS.PO_AP_RECEIPT_MATCH_V
12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:PO.PO_AP_RECEIPT_MATCH_V SQLAP.PO_AP_RECEIPT_MATCH_V, object_name:PO_AP_RECEIPT_MATCH_V, status:VALID,
-
VIEW: APPS.PO_AP_RECEIPT_MATCH_V
12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:PO.PO_AP_RECEIPT_MATCH_V SQLAP.PO_AP_RECEIPT_MATCH_V, object_name:PO_AP_RECEIPT_MATCH_V, status:VALID,
-
SYNONYM: APPS.AP_SUPPLIERS
12.1.1
owner:APPS, object_type:SYNONYM, object_name:AP_SUPPLIERS, status:VALID,
-
SYNONYM: APPS.RCV_TRANSACTIONS
12.1.1
owner:APPS, object_type:SYNONYM, object_name:RCV_TRANSACTIONS, status:VALID,
-
SYNONYM: APPS.AP_INVOICE_DISTRIBUTIONS
12.2.2
owner:APPS, object_type:SYNONYM, object_name:AP_INVOICE_DISTRIBUTIONS, status:VALID,
-
SYNONYM: APPS.RCV_TRANSACTIONS
12.2.2
owner:APPS, object_type:SYNONYM, object_name:RCV_TRANSACTIONS, status:VALID,
-
SYNONYM: APPS.AP_INVOICE_DISTRIBUTIONS
12.1.1
owner:APPS, object_type:SYNONYM, object_name:AP_INVOICE_DISTRIBUTIONS, status:VALID,
-
SYNONYM: APPS.AP_SYSTEM_PARAMETERS
12.1.1
owner:APPS, object_type:SYNONYM, object_name:AP_SYSTEM_PARAMETERS, status:VALID,
-
SYNONYM: APPS.AP_INVOICES
12.1.1
owner:APPS, object_type:SYNONYM, object_name:AP_INVOICES, status:VALID,
-
SYNONYM: APPS.AP_SUPPLIERS
12.2.2
owner:APPS, object_type:SYNONYM, object_name:AP_SUPPLIERS, status:VALID,
-
SYNONYM: APPS.AP_INVOICES
12.2.2
owner:APPS, object_type:SYNONYM, object_name:AP_INVOICES, status:VALID,
-
SYNONYM: APPS.AP_SYSTEM_PARAMETERS
12.2.2
owner:APPS, object_type:SYNONYM, object_name:AP_SYSTEM_PARAMETERS, status:VALID,
-
SYNONYM: APPS.PO_LINE_LOCATIONS
12.2.2
owner:APPS, object_type:SYNONYM, object_name:PO_LINE_LOCATIONS, status:VALID,
-
SYNONYM: APPS.PO_LINE_LOCATIONS
12.1.1
owner:APPS, object_type:SYNONYM, object_name:PO_LINE_LOCATIONS, status:VALID,