Search Results frm_documents_tl




Overview
Explore in AI Chat

Overview

FRM_DOCUMENTS_TL is the translation table for Report Manager documents in Oracle E-Business Suite, owned by the FRM schema. In Oracle EBS 12.1.1 and 12.2.2, Report Manager (formerly Application Report Manager, or ARM) provides the repository that stores report output, log files, and publication definitions. The base table FRM_DOCUMENTS_B holds language-independent document attributes, while FRM_DOCUMENTS_TL holds the language-dependent descriptive portions of each document, one row per installed language. The "_TL" suffix follows Oracle's standard MLS (Multi-Lingual Support) convention, and the presence of a SOURCE_LANG column allows Report Manager to preserve the language in which a document was originally defined.

From a Data Vault modeling perspective, the FK structure suggests this object is satellite-leaning. Its only outbound foreign key points to FRM_DOCUMENTS_B on DOCUMENT_ID, which implies that FRM_DOCUMENTS_TL behaves as a descriptive satellite hanging off the FRM_DOCUMENTS_B hub, with LANGUAGE completing the natural key. This classification is a heuristic inference from the documented referential constraints and should be treated as a modeling suggestion rather than a declared property of the EBS schema.

Key Information Stored

The table contains 11 documented columns. The columns of greatest significance are:

  • DOCUMENT_ID — Surrogate identifier inherited from the parent document; part of the composite primary key.
  • LANGUAGE — The language code of the translated row; the second component of the primary key.
  • SOURCE_LANG — The language in which the document was originally authored or defined, used by MLS to determine whether a translation or the base row should be returned.
  • USER_NAME — The application user associated with the row, typically the creator or last modifier at the reporting level.
  • CREATION_DATE, CREATED_BY — Standard audit columns recording row creation.
  • LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — Standard audit columns recording the most recent change.
  • END_DATE — Effective end date, supporting date-tracked multilingual text as used in several EBS MLS implementations.
  • ARCHIVED_FLAG — Indicates whether the translation row has been archived, supporting Report Manager's cleanup and purge processes.

The primary key is FRM_DOCUMENTS_TL_PK on (DOCUMENT_ID, LANGUAGE). A unique index, FRM_DOCUMENTS_TL_UK1, is also documented on the same column pair, making (DOCUMENT_ID, LANGUAGE) the business-key candidate for this table. The surrogate key proper is DOCUMENT_ID, but it is not unique within this table because it repeats across languages.

Common Use Cases and Queries

Typical uses center on resolving the display name or descriptive text of a Report Manager document in the user's session language, and on auditing which documents exist in which languages. A common query joins the translation table to the base table and filters on LANGUAGE:

  • Retrieve all translations for a document: SELECT t.LANGUAGE, t.SOURCE_LANG, t.END_DATE FROM FRM_DOCUMENTS_TL t WHERE t.DOCUMENT_ID = :doc_id;
  • Find documents lacking a translation for a given language by comparing FRM_DOCUMENTS_B to FRM_DOCUMENTS_TL on DOCUMENT_ID and LANGUAGE.
  • Identify archived or end-dated translations for purge planning using END_DATE and ARCHIVED_FLAG.
  • Audit recent changes to translated content via LAST_UPDATE_DATE and LAST_UPDATED_BY.

Reporting scenarios include multilingual document inventories, translation-coverage dashboards, and audit extracts of Report Manager metadata. Because the table is narrow and keyed on DOCUMENT_ID, queries should always constrain on that column to avoid full scans.

Related Objects

The following objects are most significant to FRM_DOCUMENTS_TL:

  • FRM_DOCUMENTS_B — The parent base table; join on FRM_DOCUMENTS_TL.DOCUMENT_ID = FRM_DOCUMENTS_B.DOCUMENT_ID. This is the only documented foreign key relationship.
  • FRM_DOCUMENTS_TL_PK — Primary key constraint enforcing uniqueness of (DOCUMENT_ID, LANGUAGE).
  • FRM_DOCUMENTS_TL_UK1 — Unique index on (DOCUMENT_ID, LANGUAGE), the business-key candidate.
  • FRM_DOCUMENTS_TL view or synonym layers exposed through the Report Manager concurrent program and OAM/FRM APIs, which surface translated document attributes to end users.
  • Other FRM tables keyed on DOCUMENT_ID, such as those storing document output and publication metadata, which indirectly depend on the translated rows for display purposes.

Because only one foreign key is documented, additional relationships to Report Manager runtime objects should be validated against the deployed 12.1.1 or 12.2.2 instance before being relied upon.