Search Results okl_data_src_fnctns_tl_pk

Overview

The table OKL.OKL_DATA_SRC_FNCTNS_TL is a translatable (language) table within the Oracle E-Business Suite Release 12.1.1 / 12.2.2 Leasing and Finance Management (OKL) product family. It stores the language-dependent descriptive columns associated with data source functions defined for Oracle Lease and Finance Management contracts, pricing, and related flows. As defined by Oracle Multi-Lingual Support (MLS) standards, the _TL table holds only translated attributes, while language-independent attributes are held in its base counterpart, OKL_DATA_SRC_FNCTNS_B.

The object is owned by the OKL schema and is flagged VALID in the ETRM metadata. It is a physical table with eleven documented columns and is subject to MLS translation row repetition — one row per installed language per function identifier. Because the table carries only descriptive translation text and standard WHO audit columns, the mined Data Vault classification is standalone. In Data Vault modeling terms, this object is best treated as a satellite attached to the base function hub (OKL_DATA_SRC_FNCTNS_B), with LANGUAGE acting as the driving key for the descriptive attributes. This is a heuristic modeling suggestion rather than an enforced EBS constraint.

Key Information Stored

The column set represents the intersection of the MLS language mechanism, the function identifier, and the standard audit trail. The most significant columns are:

• ID — the function identifier. Together with LANGUAGE it forms the primary key (OKL_DATA_SRC_FNCTNS_TL_PK). This is the surrogate/business identifier linking back to the base table.
• LANGUAGE — the installed Oracle language code for the translated row. It participates in both the primary key and the unique index.
• ZD_EDITION_NAME — the editioning column used by Oracle EBS 12.2.x Editioning Views. It is part of the unique index OKL_DATA_SRC_FNCTNS_TL_U2 (ID, LANGUAGE, ZD_EDITION_NAME), making it a business-key candidate under editioning.
• SOURCE_LANG — the language from which the current translation was derived, supporting MLS "source language" tracking.
• SFWT_FLAG — the "Seed/Function/Translatable" style control flag used by MLS to indicate the translation status or propagation behavior of the row.
• DESCRIPTION — the translated descriptive text for the data source function, the primary human-readable payload of the table.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard Oracle WHO columns capturing auditing and user context.

The unique index OKL_DATA_SRC_FNCTNS_TL_U2 confirms that (ID, LANGUAGE, ZD_EDITION_NAME) constitutes a candidate business key, while the primary key remains the simpler (ID, LANGUAGE) pair.

Common Use Cases and Queries

Typical usage centers on retrieving the localized description of a data source function for UI display, concurrent programs, or reporting. A common pattern joins the _TL table to the _B table, filtered by the session language:

• Localized lookup: SELECT b.id, t.description FROM okl_data_src_fnctns_b b, okl_data_src_fnctns_tl t WHERE b.id = t.id AND t.language = USERENV('LANG');
• Translation completeness: compare row counts between _B and _TL grouped by LANGUAGE to detect missing translations.
• Change auditing: query LAST_UPDATED_BY / LAST_UPDATE_DATE to identify recently modified descriptions.
• Editioning-aware queries: filter on ZD_EDITION_NAME when operating against Editioning Views in 12.2.x.

Related Objects

• OKL_DATA_SRC_FNCTNS_B — base table; joined on ID.
• OKL_DATA_SRC_FNCTNS_TL_PK — primary key constraint (ID, LANGUAGE).
• OKL_DATA_SRC_FNCTNS_TL_U2 — unique index (ID, LANGUAGE, ZD_EDITION_NAME).
• OKL_DATA_SRC family tables — related data source definitions referenced by function identifiers.
• MLS/FND language utilities (FND_LANGUAGES) — provide the LANGUAGE domain for translation joins.