Search Results insert_payment_history

Overview

AP_RECONCILIATION_PKG is a PL/SQL package owned by the APPS schema that supports the reconciliation of Oracle Payables payment instruments against bank statement activity. Its central responsibility is the creation and maintenance of payment history and clearing records, which form the bridge between payment processing in Payables and cash management reconciliation in Oracle Cash Management. In Oracle EBS 12.1.1 and 12.2.2, this package is a shared internal utility: it is referenced by nine other packages, including AP_ACCOUNTING_EVENTS_PKG, AP_AUTO_PAYMENT_PKG, AP_CHECKS_PKG, AP_PAYMENT_PUBLIC_PKG, AP_PAY_SINGLE_INVOICE_PKG, AP_VOID_PKG, CE_AUTO_BANK_CLEAR1, CE_AUTO_BANK_MATCH, and IBY_CE_BATCH_RECON_PKG. That dependency pattern confirms the package sits at the intersection of Payables payment issuance, payment voiding, and Cash Management bank reconciliation.

Key Procedures and Functions

The ETRM metadata for release 12.2.2 documents nine procedures and functions, classified as API type OTHER (internal, not a published public API):

• RECON_PAYMENT_HISTORY — Populates or reconciles payment history records for a payment, establishing the audit trail used by downstream reconciliation.
• RECON_PAYMENT_MATURITY — Handles maturity-date reconciliation logic applicable to payment instruments with future value dates.
• DELETE_PAYMENT_MATURITY — Removes payment maturity records when a payment is reversed, voided, or re-issued.
• RECON_PAYMENT_CLEARING — Marks a payment as cleared, aligning Payables records with confirmed bank clearing.
• RECON_PAYMENT_UNCLEARING — Reverses a prior clearing action, returning the payment to an uncleared state.
• INSERT_PAYMENT_HISTORY — Inserts the initial payment history row for a newly created or issued payment.
• UNCLEAR_CHECK — Provides check-specific unclering logic, supporting stop-payment and reconciliation reversal scenarios.
• RECON_UPDATE_CHECK — Updates the check record to reflect reconciliation status changes.
• CASE_TYPE — A helper function that returns or evaluates a case or type indicator used to drive conditional reconciliation processing.

Tables Accessed

The package works primarily against Oracle Payables payment and payment history tables, accessed through APPS synonyms:

• AP_CHECKS / AP_CHECKS_ALL — The core payment instrument tables, holding check, wire, and electronic payment records. The package reads and updates these to reflect reconciliation and clearing state.
• AP_PAYMENT_HISTORY / AP_PAYMENT_HISTORY_ALL / AP_PAYMENT_HISTORY_S — The payment history tables (including the _ALL and _S variants used across multi-org and single-org access patterns) that store the reconciliation and clearing audit trail.
• AP_SYSTEM_PARAMETERS / AP_SYSTEM_PARAMETERS_ALL — Read to obtain Payables system options, such as reconciliation and payment-date defaults, that govern processing behavior.
• DUAL — Used for singleton lookups and function evaluation.

Usage Notes

AP_RECONCILIATION_PKG is not intended for direct invocation by end users or custom code; it is an internal dependency of standard Payables and Cash Management processing. It is invoked when payments are created, issued, voided, or cleared, and when Cash Management performs automatic bank clearing and bank statement matching through CE_AUTO_BANK_CLEAR1, CE_AUTO_BANK_MATCH, and IBY_CE_BATCH_RECON_PKG. In Oracle EBS 12.1.1 and 12.2.2 the package is valid and must not be modified; any custom extension should call the public payment APIs (such as AP_PAYMENT_PUBLIC_PKG) rather than this package directly. Because AP_RECONCILIATION_PKG is referenced by nine packages, customizations that alter AP payment history or check reconciliation data can affect its behavior across the entire payment and reconciliation lifecycle.