Search Results cz_pb_client_apps_pk




Overview
Explore in AI Chat

Overview

The CZ.CZ_PB_CLIENT_APPS table is a core configuration table within the Oracle Configurator module of Oracle E-Business Suite (EBS) versions 12.1.1 and 12.2.2. Its primary function is to manage the association between Oracle Configurator publications and the specific EBS applications, or "client applications," that are authorized to utilize them. A publication is a runtime version of a configurator model deployed for end-user interaction. This table acts as a control mechanism, ensuring that only designated applications can access and execute a given publication, thereby enforcing security and application context boundaries within the complex EBS architecture.

Key Information Stored

The table stores a straightforward mapping with four key columns. The PUBLICATION_ID is a mandatory foreign key that identifies the specific Configurator publication. The FND_APPLICATION_ID is a mandatory foreign key that identifies the associated Oracle EBS application, as defined in the FND_APPLICATION table. Together, these two columns form the table's unique primary key (CZ_PB_CLIENT_APPS_PK), preventing duplicate associations. The APPLICATION_SHORT_NAME is a denormalized, descriptive field holding the short name of the associated application, likely for performance and reporting convenience. Finally, the NOTES column provides a free-text field for administrative comments regarding the specific association.

Common Use Cases and Queries

The primary use case is administrative: verifying or auditing which EBS applications are enabled for a specific configurator publication. This is critical during implementation, upgrades, or troubleshooting access issues. A common query retrieves all client applications for a given publication, often joining to the FND_APPLICATION table for full application details beyond the short name. For example:

  • SELECT ca.PUBLICATION_ID, ca.APPLICATION_SHORT_NAME, fa.APPLICATION_NAME, ca.NOTES FROM cz.cz_pb_client_apps ca, applsys.fnd_application fa WHERE ca.fnd_application_id = fa.application_id AND ca.publication_id = :p_publication_id;

Conversely, to find all publications accessible to a particular application, one would query by FND_APPLICATION_ID. Reporting often involves joining this table to CZ_MODEL_PUBLICATIONS to list publications alongside their authorized client applications.

Related Objects

The CZ_PB_CLIENT_APPS table has defined relationships with other key Configurator and EBS foundation objects. Its primary key, CZ_PB_CLIENT_APPS_PK, is enforced via a unique index on the combination of PUBLICATION_ID and FND_APPLICATION_ID. A critical foreign key relationship exists where the PUBLICATION_ID column references the CZ_MODEL_PUBLICATIONS table, which is the master repository for all configurator publications. While not explicitly listed as a foreign key in the provided metadata, the FND_APPLICATION_ID column inherently references the APPLSYS.FND_APPLICATION table, the central registry for all EBS applications. The table itself is referenced by the APPS synonym CZ_PB_CLIENT_APPS, which is the standard access point for all application-tier code within the EBS environment.