Search Results cz_servers




Overview
Explore in AI Chat

Overview

The CZ_SERVERS table is a core reference table within the Oracle E-Business Suite Configurator (CZ) module. Its primary function is to register and identify distinct database servers that participate in the import and publication processes for configurator models. This table acts as a central registry, enabling the Configurator engine to manage and track the movement of configuration data, such as models and bills of material, between different database instances. This is critical for multi-server deployment scenarios, where development, testing, and production environments may reside on separate servers, or for distributed configurations requiring data synchronization.

Key Information Stored

While the provided metadata does not list individual columns, the primary and unique key constraints define the table's essential identifying attributes. The primary key, SERVER_LOCAL_ID, is a unique numeric identifier for each registered server record. The unique key, LOCAL_NAME, stores the logical or actual name used to identify the server within the Configurator module's processes. This name is a critical reference point for administrative setup and for the runtime resolution of server locations during data import and publication jobs. The table likely contains additional columns to store connection details, status flags, or descriptive information necessary for server management.

Common Use Cases and Queries

The primary use case for the CZ_SERVERS table is the administration and execution of model publication and data import flows. Administrators query this table to verify registered servers before initiating a publication job or to troubleshoot connectivity issues. A common reporting query would list all known servers for audit purposes. During a publication run, the Configurator application logic references this table to resolve the target server identifier (SERVER_LOCAL_ID) to its corresponding connection parameters. Sample SQL for auditing includes:

  • SELECT SERVER_LOCAL_ID, LOCAL_NAME FROM CZ.CZ_SERVERS ORDER BY SERVER_LOCAL_ID;
  • SELECT COUNT(*) AS SERVER_COUNT FROM CZ.CZ_SERVERS;

These queries help ensure the integrity of the server registry, which is foundational for successful data propagation across environments.

Related Objects

The CZ_SERVERS table is referenced as a parent table by several key transactional and process tables in the Configurator schema, as documented by its foreign key relationships. These relationships demonstrate how server identification is integral to specific business processes:

  • CZ_MODEL_PUBLICATIONS: References CZ_SERVERS via the SERVER_ID column. This links each model publication record to the target server where the model was published.
  • CZ_PB_MODEL_EXPORTS: References CZ_SERVERS via the SERVER_ID column. This ties model export jobs to a specific source or destination server.
  • CZ_XFR_PROJECT_BILLS: References CZ_SERVERS via the SOURCE_SERVER column. This associates the transfer of project bills of material with their system of origin.

These dependencies confirm that CZ_SERVERS is a vital reference point for tracking the lineage and destination of configuration data throughout its lifecycle.