Search Results fnd_oam_mets_tl




Overview
Explore in AI Chat

Overview

FND_OAM_METS_TL is the translated (language-specific) table that stores the display text for Oracle Application Manager (OAM) Dashboard metrics within the Oracle E-Business Suite. It resides in the APPLSYS schema and is owned by the FND – Application Object Library product. The table holds the user-facing labels and descriptions that accompany each metric defined in the base OAM metrics repository, enabling the OAM Dashboard to present metric names and explanatory text in the session language of the user. It is the multilingual companion to the base (non-translated) OAM metrics definition table, and its rows are keyed by metric identifier and language.

From a heuristic Data Vault modeling perspective (mined from the documented foreign key and unique index structure), this object is classified as standalone. Because the metadata does not expose an inbound foreign key relationship to a parent metric definition table within the ETRM extraction, it is best treated as an independent reference or description satellite rather than a true hub or link. This classification is a modeling suggestion only; the physical table functions as a language-dependent descriptive store for OAM metric text.

Key Information Stored

The table contains 11 documented columns. The most significant are summarized below.

  • METRIC_SHORT_NAME – The stable, language-independent identifier of the metric. This is part of both the primary key (FND_OAM_METS_TL_PK1) and the unique business key (FND_OAM_METS_TL_U1).
  • LANGUAGE – The NLS language code indicating which translation this row provides. Also part of the primary key and unique business key.
  • METRIC_DISPLAY_NAME – The translated, human-readable label shown for the metric on the OAM Dashboard.
  • DESCRIPTION – The translated explanatory text for the metric, used in tooltips and help regions of the dashboard.
  • SOURCE_LANG – The source language from which the translation was derived, indicating the language of the originating text.
  • ZD_EDITION_NAME – The editioning column used by Oracle EBS online patching (Edition-Based Redefinition). It is part of the unique business key FND_OAM_METS_TL_U1.
  • CREATED_BY, CREATION_DATE – Standard WHO audit columns capturing the creating user and timestamp.
  • LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN – Standard WHO audit columns capturing the most recent update user, timestamp, and login session.

The surrogate primary key is FND_OAM_METS_TL_PK1, defined on the composite of METRIC_SHORT_NAME and LANGUAGE. The documented unique business-key candidate, FND_OAM_METS_TL_U1, is defined on METRIC_SHORT_NAME, LANGUAGE, and ZD_EDITION_NAME. The presence of ZD_EDITION_NAME in the unique index reflects the edition-aware design of the 12.2.x data model.

Common Use Cases and Queries

Typical uses involve reporting on OAM Dashboard metric labels and descriptions, verifying translation coverage across languages, and auditing metric text changes. A simple query to retrieve the display text for a metric in the current language:

  • SELECT METRIC_DISPLAY_NAME, DESCRIPTION FROM FND_OAM_METS_TL WHERE METRIC_SHORT_NAME = :metric AND LANGUAGE = USERENV('LANG');

A coverage query comparing available translations against expected languages:

  • SELECT METRIC_SHORT_NAME, LANGUAGE FROM FND_OAM_METS_TL ORDER BY METRIC_SHORT_NAME, LANGUAGE;

An audit query examining recently updated translations:

  • SELECT METRIC_SHORT_NAME, LANGUAGE, LAST_UPDATED_BY, LAST_UPDATE_DATE FROM FND_OAM_METS_TL WHERE LAST_UPDATE_DATE > SYSDATE - 30;

These patterns support localization reviews, dashboard label maintenance, and change-tracking reports.

Related Objects

The ETRM metadata characterizes this table as standalone, with no documented foreign keys referencing other objects. In practice it is consumed alongside the base OAM metrics definition table that supplies the non-translated metric identity matched on METRIC_SHORT_NAME, and it is read by the OAM Dashboard (Application Manager) presentation layer. Because ZD_EDITION_NAME participates in the unique index, the table is also closely associated with the editioning infrastructure that governs online patching in EBS 12.2.x. Administrators and developers most commonly join FND_OAM_METS_TL to the base metrics table on METRIC_SHORT_NAME and filter on LANGUAGE to obtain correctly localized dashboard text.