Results for “dt_date_prompts_tl”

50+ results




Overview
Explore in AI Chat

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

Overview

DT_DATE_PROMPTS_TL is a translation table owned by the HR schema within the DateTrack (DT) product module of Oracle E-Business Suite. DateTrack is the effective-dating framework that underpins record versioning across Oracle HRMS and related applications, allowing a single logical row to be tracked across dated versions of its attributes. The table stores the default prompts displayed in DateTrack History views for the effective start date and effective end date columns. Because these prompts appear as user-facing labels, they are translatable, and the "_TL" suffix denotes a translation-enabled table whose language rows are keyed by LANGUAGE.

Under the heuristic Data Vault classification mined from the foreign key structure, the object is identified as standalone, meaning that no parent or child relationships were detected within the documented FK graph. In Data Vault modeling terms, this suggests the table functions more like a reference or lookup construct with a composite natural key driven by language and edition, rather than a transactional hub or link. It holds descriptive metadata used to render the DateTrack user interface consistently across supported languages.

Key Information Stored

The documented physical schema contains 10 columns. The most significant are summarized below.

  • LANGUAGE — The language identifier for the translated prompt text, forming part of the primary key DT_DATE_PROMPTS_TL_PK.
  • SOURCE_LANG — The language from which the current translation was derived, used by the translation framework to track lineage of the prompt text.
  • EFFECTIVE_START_PROMPT — The localized prompt text displayed for the effective start date column in DateTrack History views.
  • EFFECTIVE_END_PROMPT — The localized prompt text displayed for the effective end date column in DateTrack History views.
  • ZD_EDITION_NAME — The edition identifier used by the Oracle EBS editioning and online patching infrastructure, introduced in 12.2.x releases.
  • LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATED_BY, CREATION_DATE — Standard WHO audit columns recording who created and last modified each translation row and when.

The primary key DT_DATE_PROMPTS_TL_PK is documented on LANGUAGE alone in the ETRM excerpt, while the unique index list refines the business-key candidate to the composite (LANGUAGE, ZD_EDITION_NAME). This pairing distinguishes the surrogate-style key from the natural translation key that includes the edition context. The audit columns do not participate in the key but are mandatory for tracking changes to prompt text.

Common Use Cases and Queries

Typical usage centers on retrieving the correct localized prompt labels for DateTrack History views. A reporting or diagnostic query might select the prompt columns filtered by the session language:

  • Prompt lookup for a specific language: SELECT language, effective_start_prompt, effective_end_prompt FROM hr.dt_date_prompts_tl WHERE language = USERENV('LANG');
  • Audit of recent translation changes: filter on LAST_UPDATE_DATE to identify prompts edited after a patch or localization effort.
  • Edition-aware retrieval in 12.2.x: constrain on ZD_EDITION_NAME when validating that the correct edition's translation row is being read during online patching cycles.
  • Completeness checks: compare the set of LANGUAGE values against installed languages to detect missing translations that would leave prompts untranslated.

Because the table is small and reference-oriented, it is rarely joined in high-volume reporting; instead it is read during UI rendering and localization validation.

Related Objects

The documented FK metadata classifies this object as standalone, so no enforced parent-child joins were mined. The most relevant associated objects are the DateTrack History views and the translation framework that consume these prompt values.

  • DT_DATE_PROMPTS (base table) — the non-translated counterpart whose language-independent definitions are extended by the _TL rows.
  • DT_DATE_PROMPTS_TL_PK — the primary key index over LANGUAGE, referenced for uniqueness enforcement.
  • DateTrack History views — the runtime views that render the EFFECTIVE_START_PROMPT and EFFECTIVE_END_PROMPT labels.
  • FND_LANGUAGES — the language registry that governs valid LANGUAGE values and their installed status.
  • FND_TERRITORIES — used in conjunction with language to resolve localization context.

These objects collectively define, localize, and display the DateTrack date prompts across the EBS instance.