Search Results unapply_regular_cm




Overview
Explore in AI Chat

Overview

AR_CM_APPLICATION_PUB is a public PL/SQL API package in the APPS schema that supports the credit memo application and unapplication processes within Oracle Receivables. Its principal business role is to manage the linkage between credit memos and the transactions they offset — most notably invoices imported from the Payables side through AP_INVOICES and AP_INVOICES_INTERFACE. In Oracle EBS 12.1.1 and 12.2.2, this package is one of the underlying API layers that Receivables uses when a credit memo is applied against an open debit item, when that application is reversed, or when a refund or adjustment process needs to regularize credit memo balances. The package is classified as a "PUB" (public) API, meaning it is intended for supported external invocation from forms, concurrent programs, and custom code rather than being an internal helper.

Key Procedures and Functions

The ETRM 12.2.2 documentation records three public entry points within AR_CM_APPLICATION_PUB:

  • ACTIVITY_APPLICATION — Handles the business activity of applying a credit memo (or similar credit) to an open receivable. It records the application in AR_RECEIVABLE_APPLICATIONS, updates the corresponding AR_PAYMENT_SCHEDULES and AR_CASH_RECEIPTS context, and drives the associated accounting in line with Receivables application rules.
  • ACTIVITY_UNAPPLICATION — Performs the reverse of the above: it removes an existing credit memo application, releasing the credit back to the customer's account and reversing the affected schedule and receivable application rows.
  • UNAPPLY_REGULAR_CM — A specialized unapplication routine restricted to "regular" credit memos, used when a standard (non-on-account, non-claim) credit memo must be unapplied within the standard Receivables flow.

No parameter signatures are exposed through the documented metadata; callers should consult the package specification in the target instance for exact arguments. The metadata confirms three documented procedures only.

Tables Accessed

AR_CM_APPLICATION_PUB reads and writes a defined set of base tables, primarily through APPS synonyms. AR_CASH_RECEIPTS and AR_RECEIVABLE_APPLICATIONS form the core of the application/unapplication write path. AR_PAYMENT_SCHEDULES is updated to reflect the reduced or restored balance on the transaction. RA_CUSTOMER_TRX supplies the transaction header and line context for the credit memo itself. AP_INVOICES and AP_INVOICES_INTERFACE provide the Payables-side invoice identity involved in cross-module credit memo scenarios. HZ_PARTIES and HZ_PARTY_SITES resolve customer and site information for validation and defaulting. FND_CURRENCIES and IBY_EXT_BANK_ACCOUNTS are consulted for currency and payment-instrument context. FND_LOOKUPS and FND_API provide standard lookup validation and the API error/return handling framework.

Usage Notes

The package is invoked by Receivables forms and concurrent programs during credit memo application and refund processing, and it is referenced by AR_REFUNDS_GRP in the documented dependency list. Custom integrations that need to programmatically apply or unapply credit memos — particularly where Payables invoices are involved — can call the public procedures, but should do so within the standard FND_API error-handling pattern and commit only after validating the return status. Because the documented metadata does not publish parameter lists, developers must inspect the package specification locally before invoking it, and should not assume behavior across 12.1.1 and 12.2.2 without verification.