Search Results cz_ui_page_refs_pk

Overview

CZ_UI_PAGE_REFS is a Configurator (CZ) module table in the Oracle E-Business Suite that stores page references belonging to a menu or flow definition. Within the Configurator runtime, user interface definitions are assembled from individual pages, and this table records the structural relationship between a page set, its owning UI definition, and each referenced page node. It is the physical anchor for the navigational graph that the Configurator presents to end users when configuring a model, including sequencing, depth, parent/child linkage, and conditional visibility of each page.

The table is owned by the CZ schema and is documented as VALID in both EBS 12.1.1 and 12.2.2. In 12.2.2 the physical schema contains 30 columns. The heuristic Data Vault classification mined from the foreign-key structure is standalone, meaning the table is not itself modeled as a hub, link, or satellite in that heuristic view; a dimensional modeler could alternatively treat it as a link between page-set and UI-definition hubs, but the documented classification places it outside the hub/link/satellite pattern.

Key Information Stored

The primary key is CZ_UI_PAGE_REFS_PK, composed of the three columns PAGE_SET_ID, UI_DEF_ID, and PAGE_REF_ID. PAGE_REF_ID is the surrogate identifier for a single page reference, while PAGE_SET_ID and UI_DEF_ID are the business-context keys that scope each reference to a particular page set within a particular UI definition.

• PAGE_REF_ID — unique identifier of the page reference record.
• PAGE_SET_ID — the page set to which the reference belongs.
• UI_DEF_ID — the owning UI definition (menu or flow).
• PARENT_PAGE_REF_ID — self-referencing pointer establishing the hierarchical page tree.
• SEQ_NBR and NODE_DEPTH — ordering within a sibling group and depth in the tree, used for rendering.
• PAGE_REF_TYPE — classification of the referenced node (for example page versus menu/flow construct).
• CONDITION_ID and CAPTION_RULE_ID — conditional logic governing whether the page appears and how its caption is derived.
• NAME — developer-facing identifier of the page reference.
• CAPTION_TEXT_ID and PERSISTENT_CAPTION_TEXT_ID — references to localized and persisted caption text.
• TARGET_PATH, TARGET_UI_DEF_ID, TARGET_PAGE_SET_ID, TARGET_PAGE_ID — navigation targets that define where the page leads.
• PATH_TO_PREV_PAGE and PATH_TO_NEXT_PAGE — traversal pointers used by the Configurator runtime for sequential navigation.
• DELETED_FLAG, EMPTY_PAGE_FLAG, and audit columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN) — lifecycle and row-state tracking.

Common Use Cases and Queries

Typical uses include auditing the page structure of a shipped or custom Configurator UI definition, diagnosing navigation defects where a page is unreachable, and reporting on conditional logic that hides or reveals pages. A frequent pattern retrieves the ordered page tree for one UI definition:

SELECT PAGE_REF_ID, PARENT_PAGE_REF_ID, SEQ_NBR, NODE_DEPTH, NAME, PAGE_REF_TYPE
FROM CZ.CZ_UI_PAGE_REFS
WHERE UI_DEF_ID = :ui_def_id AND PAGE_SET_ID = :page_set_id
AND NVL(DELETED_FLAG,'N') = 'N'
ORDER BY NODE_DEPTH, SEQ_NBR;

Navigation analysis uses PATH_TO_PREV_PAGE and PATH_TO_NEXT_PAGE to reconstruct the linear flow, while target analysis joins TARGET_UI_DEF_ID and TARGET_PAGE_SET_ID to identify cross-definition jumps. Condition-driven pages can be isolated by filtering on CONDITION_ID or CAPTION_RULE_ID to verify that rule assignments remain valid after a Configurator upgrade. Because the primary key is composite, all lookup queries should be scoped by UI_DEF_ID and PAGE_SET_ID to avoid ambiguous PAGE_REF_ID matches across definitions.

Related Objects

The following objects are the most significant dependencies based on the documented key structure and typical CZ schema relationships:

• CZ_UI_DEFS — join on UI_DEF_ID; the parent UI definition that owns the page references.
• CZ_UI_PAGE_SETS — join on PAGE_SET_ID; defines the page set context.
• CZ_UI_PAGES — join on TARGET_PAGE_ID / PAGE_REF_ID; resolves each reference to its underlying page object.
• CZ_UI_PAGE_REFS (self-join) — join PARENT_PAGE_REF_ID to PAGE_REF_ID to walk the page hierarchy.
• CZ_UI_CONDITIONS (or the condition definition table referenced by CONDITION_ID) — resolves conditional display rules.
• CZ_UI_CAPTION_RULES (referenced by CAPTION_RULE_ID) — resolves dynamic caption derivation.
• Configurator runtime and UI rendering APIs that consume CZ_UI_DEF_ID, PAGE_SET_ID, and PAGE_REF_ID to compose the menu or flow at run time.