Search Results csm_dboard_srch_cols_event_pkg




Overview
Explore in AI Chat

Overview

The APPS.CSM_DBOARD_SRCH_COLS_EVENT_PKG package is a server-side PL/SQL component within the Oracle E-Business Suite that supports the event-driven behaviour of the Customer Service Manager (CSM) dashboard search configuration. The CSM dashboard is the HTML-based service interface used by call centre agents and field service personnel to locate service requests, customers, and related entities. The configurable "search columns" associated with that dashboard determine which attributes are presented to users and how searches are filtered. This package encapsulates the runtime logic that accumulates and applies search column changes, ensuring that the individual user's dashboard reflects the columns and personalisation defined for them.

In the ETRM 12.2.2 metadata the package is classified as an OTHER API rather than a public or private standard interface, which indicates that it is an internal implementation object rather than a supported integration point. It is validated and owned by the APPS schema, and both the package specification and body are present.

Key Procedures and Functions

The ETRM metadata documents a single procedure for this package:

  • REFRESH_ACC — The documented entry point of the package. Its purpose is to refresh the accumulated search column configuration for the dashboard, reconciling the working search column definitions with the accumulated (cached or personalisation) definitions. Consistent with the package name, it is invoked in response to a search-column event, such as a user adding or removing a column from the dashboard search region. No parameter list is documented in the ETRM extract, and none should be assumed.

Tables Accessed

The package operates against the following tables, referenced through APPS synonyms:

  • CSM_DASHBOARD_SEARCH_COLS — Stores the base definitions of the searchable columns available for the CSM dashboard.
  • CSM_DASHBOARD_SEARCH_COLS_ACC — Holds the accumulated or personalised set of search columns for a given user or context; the primary target of the REFRESH_ACC operation.
  • CSM_DASHBOARD_SRCH_COLS_ACC_S — The sequence used to generate unique identifiers for rows in the accumulated search column table.
  • ASG_USER — The resource/user view used to resolve the identity of the dashboard user whose accumulated columns are being refreshed.
  • JTM_CON_REQUEST_DATA — A JTT (Application Technology) resource layer table used by the CSM/TeleService framework to carry request-context data during dashboard processing.
  • DUAL — Used for single-row evaluations and sequence or function calls.
  • PLITBLM — A standard PL/SQL index-by table type used internally for collections and bulk processing.

Usage Notes

CSM_DBOARD_SRCH_COLS_EVENT_PKG is not intended to be called directly by customers or integrators. It is invoked indirectly by the CSM dashboard framework when search column events are raised, and it is referenced by the CSM_USER_EVENT_PKG package, which handles user-level events in the same dashboard. Because the package is dependency-linked to both of these components, changes to it can affect user-level dashboard event processing.

Typical invocation occurs during interactive use of the Customer Service dashboard: when a user changes the displayed search columns, the framework calls REFRESH_ACC to synchronise the accumulated definitions. Administrators should treat the package as internal, avoid direct calls from custom code, and test any patch or extension touching CSM dashboard personalisation against both Oracle EBS 12.1.1 and 12.2.2, since the underlying table structures and event flow are consistent across those releases but the dashboard technology stack differs.