Search Results arp_insert_dist_cover




Overview
Explore in AI Chat

Overview

ARP_INSERT_DIST_COVER is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite Receivables. Its name reflects its role: it is an internal distribution-insertion utility ("cover" routine) that populates or maintains rows in the Receivables distribution table, RA_CUST_TRX_LINE_GL_DIST, for a transaction. In the Oracle EBS 12.1.1 and 12.2.2 data model, RA_CUST_TRX_LINE_GL_DIST holds the accounting distributions generated for each customer transaction line, linking a line to its receivable, revenue, tax, freight, and other GL accounts. ARP_INSERT_DIST_COVER exists to centralize the logic that writes these distribution rows so that the core AutoInvoice, transaction-entry, and adjustment processes produce consistent accounting entries.

The package is classified under the ETRM metadata as an OTHER API object rather than a formally published open interface. It is a supporting internal component, not part of the documented customer-facing API surface, and Oracle does not guarantee its signature across releases. Its dependency manifest confirms it is tightly bound to the Receivables transaction schema.

Key Procedures and Functions

The ETRM 12.2.2 metadata documents exactly one callable unit:

  • INSERT_DIST_COVER — The single documented procedure of the package. Its purpose is to insert the distribution (GL accounting) records associated with a customer transaction, ensuring the required coverage of distribution rows exists before downstream accounting and posting processes consume them. Because the ETRM record documents only the procedure name and not a formal argument list, no parameter signature is asserted here. Parameters should be confirmed against the deployed source in the specific release before any direct invocation.

The package also contains a package body and associated SQL statements per the ETRM object details, but no additional public procedures or functions are enumerated.

Tables Accessed

The documented table dependencies, referenced through APPS synonyms, are:

  • RA_CUST_TRX_LINE_GL_DIST — The primary target of INSERT_DIST_COVER; holds the distribution lines the procedure inserts and maintains.
  • RA_CUSTOMER_TRX — The transaction header, providing transaction context such as currency, type, and date.
  • RA_CUSTOMER_TRX_LINES — The transaction lines for which distributions are generated.
  • RA_CUST_TRX_TYPES — Transaction type definitions that determine distribution behavior.
  • RA_RULES — Revenue recognition and distribution rules that govern how distributions are derived.
  • AR_SYSTEM_PARAMETERS — Receivables system options that influence distribution creation.
  • FND_CURRENCIES — Currency definitions used for validation and monetary handling.

These dependencies confirm the package is a write-oriented utility centered on RA_CUST_TRX_LINE_GL_DIST, reading transaction, rule, and setup tables to derive the values it inserts.

Usage Notes

ARP_INSERT_DIST_COVER is an internal Receivables routine. It is most commonly invoked indirectly by standard concurrent programs and transaction-processing logic — notably AutoInvoice and transaction posting — rather than called directly from Oracle Forms or by end users. The ETRM metadata records that it is referenced by no other documented packages, indicating it sits near the leaf of the call hierarchy and is driven by the core transaction engine.

Because it is an undocumented internal package with dependencies on volatile tables, custom code should invoke it only after validating the procedure signature and behavior in the target release (12.1.1 or 12.2.2). Direct calls risk corrupting distribution data if the expected transaction context is not established. For supported integrations, the published Receivables APIs and AutoInvoice interface tables should be preferred over direct use of this package.