Search Results csm_party_data_event_pkg




Overview
Explore in AI Chat

Overview

The APPS.CSM_PARTY_DATA_EVENT_PKG package is a server-side PL/SQL component within the Oracle E-Business Suite Install Base / Enterprise Asset Management domain. Its name and its dependency footprint indicate that it belongs to the CSM (Customer/Service Management) family of packages that maintain accelerated or denormalized "ACC" copies of party and counter data. In EBS 12.1.1 and 12.2.2 the package is documented as VALID in the APPS schema and is classified under the generic API category OTHER, meaning it is not exposed as a formally versioned public API but is instead an internal utility invoked by other EBS components.

The business function of CSM_PARTY_DATA_EVENT_PKG is to react to data events affecting party and counter information and to refresh the corresponding accelerated (ACC) tables so that downstream queries, service dashboards, and Install Base inquiries return current values without performing expensive joins against the base CSI and HZ tables. The "EVENT" portion of the name reflects this trigger-driven behaviour: the package refreshes cached counter and party account data whenever the underlying source records change.

Key Procedures and Functions

The documented metadata lists a single public procedure or function:

  • REFRESH_ACC — the sole documented entry point in the package specification. Based on its name and the ACC tables it touches, REFRESH_ACC repopulates the accelerated counter and party account tables from their base CSI and HZ counterparts. It is the mechanism by which stale or newly changed counter readings, counter properties, and customer account associations are propagated into the CSM_*_ACC shadow tables. Because the ETRM record does not expose the parameter list, no signature should be assumed; callers should inspect the package specification in the target instance before invoking it.

The package specification and package body are both reported as VALID, and the package body additionally references SYS.STANDARD, confirming standard PL/SQL runtime dependencies only.

Tables Accessed

The documented dependency list shows the package reading from base Install Base and Trading Community tables and writing to accelerated copies:

The pairing of CSI source tables with CSM_*_ACC targets confirms that REFRESH_ACC performs an extract-and-load operation, transforming normalized counter and party data into query-optimized form.

Usage Notes

CSM_PARTY_DATA_EVENT_PKG is an internal utility rather than a user-facing API. It is typically invoked indirectly: by concurrent programs that synchronize Install Base counter data, by forms or OAF pages that trigger a refresh after counter transactions, or by custom extensions that need the accelerated tables brought up to date. The ETRM metadata records zero packages referencing it, indicating it has no documented downstream PL/SQL dependents and is called through direct invocation or scheduled processing rather than through a published API layer. Developers should treat REFRESH_ACC as a maintenance routine, invoke it within a controlled transaction, and validate the resulting ACC table contents, since the refresh may replace rather than incrementally update cached rows.