Search Results arp_br_housekeeper_pkg




Overview
Explore in AI Chat

Overview

ARP_BR_HOUSEKEEPER_PKG is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite Release 12.1.1 and 12.2.2. The name incorporates the BR product prefix associated with the Oracle Receivables (AR) localization components, and the "HOUSEKEEPER" designation indicates its role as a maintenance and consistency utility rather than a transactional business API. In Oracle EBS, housekeeper packages perform scheduled cleanup, reconciliation, or data-integrity operations that keep operational tables synchronized with the underlying transaction model. This package is classified as OTHER within the ETRM metadata, confirming that it is outside the supported public API surface and is intended for internal application use. Its limited dependency footprint — one documented entry point and a compact set of referenced tables — supports the interpretation that it focuses narrowly on validating or repairing Receivables transaction data. The package is referenced by AR_ARZACS_XMLP_PKG, which indicates that at least one XML Publisher report or concurrent program invokes it during execution, likely to prepare or validate data before report output is generated.

Key Procedures and Functions

The ETRM metadata documents a single program unit within the package:

  • AR_BR_HOUSEKEEPER — The sole documented procedure or function in APPS.ARP_BR_HOUSEKEEPER_PKG. Consistent with housekeeper naming conventions and the tables the package touches, this entry point performs maintenance operations across Receivables transaction, receipt, and adjustment data, removing or reconciling records that no longer align with the transaction model. No parameter list is documented in the metadata, and none should be inferred.

Because the package body is not exposed in the extracted documentation, the precise internal logic of AR_BR_HOUSEKEEPER remains defined only within the APPLSYS/APPS source. The metadata does confirm that the package is self-referential — ARP_BR_HOUSEKEEPER_PKG appears in its own dependency list — which commonly occurs when a program unit is overloaded or when the specification and body reference one another.

Tables Accessed

The documented dependencies include both direct and synonym-based references. The single direct schema reference is to RA_CUST_TRX_TYPES, the transaction type definition table, which supplies the Receivables transaction classifications that housekeeper logic must respect. The remaining tables are reached through APPS synonyms:

Together these tables span the full lifecycle of a Receivables transaction, suggesting the procedure validates or repairs the chain from creation through application, adjustment, and receipt.

Usage Notes

ARP_BR_HOUSEKEEPER_PKG is an internal utility and is not documented as a supported public API. It is normally invoked indirectly: the dependency on AR_ARZACS_XMLP_PKG indicates that at least one XML Publisher concurrent program calls it as part of its data preparation or validation step. Standard practice for packages of this class is to execute them from concurrent programs, scheduled maintenance jobs, or localization-specific processing routines rather than from end-user forms. Given the summary status of VALID and its classification as OTHER, customers should not call AR_BR_HOUSEKEEPER directly in custom code; doing so risks incompatibility across patches and releases. Any investigation of its behavior should be performed against the package source in the APPS schema, and Oracle Support should be consulted before attempting to invoke it manually.