Search Results fa_lookup_types_tl




Overview
Explore in AI Chat

Overview

FA_LOOKUP_TYPES_TL is the translated (Multi-Language Support) child table of the Oracle Assets QuickCode lookup repository in the OFA – Assets product. It stores the language-specific descriptive text for each QuickCode type defined in Oracle Assets, including the user-facing meaning and description presented on forms, reports, and concurrent program parameters. In Oracle E-Business Suite 12.1.1 and 12.2.2, this table is owned by the FA schema and resides in the Applications database tablespace group alongside the base FA_LOOKUP_TYPES_B table.

The object carries a documented status of VALID, with 11 physical columns in the 12.2.2 reference schema. Its structure follows the standard Oracle MLS (Multi-Lingual Support) pattern: a base table (FA_LOOKUP_TYPES_B) holding language-independent lookup attributes, and this _TL table holding the translatable MEANING and DESCRIPTION columns keyed by LANGUAGE. The heuristic Data Vault classification mined from the foreign-key structure is standalone, meaning the table participates in no enforced parent-child relationships at the physical level and therefore behaves as an isolated reference/translation entity rather than a hub, link, or satellite within a modeled Data Vault. This classification should be treated as a modeling suggestion; functionally, the table is a pure translation satellite of the base lookup type entity.

Key Information Stored

The table is keyed by the composite primary key FA_LOOKUP_TYPES_TL_PK on (LOOKUP_TYPE, LANGUAGE). A unique index, FA_LOOKUP_TYPES_TL_U1, extends this business key to include ZD_EDITION_NAME, supporting edition-based redefinition and online patching in 12.2.x environments.

  • LOOKUP_TYPE — the internal identifier (name) of the QuickCode type; the primary join column to the base FA_LOOKUP_TYPES_B table.
  • LANGUAGE — the NLS language code for the translated row (e.g., US, D, ZHS); part of the primary key.
  • SOURCE_LANG — the language from which the translated MEANING and DESCRIPTION were derived, supporting MLS translation propagation.
  • MEANING — the translated, language-specific label shown to end users for the lookup type; this is the principal business-facing attribute.
  • DESCRIPTION — the translated long description providing additional context for the QuickCode type.
  • LAST_UPDATE_DATE — the timestamp of the most recent modification, used for audit and incremental extraction.
  • LAST_UPDATED_BY — the user or concurrent program that last changed the row.
  • CREATED_BY — the user or process that inserted the row.
  • CREATION_DATE — insertion timestamp.
  • LAST_UPDATE_LOGIN — the login identifier associated with the last update, supporting session-level auditing.
  • ZD_EDITION_NAME — the edition component used by Online Patching in EBS 12.2.2; in 12.1.1 this column is absent or set to a default.

Common Use Cases and Queries

The table is queried whenever Oracle Assets displays QuickCode terminology to a user in a specific language, and it is frequently joined against the base table to collect complete lookup metadata. A typical reporting pattern retrieves the user-facing label for a given lookup type in the session language with the standard MLS decode:

  • Retrieve translated meanings: SELECT lookup_type, meaning, description FROM fa_lookup_types_tl WHERE language = USERENV('LANG');
  • Join base to translation: SELECT b.lookup_type, b.enabled_flag, t.meaning FROM fa_lookup_types_b b, fa_lookup_types_tl t WHERE b.lookup_type = t.lookup_type AND t.language = USERENV('LANG');
  • Audit recently changed translations: SELECT lookup_type, language, meaning, last_update_date, last_updated_by FROM fa_lookup_types_tl WHERE last_update_date > SYSDATE - 7;
  • Identify missing translations: compare the set of LOOKUP_TYPE values in FA_LOOKUP_TYPES_B against those present for a target LANGUAGE in this table.

Common reporting scenarios include listing all QuickCode types for a language, validating MLS completeness before upgrade or patching, and exporting lookup labels for reconciliation with interface tables.

Related Objects

  • FA_LOOKUP_TYPES_B — the base table holding language-independent lookup attributes; join on LOOKUP_TYPE.
  • FA_LOOKUP_TYPES — the MLS view unioning base and translation rows for application-level queries.
  • FA_LOOKUP_TYPES_VL — the standard translated view exposing MEANING and DESCRIPTION based on session language.
  • FA_LOOKUPS and FA_LOOKUPS_TL — the QuickCode value tables that depend on lookup type definitions.
  • FND_LOOKUP_TYPES_TL / FND_LOOKUPS_TL — the general Oracle Application Object Library lookup tables, which follow the same MLS design and may be referenced for comparative reporting.

As a standalone reference table, FA_LOOKUP_TYPES_TL has no enforced foreign keys; its relationships are maintained logically through LOOKUP_TYPE against the base table and its MLS views.