Search Results iex_strategy_work_skills




Overview
Explore in AI Chat

Overview

IEX_STRATEGY_WORK_SKILLS is a transactional table in the IEX (Collections) schema of Oracle E-Business Suite, available in both release 12.1.1 and 12.2.2. The table stores the skill set associated with each work item template defined in IEX_STRY_TEMP_WORK_ITEMS_B. In the Collections module, work items represent discrete collection activities that are generated by a strategy and assigned to collectors. Each work item template may require one or more competencies, and this table records those requirements so that assignment and routing logic can match work to appropriately skilled personnel.

The object is owned by IEX and its status is VALID in the documented ETRM 12.2.2 metadata. The heuristic Data Vault classification mined from the foreign key structure is standalone. From a modeling perspective, this suggests the table behaves as an independent entity rather than a pure dependent satellite or link, because its foreign keys point to reference and security entities (PER_COMPETENCES and FND_SECURITY_GROUPS) rather than to a tightly coupled parent hub within the Collections schema. The physical schema comprises 14 columns, of which the primary key is ISWS_PK, implemented on the WORK_SKILL_ID column.

Key Information Stored

The table's most significant columns are:

  • WORK_SKILL_ID — Surrogate primary key of the record, backed by the unique index and primary key constraint ISWS_PK. This is the business-key candidate documented as IEX_STRATEGY_WORK_SKILLS_U1.
  • WORK_ITEM_TEMP_ID — Identifier of the work item template in IEX_STRY_TEMP_WORK_ITEMS_B to which the skill requirement attaches. This is the primary linkage column for joining to work item template definitions.
  • COMPETENCE_ID — Foreign key to PER_COMPETENCES, identifying the specific competency or skill required for the work item template.
  • SECURITY_GROUP_ID — Foreign key to FND_SECURITY_GROUPS, enforcing multi-tenant security group isolation for the row.
  • OBJECT_VERSION_NUMBER — Optimistic locking column used by the Oracle Application Framework (OAF) and the EBS concurrent manager to detect concurrent updates.
  • CREATION_DATE, CREATED_BY — Standard WHO columns recording when and by whom the skill association was created.
  • LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — Standard WHO columns capturing the most recent modification audit trail.
  • PROGRAM_ID, PROGRAM_APPLICATION_ID, PROGRAM_UPDATE_DATE, REQUEST_ID — Concurrent program and request tracking columns that identify the batch process responsible for creating or updating the row.

The audit and program columns follow the standard EBS WHO convention and are essential for reconciliation and debugging batch-driven loads into the table.

Common Use Cases and Queries

Typical reporting and integration scenarios involve enumerating the skills required by each work item template, validating that templates have at least one competency assigned, and supporting competency-based assignment in the Collections work queue. A representative query lists all skills for a given work item template:

  • SELECT ws.work_skill_id, ws.work_item_temp_id, c.competence, ws.creation_date FROM iex.iex_strategy_work_skills ws, per.per_competences c WHERE ws.competence_id = c.competence_id AND ws.work_item_temp_id = :template_id;
  • Audit query isolating rows created by a specific concurrent request by filtering on PROGRAM_ID or REQUEST_ID.
  • Security query restricting results by SECURITY_GROUP_ID to enforce operating unit or security profile constraints.
  • Change-detection query comparing LAST_UPDATE_DATE against a high-water mark for incremental extracts into a data warehouse.

Related Objects

Based on the documented foreign key relationships and the natural parent-child linkage, the following objects are most significant:

  • PER_PER_COMPETENCES — Referenced by COMPETENCE_ID; provides the competency description used when presenting skill requirements.
  • FND_SECURITY_GROUPS — Referenced by SECURITY_GROUP_ID; governs security isolation of the skill row.
  • IEX_STRY_TEMP_WORK_ITEMS_B — Parent work item template definition, joined on WORK_ITEM_TEMP_ID.
  • IEX_WORK_ITEMS — Runtime work items generated from templates, indirectly dependent on the skill set defined here.
  • IEX_STRATEGIES — Collection strategies that drive work item generation and therefore influence which skills are required.
  • IEX_ASSIGNMENTS / IEX_STRATEGY_ASSIGNMENTS — Assignment processes that consume skill requirements to route work to collectors.

Together these objects form the competency-to-work-item chain that underpins Collections strategy execution and collector assignment.