Search Results ieu_wp_act_param_sets_tl




Overview
Explore in AI Chat

Overview

IEU_WP_ACT_PARAM_SETS_TL is the translation table for UWQ Action-Param Sets within the IEU (Universal Work Queue) module of Oracle E-Business Suite. IEU provides a unified interface through which agents and knowledge workers access work items drawn from multiple source applications, and parameter sets define the runtime arguments that govern how a given action executes against those items. The "_TL" suffix identifies this as a translation-enabled table: it stores the language-dependent descriptive attributes for each parameter set, separated from the language-independent definition held in the corresponding base table.

The table resides in the IEU schema and is documented as VALID for both EBS 12.1.1 and 12.2.2. Its documented primary key, IEU_WP_ACT_PARAM_SETS_TL_PK, is composed of ACTION_PARAM_SET_ID and LANGUAGE, confirming that a single parameter set may carry one descriptive row per installed language. A secondary unique index, IEU_WP_ACT_PARAM_SETS_TL_U1, extends this key with ZD_EDITION_NAME, reflecting the editioning column introduced in the 12.2 online patching architecture.

From a Data Vault modeling perspective, the metadata heuristic classifies this object as satellite-leaning. That is a reasonable suggestion: the table's grain is the parameter set plus language, its key is inherited rather than independently generated, and its payload consists largely of descriptive and audit attributes. Under that lens, ACTION_PARAM_SET_ID functions as a foreign reference to the parent hub, LANGUAGE participates as a descriptive discriminator, and the label and description columns are satellite payload.

Key Information Stored

The table exposes thirteen documented columns. The most significant are:

  • ACTION_PARAM_SET_ID — Surrogate identifier of the parameter set. Part of the composite primary key and the join back to the base definition table.
  • LANGUAGE — Language code for the row. Completes the primary key and determines which translation is returned by a session.
  • ACTION_PARAM_SET_LABEL — Language-specific display label presented to users in the UWQ interface.
  • ACTION_PARAM_SET_DESC — Language-specific descriptive text explaining the purpose or contents of the parameter set.
  • SOURCE_LANG — The language in which the row was originally authored, used by the translation framework to determine whether a value is a true translation or a fallback.
  • ZD_EDITION_NAME — Editioning column, part of the U1 unique index; absent in 12.1.1 and central to the 12.2 online patching model.
  • OBJECT_VERSION_NUMBER — Optimistic locking token maintained by the Oracle Applications framework on update.
  • CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard WHO audit columns recording row creation and modification provenance.
  • SECURITY_GROUP_ID — Multi-tenant discriminator, documented as referencing FND_SECURITY_GROUPS.

Only two of the thirteen columns constitute the business-key candidate documented in the U1 index; the remainder are audit, control, or descriptive attributes.

Common Use Cases and Queries

The principal use case is retrieving user-facing labels for work queue parameter sets in the session's language. A typical query joins the translation table to its base definition and filters by LANGUAGE, allowing the translation framework to fall back to SOURCE_LANG where no translated row exists.

  • Inventory of parameter sets and their labels: select ACTION_PARAM_SET_ID, ACTION_PARAM_SET_LABEL from IEU_WP_ACT_PARAM_SETS_TL where LANGUAGE = userenv('LANG').
  • Translation coverage reporting: compare row counts per LANGUAGE against the base table to identify parameter sets lacking translations for a given locale.
  • Descriptive lookup for configuration review: retrieve ACTION_PARAM_SET_DESC alongside the parameter set identifier to document which actions are configured in a given work queue deployment.
  • Audit and change tracking: inspect LAST_UPDATED_BY and LAST_UPDATE_DATE to identify recently modified translations, particularly after a patch or language installation.
  • Edition-aware queries in 12.2: filter or join on ZD_EDITION_NAME when querying across edition boundaries during online patching cycles.

Related Objects

  • IEU_WP_ACT_PARAM_SETS — Base, language-independent table. Join on ACTION_PARAM_SET_ID; this is the parent of the translation row.
  • IEU_WP_ACT_PARAM_SETS_TL_PK — Primary key constraint over ACTION_PARAM_SET_ID and LANGUAGE, enforcing one translation per set per language.
  • IEU_WP_ACT_PARAM_SETS_TL_U1 — Unique index over ACTION_PARAM_SET_ID, LANGUAGE, and ZD_EDITION_NAME.
  • FND_SECURITY_GROUPS — Referenced through SECURITY_GROUP_ID for security group scoping.
  • IEU_WP_ACT_PARAMS / related UWQ action tables — Parameter and action definitions that consume the parameter set identified here.
  • FND_LANGUAGES — Supplies the installed language list against which LANGUAGE and SOURCE_LANG values are validated.
  • FND_APPLICATION / FND_PRODUCT_INSTALLATIONS — Administrative context for the IEU product installation that owns these rows.