Results for “crit_cat_desc”

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

Overview

OKL_FE_CRIT_CAT_DEF_TL is the translatable (language-dependent) child table of the Criteria Categories definition in the Oracle Leasing and Finance Management (OKL) module. It stores the human-readable, language-specific text associated with each criteria category used by the OKL Rules Engine and the criteria framework (the "FE" prefix denoting the rules/feature evaluation engine). Criteria categories group individual scoring or qualification criteria, enabling the leasing application to organize underwriting, credit, and scoring attributes into logical buckets.

Because it is a translation table, OKL_FE_CRIT_CAT_DEF_TL holds one row per (criteria category, language) combination. In a multi-language EBS deployment, the base-language row and every installed translated-language row coexist here, allowing the criteria category description to be presented in the session's language. The ETRM metadata classifies this object, by heuristic Data Vault modeling, as standalone: it is a pure descriptive attribute set keyed to its parent and does not itself participate in FK relationships to downstream tables. This is consistent with a satellite-style suggestion — descriptive, language-dependent attributes attached to the criteria category entity — rather than a hub or link. The table is owned by the OKL schema and is currently VALID in the 12.1.1 and 12.2.2 dictionary.

Key Information Stored

The table comprises 11 documented columns. The most significant are:

• CRIT_CAT_DEF_ID — the surrogate/foreign key linking each translation row back to the parent criteria category definition (OKL_FE_CRIT_CAT_DEF_B).
• LANGUAGE — the NLS language code identifying the language of the row.
• SOURCE_LANG — the base language of the source text, used by the translation framework.
• SFWT_FLAG — the "Seed Data / foreign-word translation" flag indicating whether the translation has been manually maintained versus machine/seeded.
• CRIT_CAT_DESC — the actual translated description of the criteria category, the principal business attribute.
• ZD_EDITION_NAME — the editioning column supporting EBS online patching (Edition-Based Redefinition) in the 12.2.x release.

The remaining columns — CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, and LAST_UPDATE_LOGIN — are standard EBS audit ("Who" columns) maintained automatically by the application. The primary key is OKL_FE_CRIT_CAT_DEF_TL_PK on (CRIT_CAT_DEF_ID, LANGUAGE). A unique index, OKL_FE_CRIT_CAT_DEF_TL_U1 on (CRIT_CAT_DEF_ID, LANGUAGE, ZD_EDITION_NAME), forms the business-key candidate when editioning is considered. Note that the surrogate key is composed of the parent FK plus LANGUAGE, so CRIT_CAT_DEF_ID alone is not unique.

Common Use Cases and Queries

Typical reporting retrieves the description of a criteria category in the user's preferred language, or audits which criteria categories lack translations for a given installed language.

• Resolving a description for display: join to the parent definition OKL_FE_CRIT_CAT_DEF_B on CRIT_CAT_DEF_ID and filter LANGUAGE = USERENV('LANG').
• Finding criteria categories with missing translations: a NOT EXISTS query against a list of installed languages for each CRIT_CAT_DEF_ID.
• Auditing manually translated versus seeded descriptions via SFWT_FLAG and SOURCE_LANG.

A representative query:

SELECT b.crit_cat_def_id, t.language, t.crit_cat_desc, t.source_lang, t.sfwt_flag FROM okl.okl_fe_crit_cat_def_b b, okl.okl_fe_crit_cat_def_tl t WHERE b.crit_cat_def_id = t.crit_cat_def_id AND t.language = USERENV('LANG');

Related Objects

• OKL_FE_CRIT_CAT_DEF_B — the base (non-translatable) table; joined on CRIT_CAT_DEF_ID. This is the primary parent referenced by this object.
• OKL_FE_CRITERIA_DEF_B / _TL — the individual criteria that belong to a category; relate indirectly through the category definition.
• OKL_FE_CRIT_MEMBER / scoring setup tables — the rules-engine configuration that consumes criteria categories.
• FND_LANGUAGES — the reference table validating the LANGUAGE and SOURCE_LANG values.
• OKL_FE_CRIT_CAT_DEF_TL_PK / _U1 — the enforcing primary key and unique business-key indexes.

Because the object is standalone with no outgoing foreign keys, downstream dependencies are limited to the parent definition table and the OKL rules-engine setup, all joined on CRIT_CAT_DEF_ID.