Search Results edr_fwk_test_tl




Overview
Explore in AI Chat

Overview

EDR_FWK_TEST_TL is a translation (TL) table in the EDR — E-Records product module of Oracle E-Business Suite 12.1.1 and 12.2.2. Its documented purpose is to store translated values of ERES Framework Test data, allowing the descriptive attributes of an ERES framework test definition to be presented in multiple installed languages. The table is owned by the EDR schema and is reported with a status of VALID.

The table follows the standard Oracle Applications multilingual design pattern: a base table (EDR_FWK_TEST_B) holds the language-independent definition, while this _TL table holds the language-dependent descriptive text. Each row is qualified by a language code, so a single framework test can have one translated record per installed language.

Under the heuristic Data Vault classification mined from the foreign key structure, this object is classified as standalone. In Data Vault modeling terms, this suggests it is best treated as a standalone structure rather than as a conventional hub, link, or satellite. In practice, the foreign key to EDR_FWK_TEST_B indicates that EDR_FWK_TEST_TL functions as a language-dependent descriptive or reference structure attached to the base framework test entity.

Key Information Stored

The documented physical schema for ETRM 12.2.2 shows nine columns in the EDR schema. The most important are:

  • FWK_TEST_ID — The framework test identifier. This is the primary key column and also the foreign key to EDR_FWK_TEST_B.FWK_TEST_ID, linking each translation row to its base framework test definition.
  • LANGUAGE — The language code identifying the translation. Together with FWK_TEST_ID, it forms the unique index EDR_FWK_TEST_TL_PK (FWK_TEST_ID, LANGUAGE), which serves as the primary-key definition (business-key candidate) for this table.
  • FWK_TEST_DESCRIPTION — The translated description of the framework test. This is the primary language-dependent descriptive attribute held in the table.
  • SOURCE_LANG — The source language from which the translation was derived or seeded, a standard column in Oracle Applications translation tables.
  • CREATED_BY, CREATION_DATE — Standard audit columns recording the user and timestamp of row creation.
  • LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — Standard audit columns recording the most recent change to the translation row, including the user and login session.

The surrogate primary key for the table is the composite of FWK_TEST_ID and LANGUAGE, defined by the unique index EDR_FWK_TEST_TL_PK. The FWK_TEST_ID column alone is a foreign-key reference to the base table, not a standalone primary key.

Common Use Cases and Queries

Typical use of this table is multilingual reporting and configuration verification of ERES framework tests. A common query joins the translation table to its base table to return the test definition with its translated description in a specific language:

  • Join to base: SELECT b.fwk_test_id, t.fwk_test_description FROM edr.edr_fwk_test_b b, edr.edr_fwk_test_tl t WHERE b.fwk_test_id = t.fwk_test_id AND t.language = USERENV('LANG');
  • Language availability check: SELECT fwk_test_id, language FROM edr.edr_fwk_test_tl WHERE fwk_test_id = :test_id ORDER BY language;
  • Duplicate/diagnostic inspection: SELECT fwk_test_id, COUNT(*) FROM edr.edr_fwk_test_tl GROUP BY fwk_test_id HAVING COUNT(*) > 1;
  • Audit review: SELECT fwk_test_id, language, last_updated_by, last_update_date FROM edr.edr_fwk_test_tl ORDER BY last_update_date DESC;

These patterns support localization administration, verification that translations exist for all required languages, and auditing of recent changes to translated test descriptions.

Related Objects

The primary and documented relationship is the foreign key from EDR_FWK_TEST_TL.FWK_TEST_ID to EDR_FWK_TEST_B.FWK_TEST_ID. The base table EDR_FWK_TEST_B holds the language-independent framework test definition and is the principal counterpart to this translation table. Relevant related objects include:

  • EDR_FWK_TEST_B — Base table for the ERES Framework Test definition; joined on FWK_TEST_ID.
  • EDR_FWK_TEST_TL_PK — The unique index on (FWK_TEST_ID, LANGUAGE) that defines the primary key and enforces one translation row per test per language.
  • Additional EDR framework objects in the EDR — E-Records module that reference framework test definitions, which typically join through EDR_FWK_TEST_B rather than directly to this translation table.

Because the metadata classifies this table as standalone with a single documented foreign key, join paths to other EDR objects are generally reached indirectly via EDR_FWK_TEST_B.