Results for “okl_disb_rules_tl”

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

Overview

OKL_DISB_RULES_TL is the translation (TL) table for disbursement rules within the Oracle Lease and Finance Management (OKL) module. It stores the language-dependent, translatable columns that accompany the language-independent base record held in OKL_DISB_RULES_ALL_B. The table follows Oracle Multi-Lingual Support (MLS) standards, meaning each row represents a single disbursement rule in a single installed language, keyed by the combination of the business entity identifier and the language code. This separation allows the same rule definition to present descriptive text in multiple languages without duplicating the underlying rule logic.

Disbursement rules govern how and when funds are released against a lease or finance contract, including conditions that determine eligibility for a disbursement and how amounts are scheduled or released. The TL table therefore sits on the descriptive edge of the disbursement-rule model, holding the human-readable text that users see in the application while the operational attributes reside in the base table.

From a Data Vault modeling perspective, this object is best classified heuristically as a satellite. It carries descriptive, time-stamped attributes associated with the disbursement-rule hub, and its grain is defined by the parent identifier plus language. It is not a hub (it does not introduce its own business key) and not a link (it does not resolve a many-to-many relationship). The relationship data classifies it as standalone with respect to foreign keys, reinforcing that its dependency on the parent is through the shared identifier rather than a declared FK constraint.

Key Information Stored

The table contains 10 documented columns. The most important are:

• DISB_RULE_ID — The identifier of the disbursement rule. It is the leading component of the composite primary key OKL_DRT_PK and links each translated row back to its parent record in OKL_DISB_RULES_ALL_B.
• LANGUAGE — The language code for the translated content. Together with DISB_RULE_ID it forms the full primary key, so only one row per rule per language is permitted.
• SOURCE_LANG — Identifies the source language from which the translation originated, used by MLS tooling to track the origin of the text.
• SFWT_FLAG — The "Seed/Force/Translate" style flag used in MLS to control whether the row is seeded, whether translation is forced, and related propagation behaviour for the translated text.
• DESCRIPTION — The primary translatable payload: the descriptive name or text for the disbursement rule as presented to the user in the given language.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard Oracle who-columns providing audit and concurrency information for each translated row.

The surrogate-style primary key is the composite OKL_DRT_PK over (DISB_RULE_ID, LANGUAGE). DISB_RULE_ID is a business-key candidate referencing the parent rule, while LANGUAGE qualifies the translation. No separate unique index beyond the primary key is documented in the supplied metadata.

Common Use Cases and Queries

Typical usage centres on presenting disbursement-rule descriptions in the user's session language, and on translation maintenance and auditing. A common pattern joins the translation table to the base table filtered by language:

• Retrieving rule descriptions for a given language:
  SELECT b.disb_rule_id, t.description FROM okl_disb_rules_all_b b, okl_disb_rules_tl t WHERE b.disb_rule_id = t.disb_rule_id AND t.language = USERENV('LANG');
• Auditing translations, for example locating rules that lack a row in a specific language or whose DESCRIPTION is null or stale.
• Reporting on translation coverage by comparing DISTINCT LANGUAGE values per DISB_RULE_ID against the set of installed languages.
• Tracking recent changes to translated text using LAST_UPDATE_DATE and LAST_UPDATED_BY.

Because the table is MLS-managed, direct DML is generally performed through the application or the standard translation forms rather than by ad hoc inserts, to keep SOURCE_LANG and SFWT_FLAG consistent.

Related Objects

• OKL_DISB_RULES_ALL_B — The base table holding language-independent disbursement-rule attributes; joined on DISB_RULE_ID.
• OKL_DISB_RULES_ALL_TL — The corresponding "_ALL" translation view/table exposing translatable columns for the ALL synonym family.
• OKL_DISB_RULES_B / OKL_DISB_RULES_TL — The non-"_ALL" base and translation variants that mirror the same MLS structure.
• OKL_DISB_RULES_VL — The MLS view that joins base and translation columns for reporting, filtering on LANGUAGE.
• FND_LANGUAGES — The reference table of installed languages, joined on LANGUAGE.
• FND_USER — Referenced via CREATED_BY and LAST_UPDATED_BY for audit attribution.

These objects together form the disbursement-rule MLS family used across OKL setup and contract-processing screens.