Search Results ap_pmt_validations_pkg




Overview
Explore in AI Chat

Overview

APPS.AP_PMT_VALIDATIONS_PKG is a server-side PL/SQL package in Oracle Payables (AP) that consolidates the pre-disbursement validation logic executed against a payment instruction before the payment process proceeds. Its single documented entry point, PERFORMVALIDATIONS, evaluates the eligibility of a group of completed payments belonging to a given payment instruction, returning an aggregate validation result and, where applicable, a structured error record.

The package header declares AUTHID CURRENT_USER, meaning it executes with the privileges of the invoking schema rather than the defining schema. In Oracle E-Business Suite Release 12.1.1 and 12.2.2, this package sits within the Payments/IBY integration layer, where the payment instruction model (IBY) coordinates with Payables invoice, supplier site, bank account, and accounting data to determine whether payments can be built, formatted, and disbursed. The version header indicates the specification last changed at release 120.2 (2011), consistent with the 12.1.1 and 12.2.2 code lines.

Key Procedures and Functions

The package exposes one documented procedure:

  • PERFORMVALIDATIONS — Accepts a payment instruction identifier and a completed payments group identifier, and returns two outputs: a boolean validation result (x_valResult) and an IBY transaction error record (x_docErrorRec). The procedure is the validation gate for a payment batch or payment instruction; the boolean signals whether all conditions were satisfied, while the error record carries the diagnostic detail used by the payments framework to report rejection reasons to the user or to the concurrent request log.

No public functions are documented in the specification beyond this procedure. The package is classified as OTHER in the ETRM API registry and is referenced by one other package, indicating it is an internal collaborator rather than a public integration API.

Tables Accessed

The documented table references reveal the scope of validation performed:

Collectively these accesses confirm that validation spans invoice eligibility, supplier site and bank account validity, currency and period status, and withholding tax considerations.

Usage Notes

AP_PMT_VALIDATIONS_PKG is not intended for direct customer invocation. It is called by the Payables payment processing flow — most commonly from the Payment Process Request and payment instruction build steps executed through concurrent programs — and is referenced by one other package in the APPS schema. Because it is part of the internal payments validation path, customizations should not call PERFORMVALIDATIONS directly; instead, custom code should rely on the documented Payables and IBY APIs (such as the payment instruction and payment creation APIs) that transitively invoke this validation.

In upgrade and support contexts, the package is relevant when diagnosing failed payment instruction builds: the IBY_TRANSACTION_ERRORS record returned by PERFORMVALIDATIONS is the mechanism by which a rejected payment surfaces its cause to the payment dashboard and request log.