Search Results ieu_uwqm_audit_log




Overview
Explore in AI Chat

Overview

The IEU_UWQM_AUDIT_LOG table is a core auditing structure within the Oracle E-Business Suite Universal Work Queue (IEU) module. It records the audit trail produced by the Universal Work Queue Manager (UWQM) whenever work items are distributed, reassigned, rescheduled, or otherwise modified as they flow through the queue. The table is owned by the IEU schema, is documented as VALID in release 12.1.1 and 12.2.2, and carries the description "Work Distribution Audit Log." It captures before-and-after snapshots of work item attributes so that administrators and support personnel can reconstruct exactly how a work item changed, when, and under what conditions.

Based on the heuristic Data Vault classification mined from its foreign key structure, this object is a standalone table rather than a strict hub, link, or satellite. In practice, its two outbound foreign keys — to IBC_AUDIT_LOGS and FND_SECURITY_GROUPS — make it behave more like a satellite or link table anchored to the audit and security-group domains. The modeling suggestion is therefore to treat IEU_UWQM_AUDIT_LOG as a transactional audit satellite that hangs off the broader audit infrastructure rather than as an independent dimension.

Key Information Stored

The table comprises 55 documented columns. The surrogate primary key is AUDIT_LOG_ID, which is also the sole business-key candidate, enforced by the unique index IEU_UWQM_AUDIT_LOG_U1. The foreign keys AUDIT_LOG_ID (to IBC_AUDIT_LOGS) and SECURITY_GROUP_ID (to FND_SECURITY_GROUPS) tie each row to its parent audit record and to the security group under which the audited activity occurred.

Among the most important columns are:

Standard audit columns are also present: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, and LAST_UPDATE_LOGIN.

Common Use Cases and Queries

The primary use case is forensic analysis of work distribution behavior. Because every row preserves _CURR and _PREV pairs, administrators can reconstruct the exact reassignment history of a work item, measure the elapsed time between status transitions, and validate routing rules after changes to the work-queue configuration. Support teams use it to trace why a work item was assigned to a particular resource or why it was rescheduled, while compliance and SOX-driven audit reports rely on it to demonstrate who changed which work item and when.

A typical query reconstructing the latest reassignments for a security group is:

  • SELECT l.WORK_ITEM_NUMBER, l.ACTION_KEY, l.ASSIGNEE_ID_PREV, l.ASSIGNEE_ID_CURR, l.WORKITEM_STATUS_ID_PREV, l.WORKITEM_STATUS_ID_CURR, l.LAST_UPDATE_DATE FROM IEU.IEU_UWQM_AUDIT_LOG l WHERE l.SECURITY_GROUP_ID = :sg_id AND l.EVENT_KEY = :evt ORDER BY l.LAST_UPDATE_DATE DESC;
  • Joining to IBC_AUDIT_LOGS on AUDIT_LOG_ID to obtain the parent audit header details.
  • Aggregating by ACTION_KEY to produce counts of reassignments, reschedules, and status changes over a reporting period, typically filtered by LAST_UPDATE_DATE for incremental reporting.
  • Filtering on RETURN_STATUS or ERROR_CODE = 'E' to isolate failed work-distribution attempts for troubleshooting.

Typical reports include work distribution audit trails, reassignment frequency reports, and error-analysis extracts for UWQM processing.

Related Objects

The most significant objects related to IEU_UWQM_AUDIT_LOG are derived from its foreign keys and the Universal Work Queue domain:

  • IBC_AUDIT_LOGS — parent audit header referenced by IEU_UWQM_AUDIT_LOG.AUDIT_LOG_ID; provides the general audit context for each row.
  • FND_SECURITY_GROUPS — referenced by SECURITY_GROUP_ID; scopes visibility of the audit rows.
  • IEU_UWQ_WORK_ITEMS (and the broader UWQ work-item structures) — provide current work-item state to compare against the _CURR/_PREV snapshots.
  • IEU_UWQ_ROUTING_RULES — defines the routing logic whose execution produced each audited action.
  • IEU_UWQ_ASSIGNMENTS — holds current assignee data that the audit log overrides via ASSIGNEE_ID_PREV/CURR and ASSIGNEE_TYPE_PREV/CURR.
  • FND_USER and FND_APPLICATION — resolve CREATED_BY, LAST_UPDATED_BY, and APPLICATION_ID values.

Together these objects support the audit, diagnostic, and reporting workflows centered on UWQM processing in the IEU module.