Results for “hr_form_canvases_vl”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

The HR_FORM_CANVASES_VL view is a translated (MLS) view owned by the APPS schema in Oracle E-Business Suite, delivered under the PER — Human Resources product. It exposes form canvas definitions — the configurable canvas regions that Oracle Forms-based EBS pages render for a given form window — while resolving translatable attributes from the corresponding language table. In EBS 12.1.1 and 12.2.2 the view is reported as VALID in the ETRM repository.

The "_VL" suffix denotes the standard Oracle "translated view" pattern: a view that joins a base (non-translated) table with its translation table, filtering the translation rows to the session language. As a result, the view presents one row per form canvas in a single language, selected by the runtime environment rather than by an explicit predicate in the calling query. This makes it the preferred read interface for reports, concurrent programs, and external integrations that need canvas metadata in the user's language without embedding language-handling logic.

Underlying Base Objects

The view is defined over two synonym-referenced base objects:

• HR_FORM_CANVASES_B — the base table holding language-independent canvas attributes.
• HR_FORM_CANVASES_TL — the translation table holding language-dependent attributes.

The join condition is B.FORM_CANVAS_ID = T.FORM_CANVAS_ID AND T.LANGUAGE = USERENV('LANG'). The language predicate is fixed inside the view definition, so only translation rows matching the current session language are returned; the view does not expose a LANGUAGE column for caller filtering. The view also selects B.ROWID, exposing the base-table row identifier.

Key Columns

• FORM_CANVAS_ID — primary identifier for the canvas definition; the join key between the base and translation tables.
• OBJECT_VERSION_NUMBER — optimistic locking / concurrency control column used by the Forms-based maintenance UI.
• FORM_WINDOW_ID — foreign key to the parent form window to which the canvas belongs.
• CANVAS_NAME — language-independent internal canvas name (from the base table).
• USER_CANVAS_NAME — translated, user-facing canvas name (from the translation table).
• CANVAS_TYPE — classification of the canvas (for example content or stacked canvas).
• DESCRIPTION — translated descriptive text for the canvas.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATED_BY, CREATION_DATE — standard EBS WHO columns for audit and change tracking; note that these are sourced from the base table only.
• ROW_ID — the ROWID of the underlying HR_FORM_CANVASES_B row.

Common Use Cases and Queries

Typical usage includes reporting on form canvas configuration, validating canvas-to-window relationships during implementation, and extracting translated canvas metadata for documentation or migration analysis. Because the language filter is internal, queries need only an optional WHERE clause.

• List all canvases for a window in the current language:

  SELECT form_canvas_id, form_window_id, user_canvas_name, canvas_type
  FROM   apps.hr_form_canvases_vl
  WHERE  form_window_id = :p_window_id
  ORDER  BY user_canvas_name;

• Search by user-facing canvas name:

  SELECT form_canvas_id, canvas_name, user_canvas_name, description
  FROM   apps.hr_form_canvases_vl
  WHERE  UPPER(user_canvas_name) LIKE UPPER('%' || :p_name || '%');

• Audit recent configuration changes:

  SELECT form_canvas_id, user_canvas_name, last_update_date, last_updated_by
  FROM   apps.hr_form_canvases_vl
  WHERE  last_update_date >= :p_since
  ORDER  BY last_update_date DESC;

In all cases, query the view rather than the base tables directly to obtain the correct session-language translation of USER_CANVAS_NAME and DESCRIPTION.