Search Results hr_window_properties_b




Overview
Explore in AI Chat

Overview

HR_WINDOW_PROPERTIES_B is a Human Resources (PER) base table in Oracle E-Business Suite 12.1.1 and 12.2.2 that stores the physical and behavioral properties of windows rendered by Oracle's configurable forms framework. Configurable forms allow administrators to tailor the layout of standard EBS forms without modifying compiled Oracle Forms (.fmb) files; the window geometry, position, and supplementary information captured in this table drive that rendering at runtime. The table is the base (language-independent) counterpart to HR_WINDOW_PROPERTIES_TL, which holds the translated (TL) attributes, and it sits beneath the window definitions maintained in HR_FORM_WINDOWS_B and HR_TEMPLATE_WINDOWS_B.

Under a heuristic Data Vault classification mined from its foreign-key topology, HR_WINDOW_PROPERTIES_B is satellite-leaning: it carries descriptive, attribute-rich payload about a window property entity while pointing outward to the parent window and template definitions. This is a modeling suggestion only, not an enforced schema characteristic.

Key Information Stored

The table contains 44 documented columns. The most operationally significant are:

  • WINDOW_PROPERTY_ID — surrogate primary key, enforced by HR_WINDOW_PROPERTIES_B_PK; uniquely identifies each window-property row within the ZD_EDITION_NAME edition.
  • FORM_WINDOW_ID — foreign key to HR_FORM_WINDOWS_B, identifying the form-level window definition to which the properties apply.
  • TEMPLATE_WINDOW_ID — foreign key to HR_TEMPLATE_WINDOWS_B, identifying the template window that supplies the base layout.
  • HEIGHT, WIDTH — pixel or unit dimensions governing the rendered window size.
  • X_POSITION, Y_POSITION — screen coordinates controlling where the window is displayed.
  • INFORMATION_CATEGORY — classification token that groups the informational attributes that follow.
  • INFORMATION1 … INFORMATION30 — a wide, sparse set of generic attribute columns used by the configurable-forms engine to store window-specific metadata that varies by form and template.
  • ZD_EDITION_NAME — editioning discriminator supporting the 12.2 online patching / edition-based redefinition model; it participates in both unique indexes.
  • LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATION_DATE, CREATED_BY — standard Who columns for audit and concurrency control.

Business-key candidates are captured by the unique index HR_WINDOW_PROPERTIES_B_UK over (FORM_WINDOW_ID, TEMPLATE_WINDOW_ID, WINDOW_PROPERTY_ID, ZD_EDITION_NAME), in addition to the surrogate PK HR_WINDOW_PROPERTIES_B_PK over (WINDOW_PROPERTY_ID, ZD_EDITION_NAME). The INFORMATION1–INFORMATION30 columns are of particular interest to anyone deploying custom window layouts, because they provide the extensible slots the framework reads when rendering non-standard window content.

Common Use Cases and Queries

Primary diagnostic and reporting scenarios include auditing window positions and sizes for a given form, verifying that template-derived properties have been correctly overridden, and comparing property sets across editions during upgrade validation in 12.2. A representative query joins the base table to its parents to resolve a human-readable window context:

  • SELECT p.WINDOW_PROPERTY_ID, p.FORM_WINDOW_ID, p.TEMPLATE_WINDOW_ID, p.HEIGHT, p.WIDTH, p.X_POSITION, p.Y_POSITION FROM hr.hr_window_properties_b p WHERE p.FORM_WINDOW_ID = :form_window_id;
  • Join to HR_WINDOW_PROPERTIES_TL on WINDOW_PROPERTY_ID to obtain translated labels and descriptions alongside the geometric properties.
  • Filter by ZD_EDITION_NAME (for example, WHERE ZD_EDITION_NAME = 'ORA$BASE') to isolate the run-edition rows during patching analysis.
  • Scan INFORMATION1 through INFORMATION30 for non-null values to discover which forms exercise the extensible attribute slots.

Related Objects

  • HR_FORM_WINDOWS_B — referenced via HR_WINDOW_PROPERTIES_B.FORM_WINDOW_ID; parent definition of form-level windows.
  • HR_TEMPLATE_WINDOWS_B — referenced via HR_WINDOW_PROPERTIES_B.TEMPLATE_WINDOW_ID; parent template window definitions.
  • HR_WINDOW_PROPERTIES_TL — child translation table keyed on WINDOW_PROPERTY_ID; holds language-specific text.
  • HR_WINDOW_PROPERTIES_B_PK / HR_WINDOW_PROPERTIES_B_UK — the enforced primary and unique indexes that govern row identity and business-key uniqueness.
  • HR_FORM_WINDOWS_TL and HR_TEMPLATE_WINDOWS_TL — translation siblings of the parent window definitions, commonly joined through their base tables for reporting.