Search Results okc_process_defs_tl_u1

Overview

OKC.OKC_PROCESS_DEFS_TL is the translation (MLS) table for the OKC Process Definitions entity within the Oracle Contracts (OKC) module of Oracle E-Business Suite. Every row in this table represents a language-specific rendering of a Process Definition stored in the base table OKC.OKC_PROCESS_DEFS_B. The table follows the standard Oracle Multi-Lingual Support (MLS) pattern, where the base table holds one language-neutral record and the _TL table holds one row per installed language for the translatable descriptive attributes. It resides in the APPS_TS_TX_DATA tablespace with a PCTFREE of 10 and is documented as VALID in both 12.1.1 and 12.2.2.

From a Data Vault modeling perspective, the metadata classifies this object as standalone (no foreign-key dependencies to other business entities are recorded beyond SECURITY_GROUP_ID). In Data Vault terms, this structure is best modeled as a satellite attached to the Process Definition hub represented by OKC_PROCESS_DEFS_B, since it carries descriptive, language-dependent attributes keyed by the parent identifier plus LANGUAGE.

Key Information Stored

The table is keyed by a composite primary key, OKC_PROCESS_DEFS_TL_PK(ID, LANGUAGE), and additionally exposes a unique index, OKC_PROCESS_DEFS_TL_U1(ID, LANGUAGE, ZD_EDITION_NAME), used as the business-key candidate. The most significant columns include:

• ID — System-generated unique identifier; the primary key and foreign-key link back to OKC_PROCESS_DEFS_B.
• LANGUAGE — Standard MLS language code; forms the second component of the primary key.
• SOURCE_LANG — The language in which the row was originally authored; standard MLS audit column.
• NAME — The translated Process Definition name (VARCHAR2 150).
• DESCRIPTION — Long description of the process definition (VARCHAR2 1995).
• SHORT_DESCRIPTION — Brief description (VARCHAR2 600).
• COMMENTS — User-entered commentary (VARCHAR2 1995).
• SFWT_FLAG — Flag indicating a change in another language; documented as not used.
• SECURITY_GROUP_ID — Used in hosted (multi-tenant) environments; FK to FND_SECURITY_GROUPS.
• ZD_EDITION_NAME — Editioning column supporting Online Patching in 12.2; part of the U1 unique index.
• Standard Who columns: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN.

Common Use Cases and Queries

Because OKC_PROCESS_DEFS_TL is only one-half of the MLS pair, all queries must join the base table to reconstruct the full, language-tagged record. Typical reporting scenarios include listing all process definitions with their user-facing names and descriptions, generating multilingual UI labels, and auditing translation coverage across installed languages.

A representative query joining the base and translation tables is:

• SELECT b.id, t.language, t.name, t.short_description, t.description FROM okc.okc_process_defs_b b, okc.okc_process_defs_tl t WHERE b.id = t.id AND t.language = USERENV('LANG');
• To find definitions missing a translation in a given language, use an outer join filtered on t.language IS NULL.
• To audit translation currency, compare LAST_UPDATE_DATE between the base and translation rows.
• FND-level lookups via FND_LOOKUPS and the MSD (Multi-lingual Support Dictionary) reference LANGUAGE codes for filtering.

Related Objects

• OKC.OKC_PROCESS_DEFS_B — Base MLS table; jointed on ID. Contains all non-translatable attributes of the Process Definition.
• OKC.OKC_PROCESS_DEFS_TL_PK — Primary key constraint on (ID, LANGUAGE).
• OKC_PROCESS_DEFS_TL_U1 — Unique index on (ID, LANGUAGE, ZD_EDITION_NAME) in APPS_TS_TX_IDX.
• FND_SECURITY_GROUPS — Referenced by SECURITY_GROUP_ID for hosted environments.
• APPS.OKC_PROCESS_DEFS_TL — The APPS synonym exposing the table to the application layer.
• FND_LANGUAGES / FND_LOOKUPS — Provide the LANGUAGE and SOURCE_LANG code domain.
• OKC_PROCESS_DEFS_B_U1 — Corresponding base-table unique index used alongside for entity-level reporting.