Search Results cz_admin




Overview
Explore in AI Chat

Overview

CZ_ADMIN is a VALID PL/SQL package body owned by the APPS schema in Oracle E-Business Suite 12.1.1 and 12.2.2. It belongs to the ETRM (Enterprise Territory and Resource Management, historically the Oracle Configurator / CTS foundation layer) code family and is classified as an OTHER API type, meaning it is a server-side administrative utility package rather than a public business API intended for external callers. Its documented responsibility is the administration of end-user registration and session synchronization for the Configurator runtime. The package validates and enables end users, manages locking against the session table, and provides synchronization routines that reconcile import and publish sessions held in the database with the active sessions that the middle tier expects. Because CZ_ADMIN is not referenced by any other database object, it acts as an internal administrative entry point invoked directly by the applications layer rather than being called from within other PL/SQL units.

Key Procedures and Functions

Five documented procedures and functions are registered against CZ_ADMIN:

  • VALIDATE_END_USERS — Verifies that end-user records are eligible and correctly formed, performing the checks required before an end user may be granted access to Configurator functionality.
  • ENABLE_END_USERS — Applies the enablement state to end users, writing the resulting status back to the end-user repository after validation succeeds.
  • SPX_WAIT — A wait or delay primitive used to suspend execution, typically in polling loops that must avoid contention on shared session resources.
  • SPX_SYNC_IMPORTSESSIONS — Synchronizes import sessions, reconciling database session state with the sessions registered by the middle tier during import processing.
  • SPX_SYNC_PUBLISHSESSIONS — Synchronizes publish sessions, performing the equivalent reconciliation for the publish path.

The exact parameter signatures are not enumerated in the ETRM metadata and should be confirmed against the deployed source before direct invocation.

Tables Accessed

Through APPS synonyms, CZ_ADMIN references CZ_DB_SETTINGS, which supplies configuration values governing runtime behavior; CZ_END_USERS, the end-user repository that the validation and enablement routines read and update; and ALL_USERS, which is queried to confirm that end-user accounts exist as real database users. It additionally depends on DBMS_LOCK for serialization and inter-session locking, DBMS_SQL for dynamic statement execution, and V$SESSION for inspecting live database sessions during synchronization and wait operations. Dependency information further records references to CZ_UTILS, FND_LOG, and the SYS STANDARD package.

Usage Notes

CZ_ADMIN is normally invoked by the Configurator middle tier and by administrative concurrent programs rather than by end users directly. The end-user routines are called during provisioning and user-administration flows, while the SPX synchronization procedures are invoked when import or publish sessions must be brought back into agreement with actual database sessions. Logging through FND_LOG means administrative failures and status messages are visible in the standard EBS log infrastructure. In 12.1.1 and 12.2.2 the package's dependencies are unchanged in principle; because it is referenced by ten other packages, modifications to CZ_ADMIN should be treated as high-impact. Customizations should not be applied directly to the APPS-owned body, and any direct call should be validated against the shipped signature.