Results for “quick_credit”
40 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
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:
- AP_INVOICES_ALL — the header of the invoice being credited, and the header of the new credit memo.
- AP_INVOICE_LINES_ALL — invoice line detail copied forward to the credit.
- AP_INVOICE_DISTRIBUTIONS_ALL, AP_INVOICE_DISTRIBUTIONS, and AP_INVOICE_DISTRIBUTIONS_S — the distribution rows reversed or recreated for the credit, including the sequence-generating synonym.
- AP_SYSTEM_PARAMETERS_ALL — Payables options for the operating unit, used to derive default accounting and control behavior.
- GL_PERIOD_STATUSES — validation of the GL date supplied in P_Dm_Gl_Date against open or future-enterable periods.
- PO_LINES_ALL, PO_LINE_LOCATIONS_ALL, PO_LINE_TYPES, and PLITBLM — purchasing matching and line-type reference data used when the original invoice is matched to a purchase order.
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.
-
View: AP_INVOICES_V 12.1.1
APPS.AP_INVOICES_V·↳ AP_AWT_GROUPS·↳ AP_BATCHES_ALL·↳ AP_DISTRIBUTION_SETS·Explore FND module →
-
View: AP_INVOICES_V 12.1.1
APPS.AP_INVOICES_V·↳ AP_AWT_GROUPS·↳ AP_BATCHES_ALL·↳ AP_DISTRIBUTION_SETS·Explore AP module →
-
View: AP_INVOICES_V 12.2.2
APPS.AP_INVOICES_V·↳ AP_AWT_GROUPS·↳ AP_BATCHES_ALL·↳ AP_DISTRIBUTION_SETS·Explore FND module →
-
View: AP_INVOICES_V 12.2.2
APPS.AP_INVOICES_V·↳ AP_AWT_GROUPS·↳ AP_BATCHES_ALL·↳ AP_DISTRIBUTION_SETS·Explore AP module →
-
Detailed invoice records
-
Detailed invoice records
-
VIEW: AP.AP_INVOICES_ALL# 12.2.2
-
VIEW: AP.AP_INVOICES_ALL# 12.2.2
-
VIEW: APPS.AP_INVOICES_V 12.1.1
-
VIEW: APPS.AP_INVOICES_V 12.2.2
-
VIEW: APPS.AP_INVOICES_V 12.1.1
-
VIEW: APPS.AP_INVOICES_V 12.2.2
-
TABLE: AP.AP_INVOICES_ALL 12.1.1
-
TABLE: AP.AP_INVOICES_ALL 12.2.2
-
Set Distribution Table.
-
Set Distribution Table.
-
eTRM - FND Tables and Views 12.2.2
No longer used
-
eTRM - FND Tables and Views 12.1.1
No longer used