Search Results xdp_wf_process_coord




Overview
Explore in AI Chat

Overview

The XDP_WF_PROCESS_COORD table is a Provisioning module (XDP) data object within the Oracle E-Business Suite 12.1.1 / 12.2.2 environment. Its documented purpose is workflow process coordination, meaning it tracks the coordination state associated with Oracle Workflow activities that drive provisioning transactions — for example, the asynchronous handoff between a parent workflow process and a child process invoked during service or subscription provisioning.

The table resides in the XDP schema and is classified as VALID. It contains 12 documented columns and is accessed through the primary key constraint XDP_WF_PROCESS_COORD_PK, defined on the column WF_COORDINATION_ID.

The ETRM metadata records a heuristic Data Vault classification of standalone for this object, mined from its foreign key structure. In Data Vault modeling terms, this suggests the table behaves more like a reference or hub-style entity with a single dependent reference (to security groups) rather than participating in a dense web of foreign key relationships. This classification should be treated as a modeling suggestion rather than an authoritative architectural designation.

Key Information Stored

The following columns are the most significant for understanding and querying this table:

  • WF_COORDINATION_ID — The surrogate primary key, defined by constraint XDP_WF_PROCESS_COORD_PK. It is also the sole documented unique index (XDP_WF_PROCESS_COORD_U1), making it the business-key candidate as well. All joins to this table should resolve through this column.
  • WF_ITEM_TYPE and WF_ITEM_KEY — The Workflow item type and item key identifying the specific workflow instance whose coordination is being tracked. Together these two columns point to the standard WF_ITEMS structure.
  • WF_ACTIVITY_NAME — The name of the workflow activity for which coordination state is recorded.
  • CHILD_PROCESS_NUM — The process number of the child process spawned from or coordinated with the parent workflow.
  • CALLBACK — The callback specification used to resume or notify the coordinating process once the child activity completes.
  • CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — The standard EBS audit columns recording insert and update provenance.
  • SECURITY_GROUP_ID — The security group (operating unit / data partition) to which the record belongs. This is the only documented foreign key, referencing FND_SECURITY_GROUPS.

Common Use Cases and Queries

Typical scenarios include diagnosing stalled provisioning workflows, auditing which child processes were launched for a given workflow instance, and reporting on workflow coordination activity by security group.

  • Locate coordination rows for a specific workflow instance:
    SELECT * FROM xdp.xdp_wf_process_coord WHERE wf_item_type = :p_item_type AND wf_item_key = :p_item_key;
  • Find rows by activity and child process:
    SELECT wf_coordination_id, wf_activity_name, child_process_num, callback, creation_date FROM xdp.xdp_wf_process_coord WHERE wf_activity_name = :p_activity;
  • Join to security groups for partitioned reporting:
    SELECT c.wf_coordination_id, c.wf_item_key, g.security_group_name FROM xdp.xdp_wf_process_coord c, fnd_security_groups g WHERE c.security_group_id = g.security_group_id;
  • Recent activity audit: order by CREATION_DATE or LAST_UPDATE_DATE to identify newly coordinated processes.

Related Objects

  • FND_SECURITY_GROUPS — Joined via SECURITY_GROUP_ID; the only documented foreign key target.
  • WF_ITEMS — The standard Oracle Workflow items table, joined on WF_ITEM_TYPE and WF_ITEM_KEY, providing workflow instance detail.
  • WF_ITEM_ACTIVITY_STATUSES — Supplies activity state for the referenced workflow items.
  • WF_PROCESS_ACTIVITIES — Defines process/activity structure supporting CHILD_PROCESS_NUM interpretation.
  • XDP_WF_PROCESS_COORD_PK / XDP_WF_PROCESS_COORD_U1 — The primary key and unique index constraints governing WF_COORDINATION_ID.