Search Results cz_ui_actions_pk

Overview

CZ_UI_ACTIONS is a table in the CZ (Configurator) product schema within Oracle E-Business Suite 12.1.1 and 12.2.2. It stores user-interface Actions definition — the metadata that drives how Configurator-generated user interfaces respond to user interactions. Each row defines a single action attached to a UI element on a source page within a UI definition, covering navigation targets, window behavior, rendering conditions, and optional processing-page presentation.

From a Data Vault modeling perspective, the mined heuristic classification is standalone. No foreign-key relationships were identified in the documented FK structure, so the table is best treated as an independent object rather than a hub, link, or satellite. Its composite primary key combines action, UI definition, source page, and edition context, distinguishing it as an edition-aware definition table typical of Configurator metadata in 12.2.2.

Key Information Stored

The documented physical schema contains 35 columns. The most significant are:

UI_ACTION_ID, UI_DEF_ID, SOURCE_PAGE_ID — the composite primary key components (CZ_UI_ACTIONS_PK). Together they identify the action, the owning UI definition, and the page on which the action originates.
ZD_EDITION_NAME — an edition discriminator present in the unique index CZ_UI_ACTIONS_PK (UI_ACTION_ID, UI_DEF_ID, SOURCE_PAGE_ID, ZD_EDITION_NAME), making the full index the business-key candidate and enabling multi-edition coexistence within 12.2.2.
UI_ACTION_TYPE — classifies the action (for example navigation, URL launch, or processing).
CONTEXT_COMPONENT_ID, ELEMENT_ID — identify the UI component or element to which the action is bound.
RENDER_CONDITION_ID — references the condition controlling whether the action is rendered.
TARGET_UI_DEF_ID, TARGET_PAGE_ID, TARGET_PAGE_SET_ID, TARGET_NODE_PATH, TARGET_PERSISTENT_NODE_ID, TARGET_EXPL_NODE_ID — describe the navigation target within Configurator.
TARGET_URL, TARGET_ANCHOR, FRAME_NAME, URL_PROPERTY_ID — describe external or URL-based targets.
TARGET_WINDOW_TYPE, TARGET_WINDOW_NAME, WINDOW_PARAMETERS — control window behavior and geometry.
PROCESSING_PAGE_ENABLED_FLAG, PROCESSING_PAGE_TEMPL_ID, PROC_PAGE_TEMPL_UI_DEF_ID, PAGE_TITLE_TEXT_ID, MAIN_MESSAGE_TEXT_ID, PROCESSING_CAPTION_TEXT_ID — the optional processing-page presentation, including template, title, message, and caption text references.
SEEDED_FLAG, DELETED_FLAG, CX_COMMAND_NAME — seed status, logical deletion, and the associated command name.
CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard EBS audit columns.

Common Use Cases and Queries

Typical uses include auditing the actions defined on a Configurator page, tracing navigation targets, and diagnosing actions that fail to render or launch.

List actions for a UI definition and page: SELECT ui_action_id, ui_action_type, target_url FROM cz.cz_ui_actions WHERE ui_def_id = :p_ui_def_id AND source_page_id = :p_page_id AND deleted_flag = 'N' AND zd_edition_name = :p_edition;
Report seeded versus customer-defined actions: filter on SEEDED_FLAG.
Identify URL-launching actions by joining URL_PROPERTY_ID to the corresponding property definition.
Edition comparisons: group by ZD_EDITION_NAME to see which actions exist in each edition.
Trace rendering conditions by joining RENDER_CONDITION_ID to the condition definition table.

Related Objects

The documented FK structure yields no joins; relationships are implied by the ID columns rather than enforced foreign keys. Significant related objects include:

CZ_UI_DEFINITIONS — joined on UI_DEF_ID; the owning UI definition.
CZ_UI_PAGES (or page metadata) — joined on SOURCE_PAGE_ID.
CZ_UI_ELEMENTS / component metadata — joined on ELEMENT_ID and CONTEXT_COMPONENT_ID.
CZ_UI_CONDITIONS — joined on RENDER_CONDITION_ID.
CZ_UI_NODES — joined on TARGET_UI_DEF_ID, TARGET_PAGE_ID, or TARGET_PERSISTENT_NODE_ID.
CZ_URL_PROPERTIES — joined on URL_PROPERTY_ID.
CZ_TEXT / text definitions — joined on PAGE_TITLE_TEXT_ID, MAIN_MESSAGE_TEXT_ID, and PROCESSING_CAPTION_TEXT_ID.
CZ_PAGE_TEMPLATES — joined on PROCESSING_PAGE_TEMPL_ID and PROC_PAGE_TEMPL_UI_DEF_ID.
CZ_UI_DEFS_TL — for translatable names of owning and target definitions.

Because these joins are not enforced at the database level, referential integrity is maintained by Configurator application logic.

Table: CZ_UI_ACTIONS 12.1.1
owner:CZ, object_type:TABLE, fnd_design_data:CZ.CZ_UI_ACTIONS, object_name:CZ_UI_ACTIONS, status:VALID, product: CZ - Configurator , description: User-interface Actions definition , implementation_dba_data: CZ.CZ_UI_ACTIONS ,
INDEX: CZ.CZ_UI_ACTIONS_PK 12.2.2
owner:CZ, object_type:INDEX, object_name:CZ_UI_ACTIONS_PK, status:VALID,
Table: CZ_UI_ACTIONS 12.2.2
owner:CZ, object_type:TABLE, fnd_design_data:CZ.CZ_UI_ACTIONS, object_name:CZ_UI_ACTIONS, status:VALID, product: CZ - Configurator , description: User-interface Actions definition , implementation_dba_data: CZ.CZ_UI_ACTIONS ,
INDEX: CZ.CZ_UI_ACTIONS_PK 12.1.1
owner:CZ, object_type:INDEX, object_name:CZ_UI_ACTIONS_PK, status:VALID,
TABLE: CZ.CZ_UI_ACTIONS 12.1.1
owner:CZ, object_type:TABLE, fnd_design_data:CZ.CZ_UI_ACTIONS, object_name:CZ_UI_ACTIONS, status:VALID,
12.2.2 DBA Data 12.2.2
12.1.1 DBA Data 12.1.1
12.2.2 DBA Data 12.2.2
12.1.1 DBA Data 12.1.1
TABLE: CZ.CZ_UI_ACTIONS 12.2.2
owner:CZ, object_type:TABLE, fnd_design_data:CZ.CZ_UI_ACTIONS, object_name:CZ_UI_ACTIONS, status:VALID,
eTRM - CZ Tables and Views 12.1.1
description: Import control table responsible for NOUPDATE flags ,
eTRM - CZ Tables and Views 12.2.2
description: Import control table responsible for NOUPDATE flags ,
eTRM - CZ Tables and Views 12.1.1
description: Import control table responsible for NOUPDATE flags ,
eTRM - CZ Tables and Views 12.2.2
description: Import control table responsible for NOUPDATE flags ,