Search Results hxc_layout_components




Overview
Explore in AI Chat

Overview

The HXC_LAYOUT_COMPONENTS table is a core repository within the Oracle E-Business Suite (EBS) Time and Labor Engine (HXC). It serves as the structural definition table for the visual and logical components that constitute a Timecard Layout. A layout is the user interface template that determines how time entry fields, such as time, hours, projects, or tasks, are organized and presented to an employee. This table stores the hierarchical arrangement of these components, defining the parent-child relationships that create complex, nested layout structures, from simple time entry rows to sophisticated matrix-style timecards.

Key Information Stored

The table's primary function is to map layout definitions to their constituent parts and define their hierarchy. Key columns include LAYOUT_COMPONENT_ID, the unique primary key identifier for each component instance. The LAYOUT_ID is a foreign key linking the component to its parent template in the HXC_LAYOUTS table. The COMPONENT_NAME provides a unique identifier for the component within the system. Crucially, the PARENT_COMPONENT_ID column establishes the hierarchical relationship by referencing another record within the same HXC_LAYOUT_COMPONENTS table, allowing for nested structures. Finally, the LAYOUT_COMP_DEFINITION_ID links to the HXC_LAYOUT_COMP_DEFINITIONS table, which holds the technical definition of the component's type and behavior.

Common Use Cases and Queries

This table is central to understanding and customizing the time entry user experience. Common use cases include analyzing the structure of a specific layout for debugging or enhancement, generating documentation of all layout components, and identifying components that use a specific definition. A typical query retrieves the hierarchical tree of components for a given layout, which is essential for support or development tasks related to layout behavior.

  • To retrieve all components for a specific layout, ordered hierarchically: SELECT COMPONENT_NAME FROM HXC_LAYOUT_COMPONENTS CONNECT BY PRIOR LAYOUT_COMPONENT_ID = PARENT_COMPONENT_ID START WITH PARENT_COMPONENT_ID IS NULL AND LAYOUT_ID = <layout_id>;
  • To find the definition used by a specific component: SELECT * FROM HXC_LAYOUT_COMP_DEFINITIONS def, HXC_LAYOUT_COMPONENTS comp WHERE comp.LAYOUT_COMP_DEFINITION_ID = def.LAYOUT_COMP_DEFINITION_ID AND comp.COMPONENT_NAME = '<component_name>';

Related Objects

The HXC_LAYOUT_COMPONENTS table is a central node in the Time and Labor data model. It has a direct foreign key relationship to HXC_LAYOUTS, which stores the master layout definitions. Its self-referential relationship via PARENT_COMPONENT_ID manages component hierarchy. It references HXC_LAYOUT_COMP_DEFINITIONS for component-type metadata. Furthermore, it is the parent table for HXC_LAYOUT_COMP_PROMPTS, which stores the descriptive prompts displayed to users, and HXC_LAYOUT_COMP_QUALIFIERS, which stores rules controlling a component's visibility or eligibility based on user attributes. Understanding these relationships is critical for any data analysis or extension of the Timecard UI.