Search Results okl_formulae_tl




Overview
Explore in AI Chat

Overview

OKL_FORMULAE_TL is the translation table for OKL_FORMULAE_B within the OKL (Lease and Finance Management) product in Oracle E-Business Suite 12.1.1 and 12.2.2. It stores the multi-language (MLS) values for the descriptive attributes of lease and finance formulae, allowing formula descriptions to be presented in the user's session language. The table resides in the OKL schema and carries a VALID status in the ETRM repository. Its structure conforms to Oracle's standard MLS translation-table convention, where translatable columns are extracted from a base table and joined by a surrogate identifier plus the LANGUAGE code.

The heuristic Data Vault classification mined from the FK structure is standalone. In modeling terms, this suggests the object is best treated as a satellite-style descriptive table rather than a hub or link: it holds attribute context (translated description text) that is dependent on the parent base entity, without introducing independent business relationships of its own.

Key Information Stored

The table contains 11 documented columns. The most significant are:

  • ID — Surrogate identifier shared with the base table OKL_FORMULAE_B, forming the first component of the composite primary key OKL_FORMULAE_TL_PK.
  • LANGUAGE — The MLS language code (for example, US) identifying which translation is stored; second component of the primary key.
  • SOURCE_LANG — The language of the originating (source) record, used to indicate the base translation.
  • SFWT_FLAG — The standard MLS "translation" flag column used by the seed/merge copy utilities to track whether the row has been frozen for translation (values typically Y/N).
  • DESCRIPTION — The translatable descriptive text for the formula.
  • ZD_EDITION_NAME — Edition identifier supporting Oracle's Edition-Based Redefinition (EBR); it participates in the unique index OKL_FORMULAE_TL_U1.
  • CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard "WHO" audit columns capturing row creation and modification metadata.

The surrogate primary key is ID, LANGUAGE (OKL_FORMULAE_TL_PK). The business-key candidate is defined by the unique index OKL_FORMULAE_TL_U1 over ID, LANGUAGE, ZD_EDITION_NAME, which additionally disambiguates rows across editions. There are no foreign-key constraints captured in the metadata; row integrity is maintained through the shared ID with the base table and MLS conventions.

Common Use Cases and Queries

Typical reporting and troubleshooting scenarios include verifying that a formula has a translation in every required language, extracting localized descriptions for end-user reporting, and auditing MLS coverage. A common join pattern retrieves the base formula with its translated description:

  • SELECT b.id, b.formula_name, t.language, t.description FROM okl.okl_formulae_b b, okl.okl_formulae_tl t WHERE b.id = t.id AND t.language = USERENV('LANG');
  • Detecting missing translations by comparing required languages against rows present for a given ID.
  • Auditing last-updated timestamps and the SFWT_FLAG to monitor translation workflow.
  • Edition-scoped queries filtering on ZD_EDITION_NAME when EBR is enabled.

Related Objects

  • OKL_FORMULAE_B — Base table holding the formula definition; joined on ID.
  • OKL_FORMULAE_TL_PK — Primary key constraint (ID, LANGUAGE).
  • OKL_FORMULAE_TL_U1 — Unique index supporting the business key (ID, LANGUAGE, ZD_EDITION_NAME).
  • FND_LANGUAGES — Reference table supplying valid LANGUAGE codes.
  • Lease and Finance Management formulae setup APIs / concurrent programs — Populate and maintain formula master data and its translations.
  • MLS translation utilities (FND_MLS / XLA-style seed utilities) — Maintain SFWT_FLAG and SOURCE_LANG.