Results for “frm_directory_tl”

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

Overview

FRM_DIRECTORY_TL is the translatable (language-dependent) table that stores the display names and descriptions for the Report Manager directory structure in Oracle EBS. It belongs to the FRM product/module (Report Manager), is owned by the FRM schema, and is marked VALID in both Oracle EBS 12.1.1 and 12.2.2. In a multilingual EBS instance, the base table FRM_DIRECTORY_B holds language-independent attributes for each directory node, while FRM_DIRECTORY_TL holds the translated text (directory name, description) keyed by language. When the Reports Manager or a user navigates the report directory tree, the text shown is sourced from this TL table for the session language.

From a Data Vault modeling perspective, the FK structure suggests a satellite-leaning classification: FRM_DIRECTORY_TL references FRM_DIRECTORY_B via DIRECTORY_ID, making it a dependent, descriptive table that carries the translatable attributes of the directory hub. This is a heuristic suggestion mined from the FK relationship, not a native Data Vault designation.

Key Information Stored

The documented physical schema for the FRM schema in 12.2.2 contains 12 columns. The most significant are the following:

• DIRECTORY_ID — surrogate/foreign key linking each translated row to its parent record in FRM_DIRECTORY_B.
• LANGUAGE — the NLS language code identifying which translated version of the directory text this row represents.
• SOURCE_LANG — the source language from which the translation was derived; used during the translation/MLS process.
• USER_NAME — the translatable user-facing name of the directory node; this is the primary business attribute exposed in the Report Manager UI.
• CREATION_DATE, CREATED_BY — standard audit columns recording when and by whom the translated row was created.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — standard audit columns for the most recent modification.
• END_DATE — effective end date, supporting date-tracked or MLs-style history on the translation row.
• ARCHIVED_FLAG — indicates whether the translated directory entry has been archived.
• ZD_EDITION_NAME — the edition identifier supporting EBS online patching (Edition-Based Redefinition, EBR) in 12.2.x.

The primary key is FRM_DIRECTORY_TL_PK on (DIRECTORY_ID, LANGUAGE). A unique business-key candidate is documented as FRM_DIRECTORY_TL_UK1 on (DIRECTORY_ID, LANGUAGE, ZD_EDITION_NAME), which accounts for editioning in 12.2.2.

Common Use Cases and Queries

Typical scenarios involve listing or resolving directory names in a specific language, joining the base and translation tables, or auditing translation coverage across languages.

• Retrieve the translated directory name for a language: SELECT DIRECTORY_ID, USER_NAME FROM FRM_DIRECTORY_TL WHERE LANGUAGE = USERENV('LANG') AND (END_DATE IS NULL OR END_DATE > SYSDATE);
• Join base and translation for full directory metadata: SELECT b.DIRECTORY_ID, t.USER_NAME, t.LANGUAGE FROM FRM_DIRECTORY_B b, FRM_DIRECTORY_TL t WHERE b.DIRECTORY_ID = t.DIRECTORY_ID;
• Detect directories missing translations for a given language (coverage report).
• In 12.2.x, filter or group by ZD_EDITION_NAME to isolate the active edition during online patching.
• Audit recently modified translations using LAST_UPDATE_DATE and LAST_UPDATED_BY.

Related Objects

• FRM_DIRECTORY_B — the base (language-independent) directory table; joined on FRM_DIRECTORY_TL.DIRECTORY_ID = FRM_DIRECTORY_B.DIRECTORY_ID. This is the documented FK.
• FRM_DIRECTORY_TL_PK / FRM_DIRECTORY_TL_UK1 — the primary key and unique business-key indexes enforcing uniqueness on the translation rows.
• Other FRM Report Manager tables (e.g., FRM documents/reports referencing directory nodes) depend indirectly on FRM_DIRECTORY_B, and therefore on the translated names exposed through this table.
• MLS/NLS translation utilities and the EBS Translation (XDK) infrastructure read and write SOURCE_LANG/LANGUAGE values in this table.