Results for “execution_time”

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

Overview

WF_ITEM_ACTIVITY_STATUSES_H is an APPLSYS-owned table within the FND – Application Object Library product of Oracle E-Business Suite. It stores the historical audit trail of workflow activity transitions recorded in WF_ITEM_ACTIVITY_STATUSES. Every time an activity within a running workflow item changes status — from notification delivery through completion, error, or deferral — the prior or resulting state is preserved in this history table. The table is therefore essential for reconstructing the timeline of a workflow process instance after the fact, including root-cause analysis of stalled, errored, or reassigned activities.

The documented ETRM metadata classifies this object heuristically as a link in Data Vault modeling terms. This is consistent with its role as an associative record joining workflow items, process activities, and notifications through a set of foreign keys. The table carries 19 documented columns and is defined with referential integrity to WF_ITEMS, WF_PROCESS_ACTIVITIES, WF_NOTIFICATIONS, and FND_SECURITY_GROUPS.

Key Information Stored

The most significant columns and their semantics follow. Note that the documented ETRM metadata does not expose a named surrogate primary key for this table; the business-key candidate is the composite of the workflow instance identifier together with the activity and status timing.

• ITEM_TYPE and ITEM_KEY — the workflow item identity. Foreign key to WF_ITEMS, jointly identifying the runtime instance.
• PROCESS_ACTIVITY — the activity node instance within the process definition. Foreign key to WF_PROCESS_ACTIVITIES.
• ACTIVITY_STATUS — the state of the activity at the point recorded (for example ACTIVE, COMPLETE, ERROR, DEFERRED).
• ACTIVITY_RESULT_CODE — the outcome code produced by the activity, used to drive subsequent transitions.
• NOTIFICATION_ID — foreign key to WF_NOTIFICATIONS; identifies the notification associated with the activity step.
• ASSIGNED_USER and PERFORMED_BY — the user to whom the activity was assigned versus the user who actually acted on it.
• BEGIN_DATE and END_DATE — the open and close timestamps of the status interval, used to derive duration and SLA adherence.
• EXECUTION_TIME — the measured elapsed time for the activity execution.
• DUE_DATE — the deadline associated with the activity, supporting overdue reporting.
• ERROR_NAME, ERROR_MESSAGE, and ERROR_STACK — diagnostic details captured when an activity transitions to ERROR.
• OUTBOUND_QUEUE_ID — identifies the business event or agent outbound queue entry generated by the activity.
• ACTION — the action performed by the user on the notification.
• SECURITY_GROUP_ID — foreign key to FND_SECURITY_GROUPS, controlling multi-tenant data access.
• INST_ID — the instance identifier used in multi-organization or OAM partitioning scenarios.

Common Use Cases and Queries

Typical uses include workflow duration analytics, error triage, and audit reporting. A representative query joins the history to the live status table and to notifications to reproduce the timeline of a specific order or requisition approval.

• Identify activities in error for a given period:
  SELECT item_type, item_key, process_activity, error_name, error_message FROM wf_item_activity_statuses_h WHERE activity_status = 'ERROR' AND end_date >= :from_date;
• Measure activity cycle time:
  SELECT process_activity, AVG(end_date - begin_date) avg_duration FROM wf_item_activity_statuses_h GROUP BY process_activity;
• Reconstruct the full history of a process instance using ITEM_TYPE and ITEM_KEY, ordered by BEGIN_DATE.
• Report notifications awaiting action by joining NOTIFICATION_ID to WF_NOTIFICATIONS and filtering on open statuses.

Related Objects

The following objects are most significant to this table, based on the documented foreign keys:

• WF_ITEMS — joined on ITEM_TYPE and ITEM_KEY; the parent workflow instance.
• WF_PROCESS_ACTIVITIES — joined on PROCESS_ACTIVITY; the activity node definition and runtime instance.
• WF_NOTIFICATIONS — joined on NOTIFICATION_ID; the notification generated by the activity.
• FND_SECURITY_GROUPS — joined on SECURITY_GROUP_ID; enforces data security.
• WF_ITEM_ACTIVITY_STATUSES — the current (non-history) counterpart table, the source from which this history is populated.
• WF_NOTIFICATION_ATTRIBUTES and WF_COMMENTS — related workflow tables frequently used alongside the history for contextual reporting.

Because the history rows preserve the state of a workflow at each transition, WF_ITEM_ACTIVITY_STATUSES_H should be treated as the authoritative audit record for workflow activity behavior in Oracle EBS 12.1.1 and 12.2.2.