Search Results arp_update_line_cover




Overview
Explore in AI Chat

Overview

ARP_UPDATE_LINE_COVER is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite Release 12.1.1 and 12.2.2. It belongs to the Oracle Receivables (AR) module and is classified in the ETRM repository under the API classification OTHER, indicating that it is an internal utility package rather than a formally published public API. Its documented status is VALID in both release levels.

The package addresses a specific gap in the Receivables transaction model: the autoaccounting engine distributes transaction line amounts across the accounting flexfield segments, and revenue recognition programs such as the Revenue Recognition Master Program and the Unearned Revenue Report subsequently adjust those distributions. When such adjustments occur, the COVER flag on the corresponding distribution row in RA_CUST_TRX_LINE_GL_DIST no longer reflects the true accounting state, and the distribution must be reconciled against the transaction line currency and amount. ARP_UPDATE_LINE_COVER encapsulates that reconciliation logic, allowing existing distribution rows to be refreshed and their cover status set appropriately.

Key Procedures and Functions

The documented package interface contains a single procedure:

  • UPDATE_LINE_COVER — The sole documented program unit. It performs the line cover update for the Receivables transaction records passed to it, refreshing the affected accounting distribution rows and marking them as covered. It is the entry point through which callers trigger the cover-refresh processing described above. The ETRM metadata records the procedure signature as documentation only; parameter lists are not reproduced here and should be validated against the deployed package specification in the target instance, since ARP_UPDATE_LINE_COVER is an internal rather than a supported public API.

The package contains both a specification and a body, and the body issues SQL against the tables listed below. No other procedures or functions are documented.

Tables Accessed

The package references the following tables through APPS synonyms:

  • RA_CUSTOMER_TRX — the Receivables transaction header. Read to identify the transaction, its currency, and its accounting context before line cover is refreshed.
  • RA_CUSTOMER_TRX_LINES — the transaction lines. Read to obtain the line-level amounts and attributes that determine the correct distribution state.
  • RA_CUST_TRX_LINE_GL_DIST — the accounting distributions generated for each transaction line. This is the primary table updated; the cover status of the affected distribution rows is refreshed here.
  • FND_CURRENCIES — the currencies reference table. Consulted to resolve currency precision and rounding behavior applied when amounts are compared or recalculated.
  • AR_SYSTEM_PARAMETERS — Receivables system options. Consulted for the operating unit's accounting and revenue recognition settings that govern how distributions should be treated.

Usage Notes

ARP_UPDATE_LINE_COVER is not referenced by any other documented package in the ETRM repository, nor is it exposed as a standard concurrent program. It is an internal utility invoked from within the Receivables revenue recognition and accounting reconciliation flow, typically called by Oracle's own transaction processing logic rather than by customer code. Customizations that alter revenue recognition or distribution generation may encounter it indirectly if they extend the standard programs that call it.

Because the package is classified as OTHER and is undocumented as a public API, it carries no Oracle support guarantee of signature stability across patches or upgrades. Developers should not call it directly from custom code. Where transactional distribution adjustments are required, the supported approach is to use the published Receivables APIs and let the standard accounting programs invoke ARP_UPDATE_LINE_COVER as part of their normal processing.