Search Results okl_fe_crit_cat_def_tl_pk

Overview

The OKL_FE_CRIT_CAT_DEF_TL table is a core translation table within the Oracle E-Business Suite (EBS) Lease and Finance Management (OKL) module, specifically for versions 12.1.1 and 12.2.2. It serves as the multilingual repository for user-facing descriptive text associated with criteria category definitions. In the context of the OKL module's flexible criteria engine, a criteria category is a logical grouping used to classify and organize various business rules or conditions. This table enables the system to store translated names and descriptions for these categories, supporting global deployments by allowing the application's criteria framework to be presented in a user's native language. Its role is integral to maintaining a multilingual user interface for the configuration and management of complex leasing and financing business rules.

Key Information Stored

The table stores the translatable attributes for a criteria category definition. Its structure is typical of an EBS translation table, utilizing a composite primary key that links the base record to a specific language. The most critical columns include:

• CRIT_CAT_DEF_ID: The foreign key that uniquely identifies the base criteria category definition record in its corresponding base table (e.g., OKL_FE_CRIT_CAT_DEF_B). This is the link to the non-translatable data.
• LANGUAGE: The ISO code for the language of the translated text in this row (e.g., 'US' for American English).
• SOURCE_LANG: A column (common in TL tables) indicating the original language in which the data was entered.
• NAME: The translated name or title of the criteria category as displayed in the application.
• DESCRIPTION: A translated detailed explanation of the criteria category's purpose.

The primary key constraint, OKL_FE_CRIT_CAT_DEF_TL_PK, is defined on the combination of CRIT_CAT_DEF_ID and LANGUAGE, ensuring only one translation per language per category definition.

Common Use Cases and Queries

The primary use case is retrieving criteria category descriptions in the session language for UI display, reports, and downstream processing within the OKL module. A common SQL pattern joins this table with its base table to fetch a complete, language-specific record. For example, to list all active criteria category definitions in the current session language:

SELECT b.ID, tl.NAME, tl.DESCRIPTION
FROM OKL_FE_CRIT_CAT_DEF_B b,
OKL_FE_CRIT_CAT_DEF_TL tl
WHERE b.CRIT_CAT_DEF_ID = tl.CRIT_CAT_DEF_ID
AND tl.LANGUAGE = userenv('LANG')
AND b.ACTIVE_FLAG = 'Y';

Another critical use case is during implementation and support, where queries against this table help verify that all necessary translations have been seeded or created for a new criteria category across all installed languages. Data fixes or translation updates are also performed directly on this table, often via the standard Oracle Application Developer's translation interface.

Related Objects

This translation table has a direct, mandatory relationship with its base table. The documented primary key relationship indicates the following key dependency:

• Base Table (OKL_FE_CRIT_CAT_DEF_B): The table OKL_FE_CRIT_CAT_DEF_TL is wholly dependent on its base table. The CRIT_CAT_DEF_ID column in the TL table is a foreign key referencing the primary key (typically a column also named CRIT_CAT_DEF_ID) in the base table OKL_FE_CRIT_CAT_DEF_B. This base table holds the non-translatable operational attributes, such as active dates, internal codes, and creation metadata, for the criteria category definition.

In application logic, this table is accessed via views (often _VL for "View, Localized") that automatically handle the language join, or through the OKL API layers that manage criteria setup. Any program or interface that displays criteria category names or descriptions will ultimately query this table to respect the user's language setting.