Results for “ap_pay_single_invoice_pkg”

50+ results




AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

APPS.AP_PAY_SINGLE_INVOICE_PKG is a server-side PL/SQL package in the Oracle Payables (AP) module that provides a programmatic interface for paying a single invoice in full. Rather than routing a payment through the standard batch payment process — which selects, formats, and confirms payment batches for many invoices at once — this package supports the immediate, single-invoice disbursement scenario. It bridges the Payables invoice and payment schedule data with the Oracle Payments (IBY) disbursement layer, allowing an application or concurrent program to create and confirm a payment for one invoice without user intervention in the standard Payables payment workbench.

The package is classified as OTHER in the ETRM API classification, indicating it is a documented internal/supporting package rather than a formally published public API. Its status is VALID under the APPS schema, and it is referenced by the FV_IPAC_AUTOPAYMENTS_PKG package, which is associated with Treasury/IPAC automated payment processing. This dependency confirms its role as a reusable payment-execution building block for other modules.

Key Procedures and Functions

The ETRM metadata documents one procedure or function within this package:

  • AP_PAY_INVOICE_IN_FULL — The core routine of the package. Its purpose is to pay a designated accounts payable invoice for its full outstanding amount, driving the payment from invoice selection through to disbursement. It coordinates with the IBY_DISBURSE_SINGLE_PMT_PKG dependency, which performs the actual Oracle Payments single-payment disbursement. The procedure is responsible for validating the invoice, establishing the payment schedule, creating the payment document record, and recording payment history. No parameter list is documented in the ETRM metadata; callers should inspect the package specification in the target environment for the exact signature.

Tables Accessed

The package reads and writes a range of Payables, Payments, and setup tables through APPS synonyms:

Usage Notes

This package is intended for programmatic, single-invoice payment execution rather than interactive use. It is typically invoked from custom PL/SQL code, from concurrent programs, or from other packaged logic — as evidenced by its reference from FV_IPAC_AUTOPAYMENTS_PKG. It should not be confused with the standard Payables payment batch or Quick Payment flows, which use separate APIs and concurrent programs. Because it is not a formally published public API and its parameters are not documented in ETRM, implementers should treat it as an internal interface: validate behavior against the specific EBS release (12.1.1 or 12.2.2) and test thoroughly in a controlled environment before relying on it in production. Its dependency on IBY_DISBURSE_SINGLE_PMT_PKG means the Oracle Payments disbursement setup, payment process profile, and bank account configuration must be correctly defined for successful execution.