Search Results pop_map_id




Overview

The CZ_POPULATOR_MAPS table is a historical data object within the Oracle E-Business Suite Configurator (CZ) module. As explicitly noted in the official ETRM documentation, this table is marked as OBSOLETE. Its original role was to support the Configurator Engine's data population framework, which is responsible for loading and managing runtime data for configurable models. The table functioned as a mapping entity, likely associating specific data populators—components that fetch and inject data—with their target data maps or structures. In contemporary implementations of Oracle EBS 12.1.1 and 12.2.2, this table is considered legacy and is not intended for direct use in custom development, integration, or reporting.

Key Information Stored

Based on the provided metadata, the table's structure centers on a composite primary key and a foreign key relationship. The two key columns are POP_MAP_ID and POPULATOR_ID, which together form the primary key (CZ_POPULATOR_MAPS_PK). This indicates that the table's fundamental purpose was to maintain unique associations between a populator identifier and a map identifier. The POPULATOR_ID column is specifically documented as a foreign key referencing the CZ_POPULATORS table, which would have stored the master definition of the populator components themselves. The exact nature of the data represented by POP_MAP_ID is not detailed in the excerpt but would have been integral to the mapping logic.

Common Use Cases and Queries

Given the table's obsolete status, there are no supported common use cases in active Oracle EBS environments. Direct queries or modifications against this table are strongly discouraged as the underlying functionality has been superseded. Historically, a query to understand the mappings for a specific populator might have resembled: SELECT * FROM cz.cz_populator_maps WHERE populator_id = <ID_VALUE>;. Any reporting or data extraction needs related to configurator population logic in current versions must be addressed through supported public APIs and views provided by the CZ module, not through this obsolete table.

Related Objects

The ETRM documentation confirms one direct foreign key relationship for this table. This relationship is critical for understanding its obsolete schema context.

  • CZ_POPULATORS: This is the primary related table. The CZ_POPULATOR_MAPS.POPULATOR_ID column references the CZ_POPULATORS table. This relationship enforced referential integrity between a mapping record and the master definition of the populator component it utilized.

The CZ_POPULATORS table itself may also be obsolete or significantly altered in current releases, given the obsolescence of its dependent mapping table.