Search Results xdp_wi_relationships




Overview
Explore in AI Chat

Overview

The XDP_WI_RELATIONSHIPS table is a core data object within the Oracle E-Business Suite Provisioning (XDP) module, present in both releases 12.1.1 and 12.2.2. It functions as the central repository for defining and storing all dependency and association links between work items that constitute a fulfillment order. In the context of XDP's order orchestration engine, a single customer order is decomposed into a set of discrete, executable work items. This table is essential for modeling the complex workflow relationships between these items, such as prerequisites, successors, and parallel execution paths, thereby enabling the system to correctly sequence and manage the order fulfillment lifecycle.

Key Information Stored

The table's structure is intentionally focused on defining the relationship itself, with its two primary columns forming a composite primary key. The WORKITEM_INSTANCE_ID column stores the unique identifier for the primary work item. The RELATED_WI_INSTANCE_ID column stores the unique identifier for a work item that has a defined relationship to the primary one. The combination of these two IDs defines a specific, unique link. The table does not inherently store metadata about the relationship type (e.g., "depends-on," "child-of") within its core columns; such logic is typically managed by the application layer. The integrity of the data is enforced by foreign key constraints, ensuring both ID values correspond to valid records in the worklist master table.

Common Use Cases and Queries

The primary use case is navigating the work item dependency graph during order processing. The Provisioning engine queries this table to determine which work items are eligible for execution based on the completion status of their related predecessors. Common reporting and diagnostic queries include identifying all dependencies for a specific work item or finding all work items that are blocked waiting on another. A fundamental SQL pattern is a self-join or subquery against the XDP_FULFILL_WORKLIST table to resolve the work item IDs to their business data.

Sample Query: Find all related work items for a given instance.
SELECT related_wi_instance_id
FROM xdp_wi_relationships
WHERE workitem_instance_id = :wi_instance;

Sample Query: Resolve related work item details.
SELECT r.*, wf.wi_name, wf.wi_status
FROM xdp_wi_relationships r,
xdp_fulfill_worklist wf
WHERE r.workitem_instance_id = :wi_instance
AND r.related_wi_instance_id = wf.workitem_instance_id;

Related Objects

The table has a direct and exclusive relationship with the XDP_FULFILL_WORKLIST table, which is the master list of all work item instances. Two foreign key constraints enforce this relationship, linking each column in XDP_WI_RELATIONSHIPS to the primary key of XDP_FULFILL_WORKLIST. Specifically:

  • The column XDP_WI_RELATIONSHIPS.WORKITEM_INSTANCE_ID references XDP_FULFILL_WORKLIST.
  • The column XDP_WI_RELATIONSHIPS.RELATED_WI_INSTANCE_ID references XDP_FULFILL_WORKLIST.

This design ensures referential integrity, meaning every relationship recorded must point to two valid, existing work items. The table's primary key constraint, XDP_WI_RELATIONSHIPS_PK, prevents the storage of duplicate relationship entries between the same pair of work items.

  • Table: XDP_WI_RELATIONSHIPS 12.1.1

    owner:XDP,  object_type:TABLE,  fnd_design_data:XDP.XDP_WI_RELATIONSHIPS,  object_name:XDP_WI_RELATIONSHIPS,  status:VALID,  product: XDP - Provisioning ,  description: The table XDP_WI_RELATIONSHIPS hold all the relationships of any work item within an order. ,  implementation_dba_data: XDP.XDP_WI_RELATIONSHIPS , 

  • Table: XDP_WI_RELATIONSHIPS 12.2.2

    owner:XDP,  object_type:TABLE,  fnd_design_data:XDP.XDP_WI_RELATIONSHIPS,  object_name:XDP_WI_RELATIONSHIPS,  status:VALID,  product: XDP - Provisioning ,  description: The table XDP_WI_RELATIONSHIPS hold all the relationships of any work item within an order. ,  implementation_dba_data: XDP.XDP_WI_RELATIONSHIPS , 

  • Table: XDP_FULFILL_WORKLIST 12.1.1

    owner:XDP,  object_type:TABLE,  fnd_design_data:XDP.XDP_FULFILL_WORKLIST,  object_name:XDP_FULFILL_WORKLIST,  status:VALID,  product: XDP - Provisioning ,  description: This table identifies a list of services that need to be fulfilled for the given order ,  implementation_dba_data: XDP.XDP_FULFILL_WORKLIST , 

  • Table: XDP_FULFILL_WORKLIST 12.2.2

    owner:XDP,  object_type:TABLE,  fnd_design_data:XDP.XDP_FULFILL_WORKLIST,  object_name:XDP_FULFILL_WORKLIST,  status:VALID,  product: XDP - Provisioning ,  description: This table identifies a list of services that need to be fulfilled for the given order ,  implementation_dba_data: XDP.XDP_FULFILL_WORKLIST ,