Results for “ozf_thresholds_all_tl”

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

Overview

OZF_THRESHOLDS_ALL_TL is the translation table for the Funds Thresholds entity within the Oracle Trade Management (OZF) module. In Oracle EBS, transactional and setup entities that require multilingual support are typically implemented as a pair of tables: a base table (OZF_THRESHOLDS_ALL_B) that stores language-independent attributes and a translation table (OZF_THRESHOLDS_ALL_TL) that stores the language-dependent descriptive text. This table holds the translated name and description of each funds threshold record, keyed by both the threshold identifier and the language code. It is present in both EBS 12.1.1 and 12.2.2, and its purpose is consistent across releases.

From a Data Vault modeling perspective, the metadata heuristically classifies this object as satellite-leaning. This is an appropriate suggestion: the table does not introduce new business entities (hub) or define relationships between entities (link), but rather carries descriptive, language-specific attributes attached to the threshold hub. Its primary key, OZF_THRESHOLDS_ALL_TL_PK, is composed of LANGUAGE and THRESHOLD_ID, reinforcing its role as a dependent descriptor table.

Key Information Stored

The table contains 17 documented columns. The most significant include:

• THRESHOLD_ID — Surrogate identifier for the threshold; forms part of the composite primary key and is the foreign key linking to OZF_THRESHOLDS_ALL_B.
• LANGUAGE — The NLS language code for the translated row; the second component of the primary key. Together with THRESHOLD_ID it uniquely identifies each translation.
• SOURCE_LANG — Indicates the source language of the base record, used by the translation framework to track which language the original text was authored in.
• NAME — The translated name of the threshold, the primary user-facing descriptive attribute.
• DESCRIPTION — The translated description providing additional detail about the threshold condition or purpose.
• ORG_ID — Operating unit identifier supporting multi-org access control.
• SECURITY_GROUP_ID — References FND_SECURITY_GROUPS, controlling row-level security.

Standard audit and concurrency columns are also present: LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATION_DATE, CREATED_BY, CREATED_FROM, REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, and PROGRAM_UPDATE_DATE. The surrogate primary key should be distinguished from business-key candidates; no unique index beyond the composite PK is documented, so THRESHOLD_ID combined with LANGUAGE serves as the effective business key for translations.

Common Use Cases and Queries

Report writers and integrators query this table primarily to retrieve localized threshold names and descriptions for display on trade promotion, funds accrual, and budget-check screens. A typical query joins the translation table to the base table, filtering on the session language:

• SELECT tl.threshold_id, tl.name, tl.description FROM ozf_thresholds_all_tl tl WHERE tl.language = USERENV('LANG') AND tl.threshold_id = :p_threshold_id;

For multilingual reporting, the table is joined across languages to compare terminology. Because NAME and DESCRIPTION reside only here, any extract that requires human-readable threshold text must include this table in the join path with OZF_THRESHOLDS_ALL_B. Data migration and interface scripts inserting new thresholds must populate both the base and translation tables to ensure the record is visible in all configured languages.

Related Objects

• OZF_THRESHOLDS_ALL_B — The base table holding language-independent threshold attributes; joined on THRESHOLD_ID.
• OZF_THRESHOLDS_ALL_TL_PK — The composite primary key constraint on (LANGUAGE, THRESHOLD_ID) that enforces uniqueness.
• FND_SECURITY_GROUPS — Referenced by SECURITY_GROUP_ID for row-level security enforcement.
• FND_LANGUAGES — Provides the set of valid values for the LANGUAGE and SOURCE_LANG columns.
• OZF_THRESHOLDS_ALL_V — A commonly defined view that merges base and translation rows for simplified querying.

These relationships confirm that OZF_THRESHOLDS_ALL_TL functions strictly as a dependent translation satellite, never as an independent transactional entity.