Search Results form_template_id




Overview
Explore in AI Chat

Overview

HR.HR_TEMPLATE_WINDOWS_B is a core configuration table in Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, owned by the Human Resources (HR) schema. It stores the definition of windows associated with form templates used by the Configurable Forms framework. In EBS terminology, a "window" represents a logical grouping of canvases and regions displayed to a user when a form template is rendered. The HR_TEMPLATE_WINDOWS_B table therefore acts as the bridge that binds a window layout to a specific form template, enabling the personalization and extension of standard Oracle Forms without modifying the underlying form binaries. The table is created under the FND design data object PER.HR_TEMPLATE_WINDOWS_B and resides in the APPS_TS_TX_DATA tablespace with PCTFREE 10. Based on the foreign-key structure and the presence of a surrogate primary key alongside foreign references to two parent dimension tables, the object is classified heuristically as satellite-leaning in a Data Vault model. It records descriptive relationship attributes that hang off the HR_FORM_TEMPLATES_B and HR_FORM_WINDOWS_B hubs rather than acting as a pure junction link.

Key Information Stored

The table contains ten documented columns. The surrogate primary key is TEMPLATE_WINDOW_ID, a NUMBER(15) generated from the sequence HR_TEMPLATE_WINDOWS_B_S. It uniquely identifies each template-window association and is the anchor used by all child objects. Two business-key candidates are enforced through unique indexes. The unique index HR_TEMPLATE_WINDOWS_B_UK covers FORM_WINDOW_ID and FORM_TEMPLATE_ID (with ZD_EDITION_NAME in the 12.2.2 documented schema), guaranteeing that a given window is attached to a given template only once. The foreign-key columns FORM_TEMPLATE_ID and FORM_WINDOW_ID are the business-critical identifiers: FORM_TEMPLATE_ID points to HR_FORM_TEMPLATES_B, and FORM_WINDOW_ID points to HR_FORM_WINDOWS_B. OBJECT_VERSION_NUMBER supports optimistic locking by incrementing on each row update. The remaining columns are standard Who columns—LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATED_BY, and CREATION_DATE—which provide audit and concurrency control. In EBS 12.2.2 the additional ZD_EDITION_NAME column appears in the unique indexes, reflecting the edition-based redefinition strategy introduced in the 12.2 release line.

Common Use Cases and Queries

Consultants and developers query this table to determine which windows belong to a form template, to diagnose Configurable Forms rendering issues, and to migrate or compare template configurations across environments. A frequent pattern joins the table to its parents to resolve human-readable template and window names:

  • Listing all windows for a given template: SELECT w.TEMPLATE_WINDOW_ID, w.FORM_WINDOW_ID, t.TEMPLATE_NAME FROM HR.HR_TEMPLATE_WINDOWS_B w, HR.HR_FORM_TEMPLATES_B t WHERE w.FORM_TEMPLATE_ID = t.FORM_TEMPLATE_ID AND w.FORM_TEMPLATE_ID = :template_id;
  • Identifying the template that owns a window: join on FORM_WINDOW_ID = HR_FORM_WINDOWS_B.FORM_WINDOW_ID.
  • Auditing recent configuration changes via LAST_UPDATE_DATE and LAST_UPDATED_BY.
  • Reporting the full template hierarchy by chaining to HR_TEMPLATE_CANVASES_B and HR_WINDOW_PROPERTIES_B through TEMPLATE_WINDOW_ID.

Because the table stores only configuration metadata, it is not a high-volume transactional object; queries are typically performed during implementation, upgrade validation, and troubleshooting.

Related Objects

The integrity of HR_TEMPLATE_WINDOWS_B depends on two parent tables and is extended by two child tables. The most significant related objects are:

  • HR.HR_FORM_TEMPLATES_B — parent; joined via FORM_TEMPLATE_ID. Defines the form template to which windows belong.
  • HR.HR_FORM_WINDOWS_B — parent; joined via FORM_WINDOW_ID. Defines the reusable window definition.
  • HR.HR_TEMPLATE_CANVASES_B — child; references TEMPLATE_WINDOW_ID. Defines canvases rendered inside each template window.
  • HR.HR_WINDOW_PROPERTIES_B — child; references TEMPLATE_WINDOW_ID. Holds property settings for each window instance.

Together these objects form the Configurable Forms metadata model, with HR_TEMPLATE_WINDOWS_B occupying the intermediate position between template definitions and the canvas and property detail levels.