Results for “hr_tab_page_properties_tl_pk”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

HR.HR_TAB_PAGE_PROPERTIES_TL is the translation (TL) table for tab page properties used to render tab pages in Oracle E-Business Suite configurable forms, particularly within the Oracle HRMS (PER) product family. Its FND Design Data identifier, PER.HR_TAB_PAGE_PROPERTIES_TL, confirms that it is delivered as seed data and that its contents drive the runtime presentation of configurable self-service and professional forms. The object resides in the APPS_TS_SEED tablespace, consistent with its role as reference or setup data rather than transactional data, and it carries VALID status in the ETRM registry.

The table stores one row per tab page property per language, holding the translated text displayed as a tab page label. It sits alongside its base-table counterpart, HR_TAB_PAGE_PROPERTIES_B, forming the standard Oracle EBS multilingual pattern in which the _B table holds language-independent attributes and the _TL table holds translated attributes. Under a Data Vault modeling heuristic derived from the foreign-key structure, this object is satellite-leaning: it depends on a parent key from HR_TAB_PAGE_PROPERTIES_B and carries descriptive, language-specific attributes rather than defining new hubs or links on its own.

Key Information Stored

The documented physical schema records ten columns. The most significant are:

• TAB_PAGE_PROPERTY_ID (NUMBER, 15) — System-generated surrogate primary key populated from the sequence HR_TAB_PAGE_PROPERTIES_TL_S; it is also the foreign key to HR_TAB_PAGE_PROPERTIES_B.
• LANGUAGE (VARCHAR2) — The language in which the row's translated text is expressed; mandatory and part of the composite primary key.
• SOURCE_LANG (VARCHAR2) — The language from which the translation was derived; indexed by HR_TAB_PAGE_PROPERTIES_TL_FK2.
• LABEL (VARCHAR2, 80) — The translated text rendered as the tab page label in configurable forms; this is the principal business payload of the table.
• Standard WHO columns — LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATED_BY, and CREATION_DATE, which provide audit and concurrency information.
• ZD_EDITION_NAME — The editioning column documented in the 12.2.2 schema, supporting Online Patching and edition-based redefinition.

Two unique indexes are documented: HR_TAB_PAGE_PROPERTIES_TL_PK on (TAB_PAGE_PROPERTY_ID, LANGUAGE) in the 12.1.1 ETRM extract, and the 12.2.2 physical schema records the same index including ZD_EDITION_NAME, making (TAB_PAGE_PROPERTY_ID, LANGUAGE, ZD_EDITION_NAME) the operative business-key candidate. Nonunique indexes HR_TAB_PAGE_PROPERTIES_TL_FK2 (SOURCE_LANG) and HR_TAB_PAGE_PROPERTIES_TL_FK3 (LANGUAGE) accelerate language-oriented lookups.

Common Use Cases and Queries

Typical uses include diagnosing why a tab label appears untranslated, auditing translation coverage against a base tab page property, and confirming seed content after an upgrade or patch. The canonical query retrieves tab page labels for a specific language:

SELECT TAB_PAGE_PROPERTY_ID, LANGUAGE, SOURCE_LANG, LABEL
FROM HR.HR_TAB_PAGE_PROPERTIES_TL
WHERE LANGUAGE = 'US';

To detect missing translations, developers compare the _B table to the _TL table by joining on TAB_PAGE_PROPERTY_ID and filtering for a target LANGUAGE. To verify the standard WHO audit trail or to reconcile a specific property identifier, the primary key columns are used in the WHERE clause. Reporting scenarios include generating translation inventories for localization projects and validating that every base tab page property has a corresponding label in each installed language.

Related Objects

• HR.HR_TAB_PAGE_PROPERTIES_B — The base table; the _TL row's TAB_PAGE_PROPERTY_ID references HR_TAB_PAGE_PROPERTIES_B.TAB_PAGE_PROPERTY_ID, so the base and translation tables are always joined on that column.
• HR_TAB_PAGE_PROPERTIES_TL_PK — The unique composite index on TAB_PAGE_PROPERTY_ID and LANGUAGE (with ZD_EDITION_NAME in 12.2.2), enforcing one row per property per language.
• HR_TAB_PAGE_PROPERTIES_TL_FK2 / FK3 — Nonunique indexes supporting SOURCE_LANG and LANGUAGE access paths.
• HR_TAB_PAGE_PROPERTIES_TL_S — The sequence that populates the surrogate key.
• APPS.HR_TAB_PAGE_PROPERTIES_TL and PUBLIC.HR_TAB_PAGE_PROPERTIES_TL — Synonyms through which the table is referenced by application code and ad-hoc queries.
• HR_TAB_PAGE_PROPERTI041420_WHO — A WHO audit trigger that references the table.

Together these objects implement the multilingual label layer for configurable form tab pages, and the table should be modified only through supported Oracle seed-data mechanisms to preserve edition and translation integrity.