Search Results istwitl_pk1

Overview

The IEX_STRY_TEMP_WORK_ITEMS_TL table is a translation (TL) table within the IEX schema, which belongs to the Oracle Collections (Advanced Collections / IEX) product family in Oracle E-Business Suite releases 12.1.1 and 12.2.2. It holds language-dependent, multilingual descriptive attributes for temporary (strategy) work item definitions used by the Collections strategy engine. In Advanced Collections, strategies drive the sequence of actions and work items that collectors perform against delinquent customers. This table stores the user-facing text (name and description) for those temporary work items in each installed language, while the underlying transactional or configuration attributes reside in the base table (IEX_STRY_TEMP_WORK_ITEMS_B).

From a data-modeling standpoint, the mined Data Vault classification for this object is standalone. This is a heuristic suggestion rather than a documented physical designation: because the table has no child tables referencing it and only a single foreign key to FND_SECURITY_GROUPS, it behaves as a reference/descriptive attribute carrier rather than participating in a hub-and-link transactional chain. Its content is tightly bound to the base entity keyed by WORK_ITEM_TEMP_ID, making it effectively a descriptive satellite for language-specific text.

Key Information Stored

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

• WORK_ITEM_TEMP_ID — the identifier of the parent temporary work item; the core business key linking this translation row to its base definition.
• LANGUAGE — the language code for the translated text, forming part of the composite primary key.
• NAME — the language-specific display name of the work item.
• DESCRIPTION — the translated descriptive text shown to users.
• SOURCE_LANG — the language from which the translation was seeded or derived.
• ZD_EDITION_NAME — the editioning marker introduced for Oracle EBS 12.2 online patching support.
• SECURITY_GROUP_ID — the multi-tenant / security grouping reference, with a foreign key to FND_SECURITY_GROUPS.
• CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — standard EBS WHO (audit) columns tracking record provenance and modification.

The surrogate primary key is ISTWITL_PK1, defined across (LANGUAGE, WORK_ITEM_TEMP_ID). A unique index, IEX_STRY_TEMP_WORK_ITEMS_TL_U1, on (WORK_ITEM_TEMP_ID, LANGUAGE, ZD_EDITION_NAME) serves as the business-key candidate and enforces one translation row per language per edition.

Common Use Cases and Queries

Typical usage centers on resolving the correct language text for reporting and on joining translations back to base configuration.

• Retrieving translated work item names for a given language:

SELECT tl.work_item_temp_id, tl.name, tl.description
FROM   iex_stry_temp_work_items_tl tl
WHERE  tl.language = USERENV('LANG');

• Joining base and translation tables for a complete definition:

SELECT b.work_item_temp_id, tl.name, tl.description
FROM   iex_stry_temp_work_items_b b,
       iex_stry_temp_work_items_tl tl
WHERE  b.work_item_temp_id = tl.work_item_temp_id
AND    tl.language = 'US';

• Detecting untranslated or missing-language rows by comparing base keys against the TL set.
• Reporting on the translation inventory and audit trail for configuration governance.

Related Objects

• IEX_STRY_TEMP_WORK_ITEMS_B — the base table holding language-independent attributes; joined on WORK_ITEM_TEMP_ID.
• FND_SECURITY_GROUPS — referenced via the SECURITY_GROUP_ID foreign key for security/multi-tenant grouping.
• IEX_STRY_TEMP_WORK_ITEMS_TL (base/bilingual pairing) — the TL-to-base relationship that governs all multilingual retrieval.
• FND_LANGUAGES — logical lookup validating the LANGUAGE and SOURCE_LANG values.
• IEX_STRY_WORK_ITEMS — related strategy work item definitions in the Collections strategy framework.
• FND_TERRITORIES / FND_LANGUAGES_TL — supporting reference data for language resolution.