Search Results okl_fe_eo_terms_all_tl




Overview
Explore in AI Chat

Overview

OKL_FE_EO_TERMS_ALL_TL is the End-of-Term Value (EOT) header translations table within the Oracle E-Business Suite Leasing and Finance Management (OKL) module. It is a multi-language (TL) table that stores the translated, language-dependent descriptive attributes of end-of-term value header records. In Oracle EBS, "end-of-term" refers to the residual value or balloon terms negotiated on a lease or loan contract that determine the disposition or settlement of the asset at contract maturity. The base, language-independent transactional data resides in a sibling base table (typically OKL_FE_EO_TERMS_ALL_B), while this _TL table holds the user-facing translated description keyed by both the end-of-term identifier and the language code.

This table is classified with status VALID in the OKL schema and comprises ten documented columns, with the primary key OKL_FE_EO_TERMS_ALL_TL_PK defined on the composite of END_OF_TERM_ID and LANGUAGE. Per the heuristic Data Vault classification mined from its foreign-key structure, this object is modeled as a standalone satellite. This reflects that it is a descriptive, attribute-bearing table whose grain is one row per end-of-term entity per language, rather than a hub (which would hold a single natural-key list) or a link (which would resolve many-to-many relationships). The satellite interpretation appropriately captures the multilingually-versioned descriptive payload attached to the EOT business key.

Key Information Stored

The table's surrogate and composite primary key is formed by END_OF_TERM_ID (the business identifier of the end-of-term header) together with LANGUAGE (the Oracle language code, such as US, DE, FR). These two columns also constitute the unique index OKL_FE_EO_TERMS_ALL_TL_U1, reinforcing them as the business-key candidate that guarantees one translated row per end-of-term per language.

The principal descriptive payload is END_OF_TERM_DESC, which holds the translated description of the end-of-term value record as presented to users in the selected language. The column SOURCE_LANG records the source language from which a translation was seeded or derived, supporting Oracle's translation propagation model, while the SFWT_FLAG (simplified multilingual support flag) follows the standard EBS _TL design pattern for tracking translation currency. Standard EBS auditing and concurrency columns are present and significant: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, and LAST_UPDATE_LOGIN allow tracking of who inserted or last modified each translated row and when. Note that the table does not itself store the numeric residual or balloon amounts, which belong to the base EOT table; this _TL object is exclusively the descriptive-translation store.

Common Use Cases and Queries

Typical usage centers on retrieving the language-appropriate description of end-of-term terms for contracts, reports, and user interfaces. A standard lookup joins the base table to this translations table or filters directly by language:

  • Resolve a description for a given end-of-term: SELECT end_of_term_desc FROM okl_fe_eo_terms_all_tl WHERE end_of_term_id = :id AND language = USERENV('LANG');
  • Audit recently modified translations: SELECT end_of_term_id, language, last_updated_by, last_update_date FROM okl_fe_eo_terms_all_tl WHERE last_update_date > SYSDATE - 30;
  • Multilingual reporting against all installed languages by grouping on LANGUAGE.
  • Data-quality checks for missing or stale translations by comparing SOURCE_LANG and SFWT_FLAG values.

Because the table is narrow and keyed by (END_OF_TERM_ID, LANGUAGE), most queries are point lookups or small set-based retrievals, making it efficient for form-driven and report-driven use.

Related Objects

As a translations (_TL) table, its most significant relationships are with the base EOT header table and its translated siblings:

  • OKL_FE_EO_TERMS_ALL_B — base table sharing END_OF_TERM_ID; the master record this _TL row describes.
  • OKL_FE_EO_TERMS_ALL_VL — the multilingual view typically defined over _B and _TL for language-aware querying.
  • OKL_FE_EO_TERMS_ALL_TL_PK / _U1 — the primary key and unique constraints enforcing one row per (END_OF_TERM_ID, LANGUAGE).
  • OKL_EO_TERMS / EOT line-level tables — child entities that reference the EOT header via END_OF_TERM_ID.
  • FND_LANGUAGES — the EBS language definition table validating the LANGUAGE column.
  • OKL_FE_EO_TERMS core EOT APIs and concurrent programs that populate and maintain translated descriptions.

These objects collectively provide the end-of-term value definition, translation, and retrieval path within Oracle Leasing and Finance Management.