Search Results refresh_user




Overview
Explore in AI Chat

Overview

CSM_PAGE_PERZ_DELTA_EVENT_PKG is an Oracle E-Business Suite PL/SQL package owned by the APPS schema and classified as an "OTHER" API within the ETRM repository. Its purpose is to manage the propagation, or refresh, of personalized page configuration data used by the Oracle Applications Framework (OAF) and related self-service personalization infrastructure. In Oracle EBS, page personalizations are stored in repository tables and cached or staged for efficient runtime access. When underlying personalization definitions change — whether through administrative edits, file-based imports, or user-level customization — the staged delta records must be regenerated so that end users see current layouts and behaviors.

This package provides the server-side logic that recalculates these delta records, either for the entire personalization repository or for a specific user, thereby keeping the runtime personalization cache synchronized with the master definitions. The AUTHID CURRENT_USER declaration indicates the package executes with the privileges of the invoking user, which is significant in a multi-tenant or delegated-administration context.

Key Procedures and Functions

The package exposes two documented procedures:

  • REFRESH_PAGE_PERZ_DELTA — Performs a repository-wide refresh of page personalization delta data. It returns status and message values through output parameters, allowing callers to determine whether the operation succeeded and to capture any diagnostic text. This procedure is suited to bulk reconciliation scenarios, such as post-patch or post-migration processing where all personalization deltas must be rebuilt.
  • REFRESH_USER — Refreshes personalized page delta data scoped to a single user, identified by the user identifier passed to the procedure. It targets the personalization records that apply to that user only, making it appropriate for incremental or on-demand refreshes triggered by user-specific changes. This procedure corresponds to the internal note referencing Bug 7239431, indicating it was introduced or modified to address a specific defect in user-level personalization handling.

No function returns are documented; both procedures operate through side effects on the personalization delta tables.

Tables Accessed

The package reads and writes several tables through APPS synonyms, reflecting the personalization data model:

  • CSM_PAGE_PERZ, CSM_PAGE_PERZ_DELTA, CSM_PAGE_PERZ_DELTA_ACC, CSM_PAGE_PERZ_DELTA_ACC_S — the core personalization repository and its delta and accessory staging tables that this package computes and maintains.
  • ASG_USER — used to validate or resolve the user context for the REFRESH_USER operation.
  • JTM_CON_REQUEST_DATA — supports request or connection data handling associated with the personalization workflow.
  • DUAL — used for scalar evaluation within PL/SQL logic.
  • PLITBLM — a standard PL/SQL index-by table type used internally for bulk processing of identifiers.

Usage Notes

In Oracle EBS 12.1.1 and 12.2.2, this package is typically invoked programmatically rather than directly by end users. It may be called from OAF controller logic, concurrent programs, or custom PL/SQL routines that manage personalization synchronization. Administrators performing personalization maintenance, applying patches, or diagnosing stale page layouts commonly trigger REFRESH_PAGE_PERZ_DELTA for repository-wide corrections and REFRESH_USER for targeted refreshes. Because the package is AUTHID CURRENT_USER, callers must hold appropriate privileges on the underlying personalization and user tables. Custom code referencing this package should treat it as an internal, undocumented-interface API and validate behavior after EBS upgrades.