Search Results prompt_alias




Overview
Explore in AI Chat

Overview

The HXC_LAYOUT_COMP_PROMPTS table is a core data structure within the Oracle E-Business Suite (EBS) Time and Labor Engine (HXC). It serves as a repository for the prompt definitions associated with individual layout components. In the context of Time and Labor, layouts define the structure and appearance of time entry interfaces, such as web clock or timesheet pages. Each layout contains components (e.g., fields, blocks, regions), and this table stores the specific prompts—the labels or data entry controls—that are rendered for those components. Its primary role is to enable the flexible configuration and personalization of time entry user interfaces by linking prompt metadata to layout component definitions.

Key Information Stored

The table's design centers on uniquely identifying prompts within a specific layout component. The primary key is the surrogate key LAYOUT_COMP_PROMPT_ID. A unique key constraint ensures that within a given LAYOUT_COMPONENT_ID, the combination of PROMPT_ALIAS and PROMPT_TYPE is unique. This structure is critical for the application logic to correctly retrieve and display the appropriate prompt. Key columns include:

  • LAYOUT_COMP_PROMPT_ID: The unique system-generated identifier for the prompt record.
  • LAYOUT_COMPONENT_ID: Foreign key to HXC_LAYOUT_COMPONENTS, identifying the parent layout component.
  • PROMPT_ALIAS: A code or name that identifies the prompt, often referencing a flexfield segment or a predefined prompt type.
  • PROMPT_TYPE: Categorizes the prompt (e.g., 'PROMPT', 'DESCRIPTIVE_FLEXFIELD'), determining how it is processed and displayed by the application.

Common Use Cases and Queries

This table is primarily accessed for configuration analysis, troubleshooting, and generating reports on Time and Labor UI setups. A common scenario involves identifying all prompts defined for a specific layout component or set of components to audit the timecard entry interface. For example, to list all prompts for a known layout component, a query would join to HXC_LAYOUT_COMPONENTS. Another use case is diagnosing missing or incorrect field labels on a timesheet by verifying the prompt definitions exist and are correctly linked. Developers may query this table when writing extensions or custom reports that need to interpret the structure of a time entry layout. Sample SQL to retrieve prompt details for a component would be: SELECT prompt_alias, prompt_type FROM hxc_layout_comp_prompts WHERE layout_component_id = <component_id> ORDER BY prompt_alias;

Related Objects

The table maintains a strict foreign key relationship with the HXC_LAYOUT_COMPONENTS table, which is fundamental to the Time and Labor layout architecture. The documented relationship is:

  • Foreign Key to HXC_LAYOUT_COMPONENTS: The column HXC_LAYOUT_COMP_PROMPTS.LAYOUT_COMPONENT_ID references the primary key of HXC_LAYOUT_COMPONENTS. This enforces that every prompt must belong to a valid, existing layout component. This relationship is essential for navigating from a high-level layout structure down to its constituent prompts.

Consequently, this table is a child of HXC_LAYOUT_COMPONENTS and is part of a larger hierarchy that likely includes HXC_LAYOUTS and other related HXC configuration tables.