Search Results ap_pay_insert_invoice_payments

Overview

The APPS.AP_INTEREST_INVOICE_PKG package is a core Payables module component in Oracle E-Business Suite 12.1.1 and 12.2.2 that governs the calculation, creation, and reversal of interest invoices assessed against suppliers for late payment of outstanding invoices. Within Oracle Payables, interest is a statutory or contractual charge applied when an organisation does not settle a supplier invoice by its due date. This package encapsulates the business logic required to compute that interest over defined interest periods, generate the corresponding interest invoice documents, distribute the interest amounts to the appropriate accounting flexfields, and reverse or adjust those entries when the underlying liability changes.

The package operates within the APPS schema and is classified as an OTHER API, meaning it is primarily intended for internal consumption by concurrent programs, other Payables packages, and the standard interest invoice workflow rather than as a standalone public integration API. Its status is VALID, and it depends on the SYS.STANDARD package and is referenced by several peer Payables packages, indicating a central role in the interest-handling subsystem.

Key Procedures and Functions

The documented API surface comprises five procedures:

• AP_CALCULATE_INTEREST — Computes the interest amount owed on overdue invoices for a given supplier or interest period, applying the defined interest rate and the elapsed time between the due date and the settlement date.
• AP_CREATE_INTEREST_INVOICE — Creates the actual interest invoice in Payables, populating the invoice header and line records from the calculated interest amounts.
• AP_REVERSE_INTEREST_INVOICE — Reverses a previously generated interest invoice, typically invoked when the underlying overdue condition is resolved, the interest was calculated in error, or a credit is required.
• AP_PAY_INSERT_INVOICE_PAYMENTS — Inserts invoice payment records that link the created interest invoice to its payment activity, maintaining the relationship between the interest document and the payment that generated the liability.
• AP_CREATE_BATCH_INTEREST_DISTS — Creates invoice distribution records for interest amounts in a batch process, ensuring the interest charges are correctly posted to the general ledger accounts.

Tables Accessed

The package reads and writes across the principal Payables invoice and payment tables, accessed through APPS synonyms:

• AP_INVOICES, AP_INVOICES_ALL, AP_INVOICES_S — Store the interest invoice header information, including invoice type, supplier, amount, and dates.
• AP_INVOICE_LINES, AP_INVOICE_LINES_ALL — Hold the interest line details.
• AP_INVOICE_DISTRIBUTIONS, AP_INVOICE_DISTRIBUTIONS_ALL, AP_INVOICE_DISTRIBUTIONS_S — Receive the accounting distributions created for interest amounts.
• AP_PAYMENT_SCHEDULES, AP_PAYMENT_SCHEDULES_ALL — Define the due dates and scheduled amounts used in interest computation.
• AP_INVOICE_PAYMENTS, AP_INVOICE_PAYMENTS_ALL — Record the payment relationships created by AP_PAY_INSERT_INVOICE_PAYMENTS.
• AP_INTEREST_PERIODS — Provides the interest period definitions and rates applied during calculation.
• AP_CHECKS — Supplies payment instrument information linked to the interest invoice.
• AP_INVOICE_RELATIONSHIPS — Maintains the association between the original overdue invoice and the interest invoice.

Usage Notes

AP_INTEREST_INVOICE_PKG is invoked through the standard Payables interest invoice functionality, primarily via concurrent programs that run interest calculation and invoice creation for a set of suppliers, and through the Invoice Workbench. It is referenced by AP_AUTOSELECT_PKG, AP_PAY_IN_FULL_PKG, and AP_PMT_CALLOUT_PKG, confirming its integration into payment selection, pay-in-full processing, and payment callout logic.

Customisations and extensions should call these procedures only after the interest period setup and supplier payment terms are correctly configured, and should treat the API as a non-public interface subject to change between releases.