Search Results okc_process_def_parms_tl




Overview
Explore in AI Chat

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

Overview

OKC_PROCESS_DEF_PARMS_TL is the translatable (language-specific) child table of the Contracts Core (OKC) process definition parameter model in Oracle E-Business Suite 12.1.1 and 12.2.2. Under Oracle's Multi-Lingual Support (MLS) architecture, descriptive text attributes are separated from the base table, OKC_PROCESS_DEF_PARMS_B, so that a single parameter definition can be rendered in multiple installed languages. This table stores the translated parameter names and descriptions for process definition parameters used by the Contracts Core process/parameter framework.

From a Data Vault modeling perspective, the metadata's heuristic classification returns standalone, meaning the object does not present the characteristic hub, link, or satellite shape normally associated with dimensional or Data Vault constructs. It is best modeled as a language-dependent descriptive satellite attached to its base table, keyed by the business identifier plus the language code rather than by any independent hub key.

Key Information Stored

The table contains 13 documented columns. The most significant are:

  • ID — the surrogate/foreign key that identifies the underlying parameter definition in OKC_PROCESS_DEF_PARMS_B. This is the primary business join column.
  • LANGUAGE — the installed Oracle language code (for example, US for American English) indicating which translation the row provides.
  • SOURCE_LANG — the language from which the current translation was derived, used by MLS utilities to detect stale or missing translations.
  • SFWT_FLAG — the standard "Seed/Force/Update" flag that governs whether the translated row may be overwritten during patch or seed-data application.
  • NAME — the translated display name of the process definition parameter.
  • DESCRIPTION — the translated description presented to administrators and users when configuring contract processes.
  • ZD_EDITION_NAME — the editioning column introduced in EBS 12.2's online patching architecture, enabling edition-based redefinition.
  • CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — the standard WHO audit columns capturing row ownership and change history.
  • SECURITY_GROUP_ID — a legacy multi-organization access control column referenced to FND_SECURITY_GROUPS.

The surrogate primary key is OKC_PROCESS_DEF_PARMS_TL_PK on (ID, LANGUAGE). A second unique index, OKC_PROCESS_DEF_PARMS_TL_U1 on (ID, LANGUAGE, ZD_EDITION_NAME), is documented as the business-key candidate and reinforces the editioning model. Note that because SOURCE_LANG, SFWT_FLAG, and ZD_EDITION_NAME are present, the schema reflects a 12.2.2 MLS layout; 12.1.1 installations typically omit ZD_EDITION_NAME.

Common Use Cases and Queries

Reporting on process definition parameters almost always requires joining the _TL table to the _B table and filtering by the session or requested language. A representative query retrieves the parameter label and description for a given language:

  • SELECT b.id, t.language, t.name, t.description FROM okc_process_def_parms_b b, okc_process_def_parms_tl t WHERE b.id = t.id AND t.language = USERENV('LANG');
  • To audit missing translations, compare installed languages against rows present: SELECT b.id, l.language, t.id FROM okc_process_def_parms_b b, fnd_languages l LEFT JOIN okc_process_def_parms_tl t ON b.id = t.id AND l.language_code = t.language WHERE t.id IS NULL;
  • For 12.2 environments, edition-aware queries should filter on ZD_EDITION_NAME to avoid returning rows across editions.

Typical scenarios include generating configuration documentation for contract process parameters, reviewing localization completeness, and validating parameter names presented in the Contracts setup user interface.

Related Objects

  • OKC_PROCESS_DEF_PARMS_B — the base table holding non-translatable attributes; joined on ID = ID.
  • OKC_PROCESS_DEFINITIONS and its _TL/_B tables — the parent process definitions to which parameters belong.
  • OKC_PROCESS_DEF_PARM_VALUES — parameter value records that resolve against these definitions.
  • FND_SECURITY_GROUPS — referenced by SECURITY_GROUP_ID for legacy access control.
  • FND_LANGUAGES — supplies the valid LANGUAGE codes used for MLS translation joins.
  • OKC_PROCESS_DEFN_PARMS_TL_V (or equivalent MLS view) — the language-resolved view exposing translated parameters for the Contracts setup UI and concurrent programs.