Results for “ieu_uwqm_ws_assct_props”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

The IEU_UWQM_WS_ASSCT_PROPS table is a core configuration object within the IEU (Universal Work Queue) module of Oracle E-Business Suite Release 12.1.1 and 12.2.2. Its documented description, "UWQ Work Source Association Properties," identifies it as the repository that stores the behavioral properties, distribution rules, and parent-child relationships applied to work source associations. In operational terms, the table governs how the Universal Work Queue routes, groups, and presents work items to agents based on the way individual work sources are associated with one another, and it determines whether distribution of a given work source is driven by its parent's assignment logic.

The ETRM metadata classifies this object heuristically as a standalone entity within a Data Vault modeling context. The absence of child links or dependent satellite relationships suggests that the table functions as an autonomous configuration store rather than a transactional junction. Practitioners modeling this data should treat IEU_UWQM_WS_ASSCT_PROPS as a reference or configuration hub whose rows are maintained through UWQ setup rather than through high-volume runtime inserts.

Key Information Stored

The documented physical schema contains 14 columns. The surrogate primary key is WS_ASSOCIATION_PROP_ID, enforced by the constraint IEU_UWQM_WS_ASSCT_PROPS_PK. The table also carries the standard EBS WHO columns — CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, and LAST_UPDATE_LOGIN — plus OBJECT_VERSION_NUMBER for optimistic locking in the 12.2.2 online runtime. The business-key candidate documented through the unique index IEU_UWQM_WS_ASSCT_PROPS_U1 is the combination of WS_ASSOCIATION_PROP_ID and ZD_EDITION_NAME, which reflects the Edition-Based Redefinition architecture introduced in 12.2.2.

• WS_ID — identifies the work source whose association properties are defined; foreign key to IEU_UWQM_WORK_SOURCES_B.
• PARENT_WS_ID — the parent work source in the association hierarchy.
• CHILD_WS_ID — the child work source subordinate to the parent for routing and grouping purposes.
• DIST_ST_BASED_ON_PARENT_FLAG — controls whether distribution status is derived from the parent work source's assignment rather than computed independently.
• TASKS_RULES_FUNCTION — names the PL/SQL function or rule invoked to evaluate task criteria for the association.
• SECURITY_GROUP_ID — foreign key to FND_SECURITY_GROUPS supporting multi-org security filtering.
• ZD_EDITION_NAME — the edition discriminator supporting online patching in 12.2.2.

Common Use Cases and Queries

Typical usage centers on diagnosing why work items appear in a particular agent's queue, validating association setup after a work source configuration change, and auditing distribution behavior across parent-child hierarchies. A common query resolves the properties for a given work source:

• SELECT p.ws_association_prop_id, p.ws_id, p.parent_ws_id, p.child_ws_id, p.dist_st_based_on_parent_flag, p.tasks_rules_function FROM ieu.ieu_uwqm_ws_assct_props p WHERE p.ws_id = :work_source_id;
• Join to IEU_UWQM_WORK_SOURCES_B on WS_ID to obtain the work source name and display label for reporting.
• Filter by SECURITY_GROUP_ID in multi-org environments to restrict results to the operating unit context.
• In 12.2.2, restrict to the active edition using ZD_EDITION_NAME in the WHERE clause to avoid reading stale patched rows.

Related Objects

The FK metadata identifies the primary dependencies of this table. Significant related objects include:

• IEU_UWQM_WORK_SOURCES_B — referenced through WS_ID; the master definition of each work source.
• FND_SECURITY_GROUPS — referenced through SECURITY_GROUP_ID; governs security group scoping.
• IEU_UWQM_WS_ASSCT_PROPS_PK and IEU_UWQM_WS_ASSCT_PROPS_U1 — the primary key and unique index constraints defined on the table.
• Sibling UWQ configuration tables within the IEU schema that store work source definitions, filters, and column assignments used alongside this table during queue setup.

Direct DML should generally be avoided in favor of the UWQ setup forms, since misconfigured association properties directly affect agent queue contents and work distribution.