Search Results xdp_service_wi_map_pk




Overview
Explore in AI Chat

Overview

The XDP_SERVICE_WI_MAP table is a core data object within the Oracle E-Business Suite Provisioning (XDP) module. It functions as a mapping table that defines the specific sequence of work items required to fulfill a given service action. This table is essential for orchestrating the automated provisioning workflow, acting as the central repository that links high-level service definitions to the granular, executable tasks (work items) that implement them. Its role is to ensure that when a service order is processed, the correct set of technical steps is executed in the defined order to activate or modify a service.

Key Information Stored

The table's primary purpose is to store mapping relationships. Its key columns include the primary key SERVICE_WI_MAP_ID, which uniquely identifies each mapping record. The critical foreign key columns define the relationships: SERVICE_VAL_ACT_ID links to a specific service validation action in the XDP_SERVICE_VAL_ACTS table, and WORKITEM_ID links to a specific executable task defined in the XDP_WORKITEMS table. Additional columns typically manage the mapping's sequence order, effective dates, and creation metadata, allowing administrators to control the precise flow and timing of work item execution for each service action.

Common Use Cases and Queries

This table is central to provisioning configuration and troubleshooting. A common use case is reviewing or modifying the workflow for a service. Administrators query this table to list all work items associated with a service action. A typical SQL pattern joins XDP_SERVICE_WI_MAP to XDP_SERVICE_VAL_ACTS and XDP_WORKITEMS to get a readable list of service actions and their corresponding tasks. For reporting, queries against this table help analyze provisioning process completeness or identify which work items are most frequently invoked. Troubleshooting failed service orders often involves verifying that the correct mappings exist and are active in this table.

Related Objects

  • Primary Key: XDP_SERVICE_WI_MAP_PK on column SERVICE_WI_MAP_ID.
  • Foreign Keys (Referenced By):
    • XDP_SERVICE_WI_MAP.SERVICE_VAL_ACT_ID references XDP_SERVICE_VAL_ACTS.
    • XDP_SERVICE_WI_MAP.WORKITEM_ID references XDP_WORKITEMS.
  • Foreign Keys (Referencing This Table):
    • XDP_SERVICE_WI_MAP_TL.SERVICE_WI_MAP_ID references XDP_SERVICE_WI_MAP (providing translated descriptions).