Search Results okc_actions_tl_pk

Overview

OKC_ACTIONS_TL is the translation table for the Oracle Contracts Core (OKC) module in Oracle E-Business Suite 12.1.1 and 12.2.2. It stores the Multi-Lingual Support (MLS) translatable columns corresponding to OKC_ACTIONS_B, the base table that holds action definitions used throughout the contracts lifecycle. Action records drive task processing, workflow routing, contract deliverables, and status transitions in Oracle Contracts, and the paired design of the base and translation tables ensures that descriptive attributes can be presented in each installed language.

Each row represents the translated content of a single action for a specific language, identified by the combination of the action ID and the LANGUAGE code. The table resides in the OKC schema and is classified as VALID. In the heuristic Data Vault classification mined from the foreign key structure, OKC_ACTIONS_TL is a standalone object; as a modeling suggestion, it functions as a satellite on the OKC_ACTIONS_B hub, carrying descriptive, language-dependent attributes keyed by the parent action identifier and language.

Key Information Stored

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

• ID — The surrogate identifier linking the translation row to its parent action record in OKC_ACTIONS_B. It forms part of the primary key.
• LANGUAGE — The language code for the translated row. ID and LANGUAGE together constitute OKC_ACTIONS_TL_PK, the primary key.
• NAME — The translated action name, used in user interfaces, lists of values, and workflow prompts. NAME participates in the unique index OKC_ACTIONS_TL_U3 (NAME, LANGUAGE, ZD_EDITION_NAME), a business-key candidate.
• DESCRIPTION — The full translated description of the action.
• SHORT_DESCRIPTION — An abbreviated translated description for constrained display regions.
• COMMENTS — Free-form translated remarks associated with the action.
• SOURCE_LANG — The language from which the translation was seeded.
• ZD_EDITION_NAME — The edition indicator supporting Edition-Based Redefinition in 12.2.x.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE — Standard audit columns tracking who created and last modified each translated row, and when.
• SECURITY_GROUP_ID — References FND_SECURITY_GROUPS, supporting multi-organization and security group access control.

The unique index OKC_ACTIONS_TL_U1 (ID, LANGUAGE, ZD_EDITION_NAME) reinforces the business key of action and language. CORRELATION and SFWT_FLAG are also documented and support internal correlation and translation-workflow processing.

Common Use Cases and Queries

Typical usage centers on retrieving action descriptions in the session language for reporting and for validating seeded setup data. A common pattern joins the translation table to the base table to resolve the translated name:

• Query action names for a language: SELECT t.name, t.description FROM okc_actions_tl t WHERE t.language = 'US';
• Join to base for context: SELECT b.id, t.name, t.description FROM okc_actions_b b, okc_actions_tl t WHERE b.id = t.id AND t.language = USERENV('LANG');
• Identify missing translations: compare distinct IDs in OKC_ACTIONS_B against rows in OKC_ACTIONS_TL for a given language.
• Audit translation changes: filter on LAST_UPDATED_DATE and LAST_UPDATED_BY for a date range.
• Security-aware reporting: join through SECURITY_GROUP_ID to FND_SECURITY_GROUPS to restrict results to authorized groups.

Because translated text is stored only in this table, any extraction or interface that surfaces action labels should read from OKC_ACTIONS_TL rather than the base table.

Related Objects

• OKC_ACTIONS_B — The base table supplying untranslatable columns; joined on ID.
• FND_SECURITY_GROUPS — Referenced via SECURITY_GROUP_ID for access control.
• FND_LANGUAGES — Provides the LANGUAGE code set used for translation rows.
• FND_LOOKUPS / FND_LOOKUP_VALUES — Frequently joined for translated lookup values referenced by actions.
• OKC_ACTIONS_TL_PK and OKC_ACTIONS_TL_U1 / U3 — Primary key and unique indexes enforcing action/language identity.
• OKC_ACTION_HISTORY or action-processing logic — Consumes action definitions resolved from this table during contract task processing.