Search Results ap_quick_credit_pkg




Overview
Explore in AI Chat

Overview

AP_QUICK_CREDIT_PKG is a public PL/SQL package owned by the APPS schema in Oracle E-Business Suite Payables. It exists to create a credit memo against an existing supplier invoice without requiring the operator to re-enter the full invoice manually. In practice, this is the programmatic engine behind the "Credit" action available from the invoice workbench, allowing a user to reverse all or part of a previously entered invoice while retaining the accounting and matching relationships of the original document. The package is declared with AUTHID CURRENT_USER, meaning it executes with the privileges of the invoking schema and therefore relies on APPS-owned synonyms for all underlying table access.

The source header dates the package to release 12.0-era development (apqkcres.pls, version 120.1, 2003), and it remains available and documented in both 12.1.1 and 12.2.2. It is classified as an OTHER API rather than a supported open interface, which signals that Oracle does not publish a guaranteed external signature or upgrade contract for it, even though the specification is visible.

Key Procedures and Functions

The package exposes a single documented function:

  • QUICK_CREDIT — Creates the credit document. Its parameters identify the invoice being credited, the supplier associated with that invoice, the default GL date for the credit distribution, the operating unit (organization) context, and an optional previously created credit invoice to reuse. It returns a BOOLEAN success indicator and passes back an error code and a calling-sequence string for diagnostics. The calling sequence identifies which program or form invoked the function and is used in error logging.

The function returns BOOLEAN rather than raising a handled exception for ordinary validation failures, so callers must inspect both the return value and the OUT error code. No additional procedures, private helpers, or wrapper functions are documented in the specification.

Tables Accessed

The package reads and writes the core Payables invoice tables and supporting reference data:

Usage Notes

AP_QUICK_CREDIT_PKG is not registered as a concurrent program and is not documented as being called by any other packaged API. It is invoked from the Payables invoice workbench through the Credit action, and it may be called from custom PL/SQL or from a custom form when an automated credit-generation process is required. Because it is an OTHER-classified API, custom callers accept the risk of signature change on patching or upgrade and should call it through a compatibility wrapper rather than embedding the call throughout application code. Callers should also expect that the function performs its own Payables validation and period checks, so the GL date and operating unit passed in must already be valid for the invoice's ledger and organization.