Search Results insert_misc_receipt

Overview

ARP_PROCESS_MISC_RECEIPTS is a PL/SQL package owned by the APPS schema that supports the creation and maintenance of miscellaneous receipts within Oracle Receivables. Miscellaneous receipts are cash receipts that are not tied to a specific customer transaction — they represent funds received for activities such as interest income, stock sales, refunds, or other non-invoice-related collections. In Oracle EBS 12.1.1 and 12.2.2, this package provides the underlying programmatic logic that allows miscellaneous receipts to be inserted and updated while ensuring the supporting accounting distributions, receipt history records, and receipt method account validations are kept consistent with the Receivables data model.

The package is classified as an "OTHER" API in the ETRM metadata, meaning it is a supporting internal package rather than a formally published public API. It is referenced by the AR_RECEIPT_API_PUB package, the ARP_CASHBOOK package, and by itself, which indicates its role as a shared utility layer within the Receivables receipt processing stack.

Key Procedures and Functions

The ETRM documentation identifies three documented procedures or functions within this package:

• INSERT_MISC_RECEIPT — Creates a new miscellaneous receipt record in Receivables. This procedure is responsible for populating the cash receipt header and its associated detail rows, including the distribution information required for accounting and the receipt history entry that records the transaction event.
• UPDATE_MISC_RECEIPT — Modifies an existing miscellaneous receipt. This procedure handles changes to receipt attributes while maintaining the integrity of the related distributions and history records, ensuring that revisions are properly reflected across the affected Receivables tables.
• REVISION — Supports the revision processing of miscellaneous receipts, likely capturing version or audit-related information associated with receipt changes. The presence of a REVISION element indicates that the package tracks changes made to miscellaneous receipt records.

No parameter lists are documented in the ETRM metadata; the procedures are described here solely by their documented names and intended purpose.

Tables Accessed

The package reads from and writes to the following documented tables via APPS synonyms:

• AR_CASH_RECEIPTS — The primary receipt header table where the miscellaneous receipt is stored.
• AR_CASH_RECEIPT_HISTORY — Records the lifecycle events associated with the receipt.
• AR_DISTRIBUTIONS — Stores the accounting distributions generated for the receipt.
• AR_MISC_CASH_DISTRIBUTIONS — Holds the specific distribution lines applicable to miscellaneous cash receipts.
• AR_RECEIPT_METHOD_ACCOUNTS — Provides the receipt method account setup used to derive default accounting.
• AR_RECEIVABLES_TRX — Supplies the receivables transaction type definitions that govern how the miscellaneous receipt is classified and posted.
• AR_SYSTEM_PARAMETERS — Provides system-level defaults and settings that influence receipt processing.
• RA_CUSTOMER_TRX — Referenced for transaction-related context where the miscellaneous receipt interacts with customer transactions.

Usage Notes

ARP_PROCESS_MISC_RECEIPTS is typically invoked indirectly rather than called directly by end users. The Receipts workbench and related Oracle Receivables forms rely on the receipt APIs, which in turn call this package. The AR_RECEIPT_API_PUB package references ARP_PROCESS_MISC_RECEIPTS, meaning that standard API-driven receipt creation and updates for miscellaneous receipts route through this logic. The ARP_CASHBOOK package also references it, reflecting its use in cashbook-related processing.

Custom code and integrations that need to create or modify miscellaneous receipts should generally use the published AR_RECEIPT_API_PUB interfaces rather than calling ARP_PROCESS_MISC_RECEIPTS directly, since the package is classified as OTHER and is subject to change. The package is consistent across 12.1.1 and 12.2.2, with the ETRM metadata confirming its VALID status in the APPS schema for release 12.2.2.