Results for “okl_strm_type_tl”

50+ results




Overview
Explore in AI Chat

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

OKL_STRM_TYPE_TL is the translation (multi-language support, or MLS) table that accompanies OKL_STRM_TYPE_B within the Oracle E-Business Suite Leasing and Finance Management module (OKL). The suffix convention is standard throughout Oracle EBS: the "_B" table stores the base, language-independent rows, while the "_TL" table stores the translatable descriptive columns — in this case the NAME, DESCRIPTION, and SHORT_DESCRIPTION attributes of a lease stream type. The table is owned by the OKL schema and carries a VALID status in the ETRM 12.2.2 dictionary. Every stream type definition therefore has at least one row in OKL_STRM_TYPE_TL for each installed language (for example US English, ZD_EDITION-enabled rows aside, and any additional languages configured in the instance).

From a Data Vault modelling perspective, the mined metadata classifies this object as standalone — it has no foreign-key relationships pointing to other tables in the documented relationship set. A Data Vault practitioner would typically model this as a satellite on the base OKL_STRM_TYPE_B hub, with the language code acting as a secondary descriptive key rather than as a true link. This classification is a heuristic suggestion; the object is physically a child translation table, not an independent business entity.

Key Information Stored

The table contains 13 documented columns. The most operationally significant are:

  • ID — surrogate identifier that ties the translation row back to the corresponding base record in OKL_STRM_TYPE_B. It is the first component of both the primary key and the unique index.
  • LANGUAGE — the MLS language code (for example "US" for US English). Combined with ID, this forms the primary key OKL_STRM_TYPE_TL_PK, ensuring exactly one translation per stream type per language.
  • NAME — the language-specific, user-visible stream type name displayed in leasing setup screens.
  • DESCRIPTION — the longer translatable narrative describing the stream type's purpose or calculation basis.
  • SHORT_DESCRIPTION — an abbreviated label used where screen real estate is constrained, such as list-of-values or report headings.
  • SOURCE_LANG — indicates the language in which the source name value was originally entered, supporting Oracle's MLS update semantics.
  • SFWT_FLAG — the "Seed/First/Whatever/Translate" style flag that Oracle uses to determine whether a row still follows the source language or has been independently translated.
  • ZD_EDITION_NAME — the editioning column introduced for online patching in EBS 12.2. It appears in the unique index OKL_STRM_TYPE_TL_U1 (ID, LANGUAGE, ZD_EDITION_NAME), which is the documented business-key candidate.
  • CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — the standard Oracle WHO columns recording audit provenance for every inserted or changed translation row.

Distinguishing the surrogate primary key from the business key is important: ID plus LANGUAGE identifies a row technically, but (ID, LANGUAGE, ZD_EDITION_NAME) is the combination Oracle treats as the unique business key for editioning purposes.

Common Use Cases and Queries

The table is rarely queried in isolation; it is almost always joined to OKL_STRM_TYPE_B on ID. Typical scenarios include validating that all stream types have a translation in the user's session language, generating bilingual setup reports, and troubleshooting "name not displayed" issues caused by a missing or flagged translation row.

A representative query joins the base and translation tables and filters by language:

  • SELECT b.id, t.name, t.description, t.short_description
  • FROM okl_strm_type_b b, okl_strm_type_tl t
  • WHERE b.id = t.id AND t.language = USERENV('LANG')
  • ORDER BY t.name;

For reporting, the table feeds lease stream setup extracts and reference-data listings. For data migration, it is loaded after the base table, with LANGUAGE defaulted to the target instance's base language. DBAs also query it during patching to confirm that ZD_EDITION_NAME values align across editioning views.

Related Objects

  • OKL_STRM_TYPE_B — the base table holding language-independent stream type rows; joined on ID. Its translations are exactly what this table supplies.
  • OKL_STRM_TYPE_VL — the MLS view that combines the base and translation tables into a single language-aware row, the object most forms and concurrent programs actually query.
  • OKL_STRM_TYPE_TL_PK — the primary-key constraint on (ID, LANGUAGE) enforcing one translation per language.
  • OKL_STRM_TYPE_TL_U1 — the unique index on (ID, LANGUAGE, ZD_EDITION_NAME) and the documented business-key candidate.
  • FND_LANGUAGES — the language-code reference table underlying the LANGUAGE and SOURCE_LANG values.
  • OKL_STRM_TYPE_B_WHO-style trigger logic or the standard WHO columns — audit columns shared with the base table.

Because the relationship data classifies this object as standalone, no foreign keys link it to unrelated OKL entities; dependencies flow through the ID relationship with the base stream type table and the corresponding VL view.