Search Results insert_dist

Overview

ARP_PROCESS_DIST is a PL/SQL package in the APPS schema that supports the Oracle Receivables distributions framework. Its role is to manage the lifecycle of row-level distribution records on transactions and their related receivable events — inserting, updating, and deleting distribution rows that represent the accounting impact of customer transactions, adjustments, and receivable applications. It is one of a family of supporting packages that sit under the distributions cover logic, alongside ARP_INSERT_DIST_COVER, ARP_UPDATE_DIST_COVER, and ARP_DELETE_DIST_COVER, all of which invoke ARP_PROCESS_DIST to perform the physical DML against the distribution tables.

In EBS 12.1.1 and 12.2.2, the package is classified as an OTHER API rather than a formally published open interface, indicating it is intended primarily for internal use by other Receivables processes. The package is VALID in the data dictionary under both release levels and carries no invalid subobjects.

Key Procedures and Functions

• INSERT_DIST — Creates new distribution records, establishing the accounting lines that correspond to a customer transaction or related receivable event.
• UPDATE_DIST — Modifies existing distribution records when transaction amounts, accounts, or associated attributes change and the distributions must be re-derived or corrected.
• DELETE_DIST — Removes distribution rows that are no longer valid, such as when a transaction is reversed, a distribution source is regenerated, or the accounting is superseded.

Because the procedures are documented only by name, callers should treat signatures as internal and avoid direct invocation; parameter detail is not exposed in the ETRM metadata and is subject to change across point releases.

Tables Accessed

• RA_CUST_TRX_LINE_GL_DIST — The primary distribution table for customer transaction lines, holding the account and amount information this package inserts, updates, and deletes.
• RA_CUSTOMER_TRX — The transaction header, used to resolve the transaction context for distribution processing.
• AR_DISTRIBUTIONS — The general distributions table for Receivables accounting entries.
• AR_RECEIVABLE_APPLICATIONS — Provides application-level context when distributions relate to cash application activity.
• AR_ADJUSTMENTS — Supplements distribution creation or maintenance for adjustment-driven accounting entries.
• RA_CUST_TRX_TYPES — Used to derive transaction type attributes that influence distribution treatment.
• FND_CURRENCIES — Supplies currency information required for correct accounting amounts and precision.

Usage Notes

ARP_PROCESS_DIST is referenced by ARP_INSERT_DIST_COVER, ARP_UPDATE_DIST_COVER, and ARP_DELETE_DIST_COVER, which act as cover routines for the underlying distribution DML. In practice, distributions are generated and maintained through standard Receivables flows: transaction entry forms, AutoInvoice, adjustment and application processing, and the accounting/concurrent programs that create or regenerate distribution rows. Because it is an internal OTHER-class API, custom code should not call ARP_PROCESS_DIST directly. Where extensions require distribution manipulation, the supported approach is to use the documented Receivables open interfaces or the cover packages, and to test thoroughly on both 12.1.1 and 12.2.2, since internal distribution logic may differ between those release levels.