Search Results cz_languages_do_not_match

Overview

APPS.CZ_ADMIN is the administrative control package of the Oracle E-Business Suite (EBS) Configuration Management (CZ) schema, the component responsible for managing "end users" and import/publish session state within the ETRM (Engineering and Technical Reference Management) and related Configurator deployments. The package is defined with AUTHID CURRENT_USER, meaning its unqualified references to database objects and public synonyms are resolved using the privileges of the invoking schema rather than the package owner. This design allows the package to be called from multiple calling contexts while still leveraging the executing user's grants, and it is a deliberate choice for a utility package that touches session-level and user-level dictionary views.

The primary business function of CZ_ADMIN is to synchronize and validate the population of application end users, and to provide controlled mechanisms for waiting on and synchronizing import and publish sessions. It is not a transactional business-logic package; instead it plays a supporting, housekeeping role for the CZ schema, ensuring that the set of active end users and the state of import/publish sessions remain consistent with the underlying database sessions recorded in V$SESSION.

Key Procedures and Functions

The documented package exposes five procedures:

• VALIDATE_END_USERS — The procedure most directly associated with the user's search term. It validates the entries in the CZ end-user population, reconciling them against the Oracle database users / active sessions. It is the entry point typically invoked when the end-user list must be checked for consistency, for example before enabling users or before running import sessions.
• ENABLE_END_USERS — Enables the configured end users within the CZ schema. This complements VALIDATE_END_USERS: validation confirms that the end-user rows are consistent, and ENABLE_END_USERS makes them active for use within the application.
• SPX_WAIT — A utility wait procedure (with a default second argument) that suspends processing for a specified number of seconds. It is used internally by the synchronization procedures to pace and serialize concurrent activity.
• SPX_SYNC_IMPORTSESSIONS — Synchronizes the recorded state of import sessions with the actual database sessions. This cleans up orphaned or stale import-session records and prevents multiple concurrent import processes from colliding.
• SPX_SYNC_PUBLISHSESSIONS — The counterpart to the import synchronization, reconciling publish-session state with live database sessions.

The package also declares a set of named exceptions — including IMP_ACTIVE_SESSION_EXISTS, IMP_UNEXP_SQL_ERROR, IMP_MAXERR_REACHED, IMP_MODEL_NOT_FOUND, IMP_TOO_MANY_SERVERS, IMP_NO_IMP_SERVER, IMP_LINK_IS_DOWN, and CZ_LANGUAGES_DO_NOT_MATCH — which signal import-session conflicts, missing models, server-capacity or link problems, and language mismatches during validation.

Tables Accessed

The package operates against the following objects, typically via APPS synonyms:

• CZ_END_USERS — The principal table of CZ end-user definitions; read and updated by VALIDATE_END_USERS and ENABLE_END_USERS.
• CZ_DB_SETTINGS — Repository of CZ database-level configuration settings consulted during validation and synchronization.
• ALL_USERS — The data dictionary view used to confirm that end-user accounts correspond to actual database users.
• V$SESSION — Live session information used by the synchronization procedures to determine which import and publish sessions are genuinely active, and to detect active-session conflicts.
• DBMS_LOCK and DBMS_SQL — Supplied PL/SQL packages used for serialization (lock acquisition) and dynamic SQL execution during synchronization and waiting.

Usage Notes

CZ_ADMIN is expected to be invoked from the CZ administrative forms, concurrent programs, or custom PL/SQL that manages end-user access and import/publish sessions. The synchronization procedures are typically scheduled or called before starting an import or publish operation so that stale session records do not block the new run. Because the package is AUTHID CURRENT_USER, any calling code must ensure the executing schema has appropriate privileges on the referenced tables and dictionary views. It is referenced by approximately ten other packages in the CZ schema, indicating its role as a shared administrative utility rather than a standalone interface. The header comment dates the source to release 115.13 (2004), reflecting the package's long-standing stability across EBS 12.1.1 and 12.2.2.