Search Results arp_update_dist_cover




Overview
Explore in AI Chat

Overview

ARP_UPDATE_DIST_COVER is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite Receivables. Its name reflects its operational role within the distribution accounting subsystem of Oracle Receivables: it addresses the "distribution cover" flag on the distribution records that Oracle Receivables generates for transactions. The distribution cover indicator is used to mark an accounting distribution as superseded or covered by a more authoritative entry, a mechanism that prevents duplicate revenue, tax, freight, and receivable postings when a transaction is re-calculated, adjusted, or re-derived.

The package status is VALID in both Oracle EBS 12.1.1 and 12.2.2, and it is classified in the ETRM repository as an OTHER API type rather than a formally published open interface. This classification indicates that it is internal supporting code invoked by standard AutoAccounting, transaction, and adjustment processing rather than an integration surface intended for direct customer calls. Because it operates on live distribution rows, the package is tightly coupled with the Receivables transaction data model and the subledger accounting flow.

Key Procedures and Functions

The ETRM metadata documents exactly one callable program unit in the package specification:

  • UPDATE_DIST_COVER — The single public entry point of the package. Its purpose is to set or refresh the distribution cover indicator on Customer Transactions distribution records, thereby marking which accounting lines are considered the effective distributions for a transaction line. It is executed within the transaction's database transaction boundary so that cover state changes commit atomically with the associated inserts and updates on the distribution table. Detailed parameter signatures are not exposed in the documented metadata, and callers should rely on Oracle's seeded forms and concurrent processes rather than authoring custom invocations.

No overloads, private helper functions, or additional public APIs are documented in the summarized ETRM record. The package is self-referential in the dependency listing: APPS.ARP_UPDATE_DIST_COVER is recorded both as referenced by and as referencing the same package object, which is the normal pattern for a specification/body pair extracted into the repository.

Tables Accessed

Three tables are documented as referenced through APPS synonyms:

  • RA_CUST_TRX_LINE_GL_DIST — The core Receivables table storing accounting flexfield distributions for transaction lines. The package reads and updates these rows, and it is here that the distribution cover flag is maintained. This is the principal write target of UPDATE_DIST_COVER.
  • RA_CUSTOMER_TRX — The transaction header table. It is referenced to identify the transaction and its context (transaction date, currency, transaction type) so that the correct distribution set is evaluated. Access is typically read-only for validation and lookup purposes.
  • FND_CURRENCIES — The common Oracle Applications currency definition table. It is accessed to validate currency attributes and, where relevant, to support rounding or currency-related comparisons when determining whether a distribution is covered. Its use is generally read-only.

All access is performed through APPS synonyms owned by the application schema, using standard package naming conventions (SYS.STANDARD is listed as a dependency, confirming reliance only on core PL/SQL built-ins).

Usage Notes

ARP_UPDATE_DIST_COVER is not exposed as a concurrent program or a registered open interface. It is invoked internally by seeded Receivables processing, most commonly during transaction creation and update flows driven by Oracle Forms, when AutoAccounting regenerates distribution lines, and during adjustment or credit memo processing where existing distributions must be re-covered. Because the ETRM record shows zero packages referencing it in a documented capacity other than itself, custom code should not depend on it directly. Any customization that needs to manipulate distribution cover should instead drive the standard Receivables transaction forms or APIs, which in turn call this package. Direct calls risk inconsistent accounting state and are unsupported. DBAs and developers diagnosing duplicate or orphaned distributions in RA_CUST_TRX_LINE_GL_DIST can use the package name as a trace identifier when enabling SQL tracing on a Receivables form session.