Search Results xdp_wi_fa_mapping




Overview
Explore in AI Chat

Overview

The XDP_WI_FA_MAPPING table is a core data object within the Oracle E-Business Suite Provisioning (XDP) module. It functions as a junction or mapping table that defines the specific sequence and relationship between work items and fulfillment actions. Its primary role is to orchestrate the fulfillment process by storing the list of automated fulfillment actions that must be executed, and in the correct order, to successfully complete a given work item. This table is essential for the automated service provisioning workflows in Oracle EBS, enabling the system to translate a work item, which represents a unit of provisioning work, into a series of concrete, executable tasks.

Key Information Stored

The table's structure is designed to manage the workflow linkage. While the full column list is not detailed in the provided metadata, the documented foreign keys and primary key reveal the critical data points. The primary key, WI_FA_MAPPING_ID, uniquely identifies each mapping record. The two fundamental foreign key columns establish the core relationships: WORKITEM_ID links to a specific record in the XDP_WORKITEMS table, and FULFILLMENT_ACTION_ID links to a defined action in the XDP_FULFILL_ACTIONS table. Additional columns likely exist to manage the execution order (e.g., a sequence number), execution status, and parameters for the action within the context of that specific work item.

Common Use Cases and Queries

This table is central to querying the fulfillment plan for any work item. A common operational use case is to generate a report or dashboard showing all pending actions for active work items. Support and development teams frequently query this table to diagnose provisioning failures by examining the mapped actions and their states. A typical SQL pattern retrieves the action details for a specific work item:

  • SELECT fa.ACTION_NAME, fa.ACTION_TYPE, wifm.* FROM XDP_WI_FA_MAPPING wifm, XDP_FULFILL_ACTIONS fa WHERE wifm.WORKITEM_ID = :p_workitem_id AND wifm.FULFILLMENT_ACTION_ID = fa.FULFILLMENT_ACTION_ID ORDER BY wifm.EXECUTION_SEQUENCE;

Another critical use case is during the design and configuration of provisioning workflows, where administrators define which actions map to which types of work items, with inserts and updates performed via the standard XDP APIs.

Related Objects

The XDP_WI_FA_MAPPING table sits at the intersection of key provisioning entities, as evidenced by its foreign key relationships.

  • References (Parent Tables):
    • XDP_WORKITEMS: Via the XDP_WI_FA_MAPPING.WORKITEM_ID column. This links the mapping to the specific unit of work being processed.
    • XDP_FULFILL_ACTIONS: Via the XDP_WI_FA_MAPPING.FULFILLMENT_ACTION_ID column. This links the mapping to the definition of the executable action.
  • Referenced By (Child Table):
    • XDP_WI_FA_MAPPING_TL: Via the XDP_WI_FA_MAPPING_TL.WI_FA_MAPPING_ID column. This is the Translation table that stores multilingual descriptions for the mapping records.