Search Results get_ccids

Overview

ARP_PROC_RCT_UTIL is a utility package in the APPS schema of Oracle E-Business Suite Release 12.1.1 and 12.2.2 that supports the core Oracle Receivables receipt processing architecture. Its documented API classification is UTIL, indicating that it is not intended as a standalone public business API but rather as an internal helper library consumed by higher-level receipt processing packages. The package encapsulates the low-level insert, update, and rounding logic required to persist cash receipts and their associated accounting distributions into the Receivables subledger tables. By centralizing this logic, ARP_PROC_RCT_UTIL ensures that receipt creation, miscellaneous receipt handling, rate adjustment, and distribution generation all behave consistently across the AutoLockbox, manual receipt, and miscellaneous receipt flows. Its status is VALID in the ETRM metadata, and it depends on a set of standard Receivables transaction and distribution tables while being referenced by five other packages within the Receivables processing stack.

Key Procedures and Functions

The package exposes fourteen documented procedures and functions, all oriented toward receipt and distribution manipulation:

• REVISION — Returns the revision identifier of the package, used for version tracking and support diagnostics.
• INSERT_PS_REC_CASH — Inserts payment schedule records for cash receipts, establishing the receivable balance tied to the receipt.
• INSERT_CRH_REC — Inserts rows into the cash receipt history, capturing the audit trail for receipt state changes.
• INSERT_RA_REC_CASH — Inserts receivable application records that link a cash receipt to the transactions it settles.
• INSERT_DIST_REC — Inserts accounting distribution lines for a receipt.
• ROUND_MCD_RECS — Performs rounding adjustment on miscellaneous cash distribution records to reconcile currency rounding differences.
• INSERT_MISC_DIST — Inserts miscellaneous cash distribution rows.
• UPDATE_MISC_DIST — Updates existing miscellaneous cash distribution rows.
• CREATE_MCD_RECS — Creates the miscellaneous cash distribution records required for a receipt.
• UPDATE_MANUAL_DIST — Updates manually entered distribution lines.
• RATE_ADJUST — Handles exchange rate adjustment entries for foreign-currency receipts.
• GET_CCIDS — Retrieves code combination identifiers for the accounts used in distribution generation.
• GET_PS_REC — Retrieves payment schedule records associated with a receipt.
• UPDATE_DIST_REC — Updates existing receipt distribution records.

Tables Accessed

ARP_PROC_RCT_UTIL references the principal Receivables receipt and distribution tables through APPS synonyms. AR_CASH_RECEIPTS and AR_CASH_RECEIPT_HISTORY hold the receipt header and its status history. AR_PAYMENT_SCHEDULES and AR_RECEIVABLE_APPLICATIONS store the receivable installments and the application of receipts against transactions. AR_DISTRIBUTIONS, AR_MISC_CASH_DISTRIBUTIONS, and AR_MISC_CASH_DISTRIBUTIONS_S hold the accounting distribution lines, while AR_RATE_ADJUSTMENTS stores exchange rate adjustment entries. Supporting tables include AR_DISTRIBUTION_SET_LINES, AR_RECEIPT_METHOD_ACCOUNTS, AR_RECEIVABLES_TRX, and AR_SYSTEM_PARAMETERS, which supply default accounts and system configuration. FND_CURRENCIES and GL_CODE_COMBINATIONS provide currency and accounting flexfield validation, and DUAL is used for single-row queries. Collectively these tables represent the write path for receipt subledger accounting.

Usage Notes

This package is invoked internally by the Receivables receipt processing packages, including ARP_PROCESS_CHARGEBACK, ARP_PROCESS_MISC_RECEIPTS, ARP_PROC_RECEIPTS1, ARP_PROC_RECEIPTS2, and AR_RECEIPT_API_PUB, as well as recursively by itself. It is therefore triggered indirectly through standard receipt entry forms, the AutoLockbox concurrent program, miscellaneous receipt processing, and the public AR Receipt API. Direct invocation from custom code is not recommended, since the procedures assume calling context, sequencing, and validation already established by the parent processing routines. Customizations should instead use AR_RECEIPT_API_PUB, which delegates internal persistence work to ARP_PROC_RCT_UTIL.