Search Results iex_stry_temp_work_items_b




Overview
Explore in AI Chat

Overview

IEX_STRY_TEMP_WORK_ITEMS_B is a Collections (IEX) module table in Oracle E-Business Suite 12.1.1 and 12.2.2. It stores the business definitions, or "templates," for work items that drive the collections strategy engine. A work item in Advanced Collections represents a discrete task or action assigned to a collector or a resource—such as a phone call, dunning letter, or follow-up—and this table holds the reusable master definition rather than the individual instance assigned to a specific delinquent customer.

The _B suffix indicates this is the base table of a translated entity pair, normally accompanied by a corresponding _TL table holding language-specific descriptive columns. With 54 documented columns, the table is wide but structurally simple. According to the heuristic Data Vault classification mined from its foreign key structure, this object is best treated as a standalone entity—neither a true hub nor a link nor a dependent satellite—because its foreign keys point to reference/master data rather than forming a chain of transactional relationships.

Key Information Stored

The surrogate primary key for this table is WORK_ITEM_TEMP_ID. The unique index IEX_STRY_TEMP_WORK_ITEMS_B_U1 covers WORK_ITEM_TEMP_ID together with ZD_EDITION_NAME, which is the pattern used by Oracle's edition-based redefinition (EBR) support in 12.2.x, allowing multiple active versions of the same template across editions.

Common Use Cases and Queries

Typical use cases include auditing which work item templates are enabled, reporting on strategy configuration, and diagnosing why a collection task did not trigger. Because templates are versioned by edition in 12.2.x, queries should filter on ZD_EDITION_NAME. A simple listing of active templates by type might read:

SELECT WORK_ITEM_TEMP_ID, WORK_TYPE, CATEGORY_TYPE, PRIORITY_TYPE, ENABLED_FLAG
FROM IEX.IEX_STRY_TEMP_WORK_ITEMS_B
WHERE ENABLED_FLAG = 'Y'
AND ZD_EDITION_NAME = 'SET1';

A join to confirm the required competence joins COMPETENCE_ID to PER_COMPETENCES. Reporting against schedule and escalation fields supports workload forecasting and SLA monitoring.

Related Objects

  • PER_COMPETENCES – joined via COMPETENCE_ID to resolve the skill or competence required by the template.
  • FND_SECURITY_GROUPS – joined via SECURITY_GROUP_ID for access control.
  • IEX_STRY_TEMP_WORK_ITEMS_TL – the translated companion table supplying language-specific names and descriptions.
  • IEX_STRATEGIES and related strategy tables – consume these templates when composing a collections strategy.
  • IEX_WORK_ITEMS – the transactional instance table that materializes a template against a customer account.