Search Results hr_tips_pk




Overview
Explore in AI Chat

Overview

HR_TIPS is a Human Resources (PER) module table in the Oracle E-Business Suite, owned by the HR schema. Per the ETRM metadata, its documented purpose is to store "help components used within SSHR" — that is, the contextual help tips, instructional text, and guidance snippets surfaced to users inside Self-Service Human Resources (SSHR) pages and flows. In Oracle EBS 12.1.1 and 12.2.2 the table plays a supporting, non-transactional role: it does not drive payroll, assignment, or organizational processing, but it directly affects the user experience of self-service HR functions by supplying localized, screen-scoped help content.

From a Data Vault modeling perspective, the metadata's heuristic classification is satellite-leaning. The table is keyed on a surrogate identifier (TIP_ID) and carries descriptive attributes (text, filename, enabled flag) that describe a single business entity instance. It should therefore be treated as a modeling suggestion toward a satellite rather than a hub or link, though the presence of the BUSINESS_GROUP_ID foreign key introduces a light contextual dependency on organization structures.

Key Information Stored

The table contains eight documented columns. The most important are summarized below.

  • TIP_ID — the surrogate primary key, enforced by the HR_TIPS_PK constraint. It uniquely identifies each help tip record.
  • SCREEN — identifies the SSHR screen or page to which the tip belongs. Part of the business-key candidate index.
  • FIELD — identifies the specific field or region within the screen that the tip annotates. Part of the business-key candidate index.
  • LANGUAGE_CODE — the language in which the tip text is supplied, enabling multilingual help. Part of the business-key candidate index.
  • BUSINESS_GROUP_ID — the business group that owns the tip, providing multi-tenant partitioning. Part of the business-key candidate index and a foreign key to HR_ALL_ORGANIZATION_UNITS.
  • TEXT — the actual help content delivered to the user.
  • FILENAME — associated file reference for the help component.
  • ENABLED_FLAG — controls whether the tip is active and displayed.

The unique index HR_TIPS_UK1 (SCREEN, FIELD, LANGUAGE_CODE, BUSINESS_GROUP_ID) is the documented business-key candidate, distinct from the surrogate TIP_ID primary key. The column SYS_IL0000044498C00008$$ indicates a LOB segment associated with one of the large text columns, consistent with storing extended help text.

Common Use Cases and Queries

Typical uses include auditing which screens expose help tips, verifying multilingual coverage, and validating that every active tip is bound to a valid business group. A representative query retrieves enabled tips for a specific screen and language:

  • SELECT tip_id, screen, field, text FROM hr.hr_tips WHERE screen = :screen AND language_code = :lang AND enabled_flag = 'Y';
  • SELECT t.tip_id, t.screen, t.field, o.name FROM hr.hr_tips t JOIN hr.hr_all_organization_units o ON t.business_group_id = o.organization_id;

Reporting scenarios include identifying screens lacking localized content by comparing LANGUAGE_CODE values, and reconciling FILENAME references against deployed help artifacts.

Related Objects

  • HR_ALL_ORGANIZATION_UNITS — referenced via HR_TIPS.BUSINESS_GROUP_ID, supplying the owning business group name.
  • HR_TIPS_PK — the primary key constraint on TIP_ID.
  • HR_TIPS_UK1 — the unique business-key index over SCREEN, FIELD, LANGUAGE_CODE, BUSINESS_GROUP_ID.
  • SSHR help framework — the consumer of TIP records at runtime.
  • FND_LANGUAGES — referenced implicitly through LANGUAGE_CODE for localization validation.