Search Results prepare_for_ra

Overview

ARP_DET_DIST_PKG is a core Oracle Receivables (AR) PL/SQL package owned by the APPS schema that manages detailed distribution accounting for receivables transactions. Its primary responsibility is the creation, maintenance, and adjustment of subledger accounting distributions generated when Receivables activity — such as cash application, adjustments, and receipt-related transactions — must be reflected at the transaction-line and distribution level. The package sits at the intersection of transaction processing and the accounting engine, ensuring that distribution rows in the AR_DISTRIBUTIONS tables remain synchronized with the underlying receivable, adjustment, and application records.

Because it is a distribution-level engine, ARP_DET_DIST_PKG is invoked whenever a Receivables event requires fine-grained accounting treatment, including the split of distribution amounts, the proration of accounting across lines, and the generation of cash-basis distributions. In EBS 12.1.1 and 12.2.2, this logic underpins standard functionality such as autoaccounting, cash application, and the multi-funds and Subledger Accounting (SLA) extract flows, making it a foundational dependency for many higher-level AR processes.

Key Procedures and Functions

The populated package exposes approximately 36 documented procedures and functions organized around distribution processing. Representative members include:

• TRX_LEVEL_CASH_APPLY, TRX_LINE_LEVEL_CASH_APPLY, TRX_GP_LEVEL_CASH_APPLY, TRX_LEVEL_DIRECT_CASH_APPLY — variants of cash application processing performed at the transaction, line, and guaranteed-payment levels.
• TRX_LEVEL_DIRECT_ADJUST — performs direct adjustment accounting at the transaction level.
• SET_ORIGINAL_REM_AMT, FINAL_UPDATE_INV_CTL_REM_ORIG — manage the original remaining amount and its final update during distribution control.
• COPY_TRX_LINES, CREATE_FINAL_SPLIT — copy transaction lines and generate the final distribution split records.
• UPDATE_DIST, UPDATE_FOR_MRC_DIST — update distribution rows, including handling for multiple reporting currencies (MRC).
• ACCTING_PRORATION_FCT — prorates accounting amounts across lines or distributions.
• EXEC_ADJ_API_IF_REQUIRED, EXEC_REVREC_IF_REQUIRED, PREPARE_FOR_RA — invoke adjustment APIs and revenue recognition logic when conditions require, and prepare records for Receivable Adjustment processing.
• CHECK_LAZY_APPLY_REQ, CHECK_MF_TRX, ONLINE_LAZY_APPLY — evaluate whether lazy application is required, validate multi-funds transactions, and perform online lazy application.
• THE_CONCERN_BUCKET, POSSIBLE_ADJUST — support adjustment eligibility and categorization logic.

Each routine contributes to keeping distribution and application records internally consistent throughout the transaction lifecycle.

Tables Accessed

The package reads and writes a substantial set of Receivables base and distribution tables through APPS synonyms, including:

• RA_CUSTOMER_TRX, RA_CUSTOMER_TRX_LINES — transaction headers and lines that drive distribution creation.
• AR_ADJUSTMENTS — adjustment records subject to distribution accounting.
• AR_RECEIVABLE_APPLICATIONS, AR_PAYMENT_SCHEDULES (ALL) — receipt application and payment schedule data.
• AR_DISTRIBUTIONS, AR_DISTRIBUTIONS_ALL, AR_DISTRIBUTION_SPLIT_S, AR_BASE_DIST_AMTS_GT, AR_CASH_BASIS_DISTRIBUTIONS_S, AR_CASH_BASIS_DISTS_ALL — the core distribution, split, and cash-basis distribution repositories.
• AR_CASH_RECEIPTS_ALL, AR_LINE_APP_DETAIL_GT, AR_LINE_DIST_INTERFACE_GT — receipt, application detail, and distribution interface staging tables.

These accesses reflect the package's role as a transactional writer of distribution rows and a reader of application and adjustment context.

Usage Notes

ARP_DET_DIST_PKG is an internal engine rather than a public API, classified as OTHER in the ETRM metadata. It is typically invoked indirectly by higher-level AR packages and concurrent programs — including ARP_PROCESS_DET_PKG, ARP_PROCESS_LOCKBOX, ARP_RECEIPTS_MAIN, ARP_ALLOCATION_PKG, ARP_BALANCE_CHECK, ARP_RATE_ADJ, ARP_ETAX_UTIL, ARP_XLA_EXTRACT_MAIN_PKG, AR_ADJUST_PUB, and the AR upgrade utilities AR_UNPOSTED_ITEM_UPG and AR_UPGRADE_CASH_ACCRUAL — as well as by AutoInvoice, Receipts, and Adjustments forms. Custom code should avoid calling it directly; instead, developers should use supported AR APIs such as AR_ADJUST_PUB or AR_RECEIPT_API_PUB. Direct modification of its distribution output can corrupt Subledger Accounting balances, so any customization must be carefully validated within a cloned environment.