Search Results cz_ui_page_elements_s

Overview

APPS.CZ_XML is a VALID PL/SQL package body owned by the APPS schema within the Oracle E-Business Suite 12.1.1 and 12.2.2 environments. Its primary business function is to manage the XML representation of Oracle Application Framework (OAF) and HTML-based user interface artifacts configured in EBS, particularly the customer-facing UI definitions held in the CZ (Oracle Configurator / iSetup-related "CZ") schema. The package handles parsing, validation, transformation, repair, and restoration of UI metadata stored as XML documents and their associated database records. It operates against JDR (Java Data Repository) documents — the JDR_ATTRIBUTES and related structures used by Oracle's Metadata Services (MDS) — and is used to detect and correct corrupted or structurally invalid UI page, template, and element definitions. Because the user searched for cz_ui_page_elements_s, it is worth noting that this table is a direct dependency of CZ_XML, indicating that the package specifically reads and manipulates UI page element definitions, including their translated/standard side variants (the "_S" table). CZ_XML is not referenced by any other database object, so it functions as a top-level utility rather than a dependency for downstream APIs.

Key Procedures and Functions

The documented package exposes 14 procedures/functions, which fall into three functional families — testing, parsing/saving, and repair/restoration:

TEST_UI_PAGES — Diagnostic routine that scans UI page definitions for integrity issues.
PARSE_JRAD_DOCUMENT — Parses a JDR (Java Data Repository) XML document into its constituent attributes for inspection and processing.
SAVE_DOCUMENT — Persists a modified XML/JDR document back to the repository.
DETECT_DOC_BAD_ATTRIBUTES — Identifies invalid attributes within a JDR document.
REMOVE_BAD_ATTRIBUTES_IN_DOC — Removes the invalid attributes detected in a single document.
DETECT_UIS_WITH_BAD_ATTRIBUTES — Scans all UI definitions for documents containing bad attributes.
REMOVE_BAD_ATTRIBUTES_IN_UIS — Removes identified bad attributes across UI definitions.
DETECT_TMPLS_WITH_BAD_ATTRS — Detects templates containing invalid attributes.
REMOVE_BAD_ATTRIBUTES_IN_TMPLS — Cleans bad attributes from templates.
REPLACE_BAD_ELEMENT_IDS — Replaces invalid element identifiers in UI page element definitions.
RESTORE_PARENT_ELEMENTS — Reconstructs parent-child element hierarchies in UI pages.
RESTORE_UI_RULE_IDS — Restores rule identifier references for UI definitions.
RESTORE_TMPL_RULE_IDS — Restores rule identifier references for templates.
ADD_TEMPLATE_REFERENCES — Adds or reinstates template reference links within UI definitions.

Tables Accessed

CZ_XML accesses a broad set of CZ-registry and repository tables via APPS synonyms. The CZ_UI_* family — CZ_UI_DEFS, CZ_UI_PAGES, CZ_UI_PAGE_ELEMENTS, CZ_UI_PAGE_ELEMENTS_S, CZ_UI_REFS, and CZ_UI_TEMPLATES — stores the UI metadata that is parsed, validated, and repaired. CZ_RULES and CZ_RP_ENTRIES support rule identifier restoration. CZ_INTL_TEXTS holds internationalized text strings referenced during document processing. CZ_DB_LOGS records diagnostic output. CZ_XFR_RUN_INFOS_S tracks transfer/run metadata. JDR_ATTRIBUTES holds the raw MDS/JDR attribute rows used when parsing and saving documents. Utility dependencies include DBMS_LOB (large object handling), DUAL, XMLDOM, XMLPARSER, DBMS_XMLDOM, and XDB for XML manipulation, plus FND_API, FND_GLOBAL, FND_MESSAGE, FND_MSG_PUB, and FND_LANGUAGES_VL for standard EBS API, logging, messaging, and language support.

Usage Notes

CZ_XML is typically invoked as a repair and validation utility rather than through standard user-facing forms. It is most commonly executed during diagnostics of Oracle Configurator UI corruption, during patching or migration between release levels (12.1.1 to 12.2.2), or through ad-hoc PL/SQL scripts by an administrator or Oracle Support engineer. It is not referenced by other database objects, confirming that it is intended for standalone execution. Because procedures such as DETECT_* and REMOVE_* can modify UI, template, and rule metadata, invocation should be preceded by a verified backup, and the diagnostic TEST_UI_PAGES routine is the appropriate first step. Regression testing in a non-production environment is strongly advised given the direct manipulation of CZ_UI_PAGE_ELEMENTS and related records.

SEQUENCE: CZ.CZ_UI_PAGE_ELEMENTS_S 12.1.1
owner:CZ, object_type:SEQUENCE, object_name:CZ_UI_PAGE_ELEMENTS_S, status:VALID,
SEQUENCE: CZ.CZ_UI_PAGE_ELEMENTS_S 12.2.2
owner:CZ, object_type:SEQUENCE, object_name:CZ_UI_PAGE_ELEMENTS_S, status:VALID,
SYNONYM: APPS.CZ_UI_PAGE_ELEMENTS_S 12.2.2
owner:APPS, object_type:SYNONYM, object_name:CZ_UI_PAGE_ELEMENTS_S, status:VALID,
SYNONYM: APPS.CZ_UI_PAGE_ELEMENTS_S 12.1.1
owner:APPS, object_type:SYNONYM, object_name:CZ_UI_PAGE_ELEMENTS_S, status:VALID,
12.1.1 DBA Data 12.1.1
12.2.2 DBA Data 12.2.2
12.2.2 DBA Data 12.2.2
12.1.1 DBA Data 12.1.1
PACKAGE BODY: APPS.CZ_XML 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:CZ_XML, status:VALID,
PACKAGE BODY: APPS.CZ_XML 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:CZ_XML, status:VALID,
PACKAGE BODY: APPS.CZ_UIOA_PVT 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:CZ_UIOA_PVT, status:VALID,
PACKAGE BODY: APPS.CZ_UIOA_PVT 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:CZ_UIOA_PVT, status:VALID,
PACKAGE BODY: APPS.CZ_DEVELOPER_UTILS_PVT 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:CZ_DEVELOPER_UTILS_PVT, status:VALID,
PACKAGE BODY: APPS.CZ_DEVELOPER_UTILS_PVT 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:CZ_DEVELOPER_UTILS_PVT, status:VALID,
12.1.1 DBA Data 12.1.1
12.2.2 DBA Data 12.2.2
APPS.CZ_XML dependencies on CZ_UI_PAGE_ELEMENTS_S 12.1.1
APPS.CZ_DEVELOPER_UTILS_PVT dependencies on CZ_UI_PAGE_ELEMENTS_S 12.2.2
APPS.CZ_DEVELOPER_UTILS_PVT dependencies on CZ_UI_PAGE_ELEMENTS_S 12.1.1
APPS.CZ_UIOA_PVT dependencies on CZ_UI_PAGE_ELEMENTS_S 12.1.1
APPS.CZ_UIOA_PVT dependencies on CZ_UI_PAGE_ELEMENTS_S 12.2.2
APPS.CZ_XML dependencies on CZ_UI_PAGE_ELEMENTS_S 12.2.2
APPS.CZ_MIGRATE SQL Statements 12.1.1
APPS.CZ_MIGRATE SQL Statements 12.2.2
APPS.CZ_UIOA_PVT dependencies on CZ_UI_PAGES_S 12.2.2
APPS.CZ_UIOA_PVT dependencies on CZ_UI_PAGE_SETS_S 12.1.1
APPS.CZ_UIOA_PVT dependencies on CZ_UI_PAGE_SETS_S 12.2.2
APPS.CZ_UIOA_PVT dependencies on CZ_UI_PAGES_S 12.1.1
APPS.CZ_UIOA_PVT dependencies on CZ_UI_ACTIONS_S 12.1.1
APPS.CZ_UIOA_PVT dependencies on CZ_UI_ACTIONS_S 12.2.2
APPS.CZ_UIOA_PVT dependencies on CZ_UI_PAGE_REFS_S 12.1.1
APPS.CZ_UIOA_PVT dependencies on CZ_UI_PAGE_REFS_S 12.2.2
APPS.CZ_UIOA_PVT dependencies on DUAL 12.2.2
APPS.CZ_UIOA_PVT dependencies on DUAL 12.1.1
APPS.CZ_UIOA_PVT dependencies on CZ_UI_ACTIONS 12.1.1
PACKAGE BODY: APPS.CZ_MIGRATE 12.2.2
PACKAGE BODY: APPS.CZ_MIGRATE 12.1.1
APPS.CZ_UIOA_PVT dependencies on CZ_UI_PAGE_SETS 12.1.1
APPS.CZ_UIOA_PVT dependencies on CZ_UI_ACTIONS 12.2.2
APPS.CZ_UIOA_PVT dependencies on CZ_UI_PAGE_SETS 12.2.2
APPS.CZ_UIOA_PVT dependencies on CZ_UI_PAGE_ELEMENTS 12.1.1
APPS.CZ_MIGRATE dependencies on CZ_XFR_TABLES 12.2.2
APPS.CZ_MIGRATE dependencies on CZ_XFR_TABLES 12.1.1
APPS.CZ_UIOA_PVT dependencies on CZ_UI_PAGE_ELEMENTS 12.2.2
PACKAGE BODY: APPS.CZ_UIOA_PVT 12.1.1
PACKAGE BODY: APPS.CZ_UIOA_PVT 12.2.2
12.2.2 DBA Data 12.2.2
APPS.CZ_UIOA_PVT dependencies on CZ_UI_PAGES 12.1.1
APPS.CZ_UIOA_PVT dependencies on CZ_UI_PAGES 12.2.2
APPS.CZ_UIOA_PVT dependencies on CZ_UI_PAGE_REFS 12.2.2