Search Results okc_actions_tl_u1

Overview

OKC.OKC_ACTIONS_TL is the translation (MLS) table for the OKC_ACTIONS_B base table in the Oracle Contracts (OKC) module. It stores the translatable attributes of contract actions — the descriptive text fields that must be presented to users in their own language — while the language-independent attributes and keys reside in the base table. The "_TL" suffix follows Oracle's Multi-Lingual Support (MLS) convention: one row exists per action and per installed language, with LANGUAGE acting as part of the composite primary key.

The table is owned by the OKC schema and resides in the APPS_TS_SEED tablespace, consistent with other seed and reference data objects in the Contracts application. Its FND Design Data registration is OKC.OKC_ACTIONS_TL, indicating it is a registered, supported application object rather than a custom extension. In Oracle EBS 12.1.1 the table carries the standard MLS columns; in 12.2.2 the documented schema additionally exposes the ZD_EDITION_NAME column, reflecting the editioning infrastructure introduced with the Online Patching architecture. The object carries no foreign keys referencing other tables, and the sole documented dependency relationship is the SECURITY_GROUP_ID column mapped to FND_SECURITY_GROUPS, used in hosted environments.

Under the heuristic Data Vault classification derived from the foreign-key structure, this object is modeled as a standalone entity: it neither acts as a link table joining two hubs nor as a satellite attached through a foreign key, but rather holds descriptive, language-dependent attributes keyed directly on the base entity's identifier and language.

Key Information Stored

The most significant columns are:

• ID — System-generated unique identifier for the action, sourced from sequence OKC_ACTIONS_S1. It is the primary key of the table, combined with LANGUAGE.
• LANGUAGE — Standard MLS column holding the language code (for example, US or ZHS) in which the row's descriptive text is stored.
• SOURCE_LANG — Standard MLS column identifying the language from which the row was originally derived.
• NAME — The translatable name of the action; capped at 150 characters.
• DESCRIPTION — Full action description, up to 1995 characters.
• SHORT_DESCRIPTION — Abbreviated description, up to 600 characters, typically used in list-of-values and picker displays.
• COMMENTS — User-entered free-form comments, up to 1995 characters.
• SFWT_FLAG — Flag indicating that a value was changed in another language; the metadata notes it is not currently used.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard Who columns capturing audit and row-level change information.
• SECURITY_GROUP_ID — Used in hosted environments to isolate data across security groups; the only documented referential dependency.
• ZD_EDITION_NAME — Editioning column present in the 12.2.2 physical schema, supporting Online Patching and edition-based redefinition.

Regarding business-key candidates, the unique index named in the user's search — OKC_ACTIONS_TL_U3 — enforces uniqueness on (NAME, LANGUAGE) in the 12.1.1 documentation, and on (NAME, LANGUAGE, ZD_EDITION_NAME) in the documented 12.2.2 schema. The companion unique index OKC_ACTIONS_TL_U1 covers (ID, LANGUAGE) and, in 12.2.2, (ID, LANGUAGE, ZD_EDITION_NAME). The surrogate primary key remains ID plus LANGUAGE, while NAME plus LANGUAGE functions as the business-key candidate.

Common Use Cases and Queries

Typical usage involves joining the translation table to its base table on ID to present language-appropriate action descriptions. A representative query is:

• SELECT b.id, t.name, t.short_description FROM okc.okc_actions_b b, okc.okc_actions_tl t WHERE b.id = t.id AND t.language = USERENV('LANG');
• Filter on NAME and LANGUAGE to detect duplicate action names within a single language, which is the constraint enforced by OKC_ACTIONS_TL_U3.
• Reporting or extract jobs that pull translated action catalogues for downstream applications, restricting LANGUAGE to the desired locale.
• Data-fix and audit scripts that verify every row in OKC_ACTIONS_B has a corresponding translation in each installed language, using an outer join against the base table.
• Compliance and hosting queries that filter by SECURITY_GROUP_ID to isolate tenants in shared environments.

Related Objects

• OKC.OKC_ACTIONS_B — The base (non-translated) table. Joined on ID; supplies the language-independent attributes and the sequence-generated identifier.
• OKC.OKC_ACTIONS_TL_PK — The primary key constraint on (ID, LANGUAGE), defining row uniqueness.
• OKC_ACTIONS_TL_U1 and OKC_ACTIONS_TL_U3 — Unique indexes providing the documented business-key candidates.
• FND_SECURITY_GROUPS — Target of the SECURITY_GROUP_ID reference, used in hosted deployments.
• APPS.OKC_ACTIONS_TL — The APPS-layer synonym through which the table is normally accessed from application code and ad-hoc SQL.