Search Results ieu_wp_param_props_tl

Overview

The IEU_WP_PARAM_PROPS_TL table is a core data object within the Oracle E-Business Suite (EBS) Universal Work Queue (UWQ) module. As a translation table (indicated by the "_TL" suffix), its primary role is to store language-specific, user-facing text for parameter properties used within the UWQ framework. The UWQ provides a centralized interface for agents to manage work items from various applications, such as tele-service, field service, and marketing. This table enables the multilingual display of labels, descriptions, and other textual attributes for configurable parameters that control the behavior and presentation of work queues, ensuring compliance in global deployments. It functions as the child table in a master-detail relationship with its base table, IEU_WP_PARAM_PROPS_B.

Key Information Stored

The table stores translated textual data linked to specific parameter property identifiers and language codes. Its structure is defined by a composite primary key. The most critical columns include:

• PARAM_PROPERTY_ID: A foreign key column that uniquely links each row to its corresponding master record in the IEU_WP_PARAM_PROPS_B table. This ID identifies the specific parameter property being translated.
• LANGUAGE: Represents the language code (e.g., 'US' for American English) for the translated text. Together with PARAM_PROPERTY_ID, it forms the table's primary key, ensuring only one translation per property per language.
• Translated Text Columns: While the provided metadata does not list specific attribute columns, typical translation tables in EBS contain columns such as PROPERTY_NAME, DESCRIPTION, or SOURCE_LANG. These hold the actual translated strings displayed in the user interface.

Common Use Cases and Queries

This table is primarily accessed by the EBS application to render the UWQ interface in the user's session language. Common technical use cases involve extracting multilingual setup data for reporting, auditing, or data migration purposes. A typical query would join this table to its base table to retrieve a complete set of parameter properties with their translations. For example, to audit all Spanish translations for UWQ parameters, a developer might use:

SELECT b.PARAM_PROPERTY_ID,
       tl.LANGUAGE,
       tl.PROPERTY_NAME,
       tl.DESCRIPTION
FROM IEU.IEU_WP_PARAM_PROPS_B b,
     IEU.IEU_WP_PARAM_PROPS_TL tl
WHERE b.PARAM_PROPERTY_ID = tl.PARAM_PROPERTY_ID
AND tl.LANGUAGE = 'ES'
AND tl.SOURCE_LANG = 'US';

Direct manipulation of this table via DML is strongly discouraged; updates should be performed through the standard EBS administrative forms or APIs to maintain data integrity.

Related Objects

The IEU_WP_PARAM_PROPS_TL table has a direct, documented relationship with one other core UWQ table, as per the provided foreign key metadata:

• IEU_WP_PARAM_PROPS_B: This is the base (or "B") table. The relationship is defined by the foreign key where IEU_WP_PARAM_PROPS_TL.PARAM_PROPERTY_ID references IEU_WP_PARAM_PROPS_B. This table holds the non-translatable, structural data for the parameter property, while the TL table holds the translatable attributes. A query must join these two tables on PARAM_PROPERTY_ID to get a complete record.

This table is also likely referenced by various UWQ seed data scripts and public APIs within the IEU module that manage work queue parameter configurations.