Search Results arp_misc_cd




Overview
Explore in AI Chat

Overview

ARP_MISC_CASH_DISTRIBUTIONS, packaged in the APPS schema as ARP_MISC_CD, is a Receivables utility package that supports the miscellaneous cash distribution facility within Oracle E-Business Suite Release 12.1.1 and 12.2.2. Miscellaneous cash receipts represent funds received that are not tied to a specific customer invoice or debit memo; instead, they are posted directly to a General Ledger account determined during receipt entry. The package encapsulates the server-side logic needed to create the distribution records that drive accounting for these receipts, and to manage the General Ledger date associated with reversing such receipts. It is classified as a standard Oracle-owned object with an API classification of OTHER, meaning it is used internally by Oracle Receivables forms and concurrent programs rather than being published as a formal open interface. The dependence on SYS.STANDARD confirms it is a compiled PL/SQL unit, and the object reports a VALID status in the ETRM catalog.

Key Procedures and Functions

The ETRM metadata documents two entry points in APPS.ARP_MISC_CD:

  • INS_MISC_CASH_DISTRIBUTIONS — Inserts the miscellaneous cash distribution rows that represent how a miscellaneous cash receipt is accounted for. This routine is responsible for populating the distribution table so that the receipt can be posted to the correct General Ledger account combinations.
  • UPD_REVERSAL_GL_DATE — Updates the General Ledger date used when a miscellaneous cash receipt is reversed. The GL date on a reversal must fall in an open or future-enterable accounting period, and this routine sets that date as part of the reversal workflow.

The metadata does not publish parameter lists for either routine. Both should be treated as internal Oracle entry points whose signatures are not guaranteed across patch levels; they are not part of a documented public API contract.

Tables Accessed

The package operates against four objects, reached through APPS synonyms:

  • AR_MISC_CASH_DISTRIBUTIONS — the base table holding distribution lines for miscellaneous cash receipts. It is the primary insert target of INS_MISC_CASH_DISTRIBUTIONS.
  • AR_MISC_CASH_DISTRIBUTIONS_S — the corresponding sequence used to generate unique identifiers for new distribution rows.
  • AR_SYSTEM_PARAMETERS — read to obtain Receivables system-level setup values, such as accounting and date-related defaults, that govern how distributions and reversal GL dates are derived.
  • DUAL — used for single-row PL/SQL evaluations and lookups.

Usage Notes

ARP_MISC_CD is invoked indirectly rather than by end users. Its callers are Oracle Receivables' own miscellaneous cash receipt and reversal processing paths; the ETRM dependency listing shows ARP_MISC_CD itself and ARP_RATE_ADJ among the objects that reference it, indicating reuse from related Receivables internal code. In practice the package fires when a user creates or reverses a miscellaneous cash receipt through the Receivables receipts form, or when batch/concurrent processing handles such receipts. Because it is an unclassified internal package rather than a supported API, customizations should not call it directly; extensions that require equivalent behavior are better built on the documented Receivables open interfaces and APIs. Any upgrade from 12.1.1 to 12.2.2 may alter the internal signatures, so dependency on these routines carries upgrade risk.