Search Results okl_data_src_fnctns_tl_u2

Overview

OKL.OKL_DATA_SRC_FNCTNS_TL is the translation (TL) table for the Oracle Lease Management (OKL) data source functions base table, OKL_DATA_SRC_FNCTNS_B. It follows Oracle Application Object Library Multi-Lingual Support (MLS) conventions, holding language-specific, translatable attributes for each data source function record. In Oracle EBS 12.1.1 and 12.2.2, OKL supports lease and finance contract authoring, and data source functions describe the functional operations that source external or internal data used in lease contract generation. The TL table ensures the user-facing description of each function is presented in the session language.

The table resides in the APPS_TS_TX_DATA tablespace and is owned by the OKL schema. Heuristic Data Vault modeling suggests classification as a satellite: it extends the base entity with descriptive, language-qualified attributes (notably DESCRIPTION) and carries a composite key that references the parent. It is not a hub or link, since it holds no independent business identity of its own.

Key Information Stored

• ID — Number; part of the primary key (with LANGUAGE) and the surrogate identifier of the corresponding base record. It is the leading column of the unique index OKL_DATA_SRC_FNCTNS_TL_U2.
• LANGUAGE — VARCHAR2(12); the language of the translated row, part of the primary key.
• ZD_EDITION_NAME — VARCHAR2(30); edition-based redefinition (EBR) column, present because this table is edition-enabled in 12.2.x. It is the third column of the unique business-key index OKL_DATA_SRC_FNCTNS_TL_U2.
• SOURCE_LANG — VARCHAR2(12); the source language from which the row was translated, used by the MLS translation batch process.
• SFWT_FLAG — VARCHAR2; flag manipulated by the translation batch program to indicate translation state.
• DESCRIPTION — VARCHAR2(1995); the translated, user-entered description of the data source function, the primary business-content column.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard who columns recording the audit trail required by the Oracle EBS data model.

The primary key is OKL_DATA_SRC_FNCTNS_TL_PK (ID, LANGUAGE). The unique index OKL_DATA_SRC_FNCTNS_TL_U2 (ID, LANGUAGE, ZD_EDITION_NAME) is the EBR-aware business-key candidate. OKL_DATA_SRC_FNCTNS_TL_PK and U2 both enforce one translated row per language (and edition).

Common Use Cases and Queries

Typical usage resolves the language-specific description for a data source function given its ID and the runtime language. Reports and concurrent programs join the TL table to the base table on ID.

SELECT t.id, t.language, t.description
FROM   okl.okl_data_src_fnctns_tl t
WHERE  t.id = :function_id
AND    t.language = userenv('LANG');

Translation audit queries use SOURCE_LANG and SFWT_FLAG to identify rows pending or completed by the MLS translation batch. EBR-aware queries pass the ZD_EDITION_NAME or rely on the editioning view. Reporting scenarios include listing all function descriptions by language, validating that every base record has a matching translation, and detecting stale rows via LAST_UPDATE_DATE.

Related Objects

• OKL.OKL_DATA_SRC_FNCTNS_B — the base/MLS source table; join on the shared ID. This is the canonical parent of all translatable columns.
• OKL_DATA_SRC_FNCTNS_TL# — the editioning/underlying view or synonym exposed for the translation table in EBR-enabled environments.
• OKL_DATA_SRC_FNCTNS_TL_U2 / OKL_DATA_SRC_FNCTNS_TL_PK — the unique indexes supporting the business key and primary key.
• OKL_DATA_SRC_FNCTNS_VL — the typical MLS "VL" (view-all-languages) view consolidating base and translation rows for reporting.
• FND_LANGUAGES — provides valid LANGUAGE and SOURCE_LANG codes used to resolve descriptions.
• FND Designer / MLS translation programs — consume SFWT_FLAG and SOURCE_LANG during batch translation.

All objects are in the OKL schema, accessed at runtime through the APPS synonym layer.