Search Results hr_form_windows_b




Overview
Explore in AI Chat

Overview

HR_FORM_WINDOWS_B is a core definition table in the Oracle E-Business Suite Human Resources (PER) module. It stores the definition of windows used within configurable forms, forming part of the metadata framework that drives the Oracle HRMS configurable forms architecture. In Oracle EBS 12.1.1 and 12.2.2, this table enables the runtime rendering engine to determine which window regions, canvases, and properties should be associated with a given form definition. The table is owned by the HR schema and holds a VALID status within the ETRM repository.

From a data modeling perspective, the relationship metadata suggests a hub-leaning classification within a Data Vault heuristic model. The table is referenced by four downstream child tables via the FORM_WINDOW_ID column, while its primary key is the sole inbound identifier, indicating it behaves as a central reference point (hub) from which multiple satellites and links radiate. This classification is offered as a modeling suggestion rather than a prescriptive design.

Key Information Stored

The table contains eleven documented columns. The most consequential are listed below.

  • FORM_WINDOW_ID — The surrogate primary key (HR_FORM_WINDOWS_B_PK) that uniquely identifies each window definition. All child tables reference this column.
  • APPLICATION_ID — Identifies the application context to which the form and window belong.
  • FORM_ID — Identifies the configurable form that owns this window definition.
  • WINDOW_NAME — The developer-facing name of the window, used to resolve the window at runtime.
  • OBJECT_VERSION_NUMBER — Supports optimistic locking during concurrent updates.
  • ZD_EDITION_NAME — The editioning column introduced for Online Patching (adop) in EBS 12.2, enabling edition-based redefinition.
  • LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — Standard audit columns tracking the most recent modification.
  • CREATED_BY, CREATION_DATE — Standard audit columns recording initial creation.

Two unique indexes are documented. HR_FORM_WINDOWS_B_PK spans FORM_WINDOW_ID and ZD_EDITION_NAME, confirming the surrogate key. HR_FORM_WINDOWS_B_UK spans APPLICATION_ID, FORM_ID, WINDOW_NAME, and ZD_EDITION_NAME, establishing the business-key candidate that guarantees a window name is unique within a given form and application context.

Common Use Cases and Queries

Typical scenarios include diagnosing why a window fails to render in a configurable form, auditing window definitions across applications, and generating inventories of windows for a specific form. A representative query retrieves all windows for a given form:

  • SELECT FORM_WINDOW_ID, WINDOW_NAME, APPLICATION_ID FROM HR.FORM_WINDOWS_B WHERE FORM_ID = :p_form_id AND ZD_EDITION_NAME = 'ORA$BASE';
  • Joining to the translation table HR_FORM_WINDOWS_TL retrieves the user-visible display name.
  • Joining to HR_WINDOW_PROPERTIES_B enumerates the configurable properties applying to each window.
  • Joining to HR_FORM_CANVASES_B links windows to their canvas definitions for layout analysis.

Related Objects

Several objects depend on or reference HR_FORM_WINDOWS_B, joined through the FORM_WINDOW_ID column.

  • HR_FORM_WINDOWS_TL — Translation table supplying language-specific window text; joined on FORM_WINDOW_ID.
  • HR_FORM_CANVASES_B — Defines canvases belonging to each window; joined on FORM_WINDOW_ID.
  • HR_TEMPLATE_WINDOWS_B — Associates windows with form templates; joined on FORM_WINDOW_ID.
  • HR_WINDOW_PROPERTIES_B — Stores property settings for each window; joined on FORM_WINDOW_ID.
  • The configurable forms runtime APIs in the PER module consume these relationships to render forms dynamically.