Search Results ar_distribution_set_lines

Overview

ARP_PROC_RCT_UTIL is a utility package body in the APPS schema that supports Oracle Receivables receipt processing within Oracle E-Business Suite 12.1.1 and 12.2.2. Its role is to centralize the low-level insert, update, and adjustment logic that surrounds cash receipt creation, receipt application, and the generation of accounting distributions. The package is classified as a utility (UTIL) component, meaning it is not exposed as a public API but is instead called internally by higher-level Receivables packages such as ARP_CASH_RECEIPTS_PKG, ARP_DISTRIBUTIONS_PKG, ARP_MISC_CASH_DIST_PKG, and ARP_RATE_ADJUSTMENTS_PKG.

The object shows a VALID status and is referenced by five other packages, confirming its position as a shared processing layer rather than an entry point. It works closely with the multi-funding and cash distribution framework, preparing distribution records, receipt history rows, payment schedule entries, and rate adjustment data used during receipt lifecycle events.

Key Procedures and Functions

The documented interface exposes fourteen procedures and functions. Their purposes are summarized below; parameter signatures are intentionally not reproduced here.

• REVISION — Records a revision identifier or version marker for the package.
• INSERT_PS_REC_CASH — Inserts a payment schedule record associated with a cash receipt.
• INSERT_CRH_REC — Inserts a row into cash receipt history to track receipt activity.
• INSERT_RA_REC_CASH — Creates a receivables application record linking a receipt to a transaction.
• INSERT_DIST_REC — Inserts a distribution record for receipt accounting.
• ROUND_MCD_RECS — Rounds amounts on miscellaneous cash distribution records to reconcile totals.
• INSERT_MISC_DIST — Inserts miscellaneous cash distribution rows.
• UPDATE_MISC_DIST — Updates existing miscellaneous cash distribution rows.
• CREATE_MCD_RECS — Builds miscellaneous cash distribution records from receipt data.
• UPDATE_MANUAL_DIST — Updates manually entered distributions.
• RATE_ADJUST — Performs exchange rate adjustment processing for receipts.
• GET_CCIDS — Retrieves code combination identifiers for accounting flexfields.
• GET_PS_REC — Fetches payment schedule records.
• UPDATE_DIST_REC — Updates existing distribution records.

Tables Accessed

The package reads and writes the core Receivables receipt and distribution tables, all via APPS synonyms:

• AR_CASH_RECEIPTS, AR_CASH_RECEIPT_HISTORY, AR_RECEIVABLE_APPLICATIONS, AR_PAYMENT_SCHEDULES — the receipt, application, and schedule backbone.
• AR_DISTRIBUTIONS and AR_DISTRIBUTION_SET_LINES — accounting distribution lines and the distribution set definitions that drive automated distribution generation. This is directly relevant to users searching for "ar_distribution_set_lines," since the package consumes distribution set lines when building receipt distributions.
• AR_MISC_CASH_DISTRIBUTIONS and AR_MISC_CASH_DISTRIBUTIONS_S — miscellaneous cash distribution data and its sequence.
• AR_RATE_ADJUSTMENTS, AR_RECEIPT_METHOD_ACCOUNTS, AR_RECEIVABLES_TRX, AR_SYSTEM_PARAMETERS — rate adjustment, receipt method, transaction type, and system parameter configuration.
• FND_CURRENCIES, GL_CODE_COMBINATIONS, DUAL — currency definitions, accounting flexfield combinations, and the standard dual table.

Usage Notes

ARP_PROC_RCT_UTIL is invoked internally during receipt processing workflows: cash receipt entry and application forms, receipt reversal and adjustment routines, and any process that generates distributions or rate adjustments. It is also called through the Receivables AutoAccounting and distribution set logic when populating AR_DISTRIBUTIONS. Because it is a utility package, custom code should not call it directly; developers should use the supported Receivables public APIs. Any customization that references AR_DISTRIBUTION_SET_LINES indirectly through this package should be reviewed carefully during upgrades, as internal utility signatures are not guaranteed to remain stable across 12.1.1 and 12.2.2.