Search Results okl_fees_tl




Overview
Explore in AI Chat

Overview

OKL_FEES_TL is the translation table for the Oracle Leasing and Finance Management (OKL) fee definition entity in Oracle E-Business Suite 12.1.1 and 12.2.2. It holds the language-dependent, translatable attributes of fee records whose language-neutral attributes are stored in OKL_FEES_B. The "_TL" suffix denotes a standard EBS multilingual translation pattern: a base table ("_B") carries language-independent columns, while the translation table ("_TL") carries descriptive text resolved by LANGUAGE and SOURCE_LANG. The object is owned by the OKL schema and is documented as VALID in the ETRM repository.

The mined Data Vault classification for this object is standalone. Under a Data Vault modeling suggestion, OKL_FEES_TL is best treated as a satellite attached to the OKL_FEES_B hub, since its rows are descriptive, language-qualified attributes keyed to a parent fee identifier rather than independent business entities or many-to-many relationships. The absence of outbound foreign keys in the mined relationship data reinforces that this is a dependent descriptive structure rather than a hub or link.

Key Information Stored

The table documents 12 columns. The most significant are:

  • ID — The surrogate identifier of the parent fee record; participates in the composite primary key and is a candidate business key.
  • LANGUAGE — The language code for the translated row; the second component of the primary key.
  • SOURCE_LANG — The language of the source row from which the translation was derived, used by the EBS translation framework.
  • SFWT_FLAG — The standard "seed/framework translation" indicator used by the multilanguage tooling to distinguish shipped versus user-maintained translations.
  • SHORT_DESCRIPTION — The short translatable name of the fee.
  • DESCRIPTION — The full translatable fee description.
  • COMMENTS — Free-form translatable commentary.
  • CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — The standard EBS WHO columns capturing audit and concurrency information; LAST_UPDATE_LOGIN records the login that last touched the row.

The documented primary key is OKL_FEET_PK (ID, LANGUAGE). A unique index, OKL_FEET_UC1 (ID, LANGUAGE), mirrors the primary key and serves as the business-key candidate, guaranteeing one translation row per fee per language. The surrogate identifier ID is therefore the join key back to OKL_FEES_B, not a standalone business key.

Common Use Cases and Queries

Translation tables are queried whenever multilingual fee labels must be presented or reconciled. A typical pattern joins the translation to the base table filtered by the session language:

  • Language-specific fee lookup — SELECT b.id, t.short_description, t.description FROM okl_fees_b b, okl_fees_tl t WHERE b.id = t.id AND t.language = USERENV('LANG').
  • Missing-translation detection — Identify base rows lacking a translation for a target language by comparing against fnd_languages.
  • Audit and reconciliation — Compare CREATION_DATE and LAST_UPDATE_DATE between OKL_FEES_B and OKL_FEES_TL to detect out-of-sync descriptive data.
  • Reporting — Extract translated fee descriptions for contract and billing reports, always constrained by LANGUAGE to avoid duplicate rows.

Related Objects

The following objects are most significant in relation to OKL_FEES_TL:

  • OKL_FEES_B — The base fee table; joined on ID to supply language-neutral attributes.
  • OKL_FEES_V — The translatable view that resolves the current session language across the base and translation tables.
  • OKL_FEES — The user-facing synonym that survives upgrades and points to the appropriate table or view.
  • FND_LANGUAGES — The language registry joined on LANGUAGE to validate installed languages.
  • OKL_FEES_TL_S — The sequence used to generate new surrogate ID values for fee rows.

These relationships rely on OKL_FEES_TL being a dependent, language-keyed satellite of OKL_FEES_B.