Search Results full_image_path




Overview
Explore in AI Chat

Overview

APPS.CZ_UIELEMENT_IMAGES_V is a reporting and integration view in the Oracle E-Business Suite user interface (UI) configuration layer. It consolidates image assets associated with configurable UI elements, exposing both the raw image file reference and a fully resolved filesystem or URL path. The view draws on signature-level metadata (CZ_SIGNATURES) and path resolution logic (CZ_UI_PATHED_IMAGES_V) to deliver a flat, query-friendly result set suitable for concurrent programs, OAF/Forms personalization lookups, and BI Publisher extracts.

Because the object is a VIEW rather than a table, it performs no data storage of its own; it is a read-only projection. This makes it safe to query from custom reports, interfaces, and diagnostic scripts without concern for DML side effects. The view is owned by the APPS schema and carries FND Design Data identity CZ.CZ_UIELEMENT_IMAGES_V, and its documented status is VALID in the ETRM 12.2.2 metadata repository. The name follows Oracle's convention of the CZ prefix (the EBS "Common" UI configuration family) plus a trailing _V to signify a view.

Underlying Base Objects

The dependency documentation lists two referenced base objects:

The view is, in turn, referenced by APPS.CZ_PSNODE_REFUI_IMAGES_V, meaning it participates in a broader image-resolution chain used for page/section UI rendering. This layered dependency is typical of the CZ family, where low-level signature and path tables are wrapped by progressively more presentation-oriented views.

Key Columns

  • FULL_IMAGE_PATH (VARCHAR2 4000) — the resolved, complete path to the image. This is the column most commonly searched as "full_image_path"; it is the practical output value used when rendering or copying an image asset.
  • IMAGE_FILE (VARCHAR2 4000) — the image file name or relative reference prior to full path expansion.
  • IMAGE_USAGE_CODE (NUMBER) — a coded indicator of the usage context (e.g., which UI surface the image belongs to).
  • ELEMENT_SIGNATURE_ID (NUMBER) — foreign key back to the element signature definition.
  • ELEMENT_TYPE_NAME (VARCHAR2 30) — the textual element type classification.
  • ALT_TEXT (VARCHAR2 2000) — accessibility/alternate text associated with the image.
  • UI_DEF_ID (NUMBER) — identifier of the owning UI definition.

Common Use Cases and Queries

The view is most frequently used to audit or extract the repository of UI images and their resolved locations. A standard retrieval mirrors the documented query text:

  • SELECT IMAGE_USAGE_CODE, ELEMENT_SIGNATURE_ID, IMAGE_FILE, ELEMENT_TYPE_NAME, ALT_TEXT, UI_DEF_ID, FULL_IMAGE_PATH FROM APPS.CZ_UIELEMENT_IMAGES_V;
  • Locate a specific asset by path: SELECT * FROM APPS.CZ_UIELEMENT_IMAGES_V WHERE FULL_IMAGE_PATH LIKE '%logo%';
  • Group assets by type or usage to inventory configured imagery: SELECT ELEMENT_TYPE_NAME, IMAGE_USAGE_CODE, COUNT(*) FROM APPS.CZ_UIELEMENT_IMAGES_V GROUP BY ELEMENT_TYPE_NAME, IMAGE_USAGE_CODE;
  • Join to CZ_SIGNATURES via ELEMENT_SIGNATURE_ID to surface descriptive signature metadata alongside each image.

For diagnostic purposes, any row returning a NULL or malformed FULL_IMAGE_PATH indicates an unresolved path reference and typically warrants review of the underlying CZ_UI_PATHED_IMAGES_V definition or the UI configuration setup.