Search Results xdp_workitems




Overview
Explore in AI Chat

Overview

The XDP_WORKITEMS table is a core data object within the Oracle E-Business Suite Provisioning (XDP) module, central to the order fulfillment and service activation framework. It serves as the master definition table for work items, which are the fundamental, executable units of work that orchestrate the provisioning process. Each record in this table defines a specific task—such as configuring a router, activating a port, or assigning an IP address—that must be completed to fulfill a customer order. The table's structure supports versioning, allowing for the lifecycle management of work item definitions, and integrates with the Oracle Workflow engine to enable automated execution and complex process flows.

Key Information Stored

The table's primary identifier is the WORKITEM_ID, a system-generated unique key. A critical business key is the combination of WORKITEM_NAME and VERSION, which uniquely identifies a specific release of a work item definition. Other significant columns, inferred from the foreign key relationships, include FA_EXEC_MAP_PROC and WF_EXEC_PROC. These columns store references to stored procedures (defined in the XDP_PROC_BODY table) that contain the business logic for fulfillment adapter execution and workflow-driven execution, respectively. This design separates the work item's metadata from its executable code, providing flexibility and maintainability.

Common Use Cases and Queries

This table is primarily accessed for configuration, operational reporting, and troubleshooting within the provisioning lifecycle. Common scenarios include identifying all active versions of work items, tracing which work items are assigned to specific order lines, and diagnosing fulfillment errors by examining work item definitions. A typical query retrieves work items linked to a particular service or order:

  • Find Work Items for an Order Line: SELECT wi.WORKITEM_NAME, wi.VERSION FROM XDP_WORKITEMS wi, XDP_ORDER_LINE_ITEMS oli WHERE oli.ORDER_LINE_ID = <LINE_ID> AND oli.WORKITEM_ID = wi.WORKITEM_ID;
  • List Latest Version of All Work Items: SELECT WORKITEM_NAME, MAX(VERSION) FROM XDP_WORKITEMS GROUP BY WORKITEM_NAME;
  • Audit Work Item Parameters: Joining with XDP_WI_PARAMETERS to list all input and output parameters defined for a work item.

Related Objects

XDP_WORKITEMS sits at the center of a robust relational schema. Its primary key is referenced by numerous child tables that define its behavior and usage:

  • XDP_WORKITEMS_TL: Provides translated descriptions for multilingual support.
  • XDP_WI_PARAMETERS: Defines the input and output parameters for the work item.
  • XDP_ORDER_LINE_ITEMS & XDP_FULFILL_WORKLIST: Link work items to sales orders and the operational worklist for technicians.
  • XDP_SERVICE_WI_MAP & XNS_ACTION_WI_MAPPING: Map work items to specific services and notification actions.
  • XDP_WI_FA_MAPPING: Associates work items with specific Fulfillment Adapters.
  • XDP_PROC_BODY (Foreign Key Reference): Contains the PL/SQL procedure code referenced by the FA_EXEC_MAP_PROC and WF_EXEC_PROC columns.
  • Table: XDP_WORKITEMS 12.1.1

    owner:XDP,  object_type:TABLE,  fnd_design_data:XDP.XDP_WORKITEMS,  object_name:XDP_WORKITEMS,  status:VALID,  product: XDP - Provisioning ,  description: XDP_WORKITEMS is used to define a work item ,  implementation_dba_data: XDP.XDP_WORKITEMS , 

  • Table: XDP_WORKITEMS 12.2.2

    owner:XDP,  object_type:TABLE,  fnd_design_data:XDP.XDP_WORKITEMS,  object_name:XDP_WORKITEMS,  status:VALID,  product: XDP - Provisioning ,  description: XDP_WORKITEMS is used to define a work item ,  implementation_dba_data: XDP.XDP_WORKITEMS , 

  • Table: XDP_WORKITEMS_TL 12.1.1

    owner:XDP,  object_type:TABLE,  fnd_design_data:XDP.XDP_WORKITEMS_TL,  object_name:XDP_WORKITEMS_TL,  status:VALID,  product: XDP - Provisioning ,  description: XDP_WORKITEMS_TL is the MLS table (Multi-Language Support) for the XDP_WORKITEMS table ,  implementation_dba_data: XDP.XDP_WORKITEMS_TL , 

  • Table: XDP_WI_PARAMETERS 12.2.2

    owner:XDP,  object_type:TABLE,  fnd_design_data:XDP.XDP_WI_PARAMETERS,  object_name:XDP_WI_PARAMETERS,  status:VALID,  product: XDP - Provisioning ,  description: XDP_WI_PARAMETERS holds all the work item parameters and associated properties for a given work item ,  implementation_dba_data: XDP.XDP_WI_PARAMETERS , 

  • Table: XDP_WORKITEMS_TL 12.2.2

    owner:XDP,  object_type:TABLE,  fnd_design_data:XDP.XDP_WORKITEMS_TL,  object_name:XDP_WORKITEMS_TL,  status:VALID,  product: XDP - Provisioning ,  description: XDP_WORKITEMS_TL is the MLS table (Multi-Language Support) for the XDP_WORKITEMS table ,  implementation_dba_data: XDP.XDP_WORKITEMS_TL , 

  • Table: XDP_WI_PARAMETERS 12.1.1

    owner:XDP,  object_type:TABLE,  fnd_design_data:XDP.XDP_WI_PARAMETERS,  object_name:XDP_WI_PARAMETERS,  status:VALID,  product: XDP - Provisioning ,  description: XDP_WI_PARAMETERS holds all the work item parameters and associated properties for a given work item ,  implementation_dba_data: XDP.XDP_WI_PARAMETERS , 

  • Table: XDP_PROC_BODY 12.2.2

    owner:XDP,  object_type:TABLE,  fnd_design_data:XDP.XDP_PROC_BODY,  object_name:XDP_PROC_BODY,  status:VALID,  product: XDP - Provisioning ,  description: XDP_PROC_BODY stores the source of all the user defined procedures ,  implementation_dba_data: XDP.XDP_PROC_BODY , 

  • Table: XDP_PROC_BODY 12.1.1

    owner:XDP,  object_type:TABLE,  fnd_design_data:XDP.XDP_PROC_BODY,  object_name:XDP_PROC_BODY,  status:VALID,  product: XDP - Provisioning ,  description: XDP_PROC_BODY stores the source of all the user defined procedures ,  implementation_dba_data: XDP.XDP_PROC_BODY , 

  • Table: XDP_WI_FA_MAPPING 12.1.1

    owner:XDP,  object_type:TABLE,  fnd_design_data:XDP.XDP_WI_FA_MAPPING,  object_name:XDP_WI_FA_MAPPING,  status:VALID,  product: XDP - Provisioning ,  description: XDP_WI_FA_MAPPING defines the list of fulfillment actions to be excuted in order to fulfill a work item ,  implementation_dba_data: XDP.XDP_WI_FA_MAPPING , 

  • Table: XDP_WI_FA_MAPPING 12.2.2

    owner:XDP,  object_type:TABLE,  fnd_design_data:XDP.XDP_WI_FA_MAPPING,  object_name:XDP_WI_FA_MAPPING,  status:VALID,  product: XDP - Provisioning ,  description: XDP_WI_FA_MAPPING defines the list of fulfillment actions to be excuted in order to fulfill a work item ,  implementation_dba_data: XDP.XDP_WI_FA_MAPPING , 

  • Table: XDP_SERVICE_WI_MAP 12.1.1

    owner:XDP,  object_type:TABLE,  fnd_design_data:XDP.XDP_SERVICE_WI_MAP,  object_name:XDP_SERVICE_WI_MAP,  status:VALID,  product: XDP - Provisioning ,  description: XDP_SERVICE_WI_MAP is used to define the list of work items that need to be executed to fulfill the given service action ,  implementation_dba_data: XDP.XDP_SERVICE_WI_MAP , 

  • Table: XDP_SERVICE_WI_MAP 12.2.2

    owner:XDP,  object_type:TABLE,  fnd_design_data:XDP.XDP_SERVICE_WI_MAP,  object_name:XDP_SERVICE_WI_MAP,  status:VALID,  product: XDP - Provisioning ,  description: XDP_SERVICE_WI_MAP is used to define the list of work items that need to be executed to fulfill the given service action ,  implementation_dba_data: XDP.XDP_SERVICE_WI_MAP , 

  • Table: XDP_ORDER_LINE_ITEMS 12.1.1

    owner:XDP,  object_type:TABLE,  fnd_design_data:XDP.XDP_ORDER_LINE_ITEMS,  object_name:XDP_ORDER_LINE_ITEMS,  status:VALID,  product: XDP - Provisioning ,  description: Order Line Items ,  implementation_dba_data: XDP.XDP_ORDER_LINE_ITEMS , 

  • Table: XDP_ORDER_LINE_ITEMS 12.2.2

    owner:XDP,  object_type:TABLE,  fnd_design_data:XDP.XDP_ORDER_LINE_ITEMS,  object_name:XDP_ORDER_LINE_ITEMS,  status:VALID,  product: XDP - Provisioning ,  description: Order Line Items ,  implementation_dba_data: XDP.XDP_ORDER_LINE_ITEMS , 

  • 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 , 

  • View: XDP_SVE_WI_MAPPING_DISP_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:XDP.XDP_SVE_WI_MAPPING_DISP_V,  object_name:XDP_SVE_WI_MAPPING_DISP_V,  status:VALID,  product: XDP - Provisioning ,  description: The view XDP_SERVICE_WI_MAPPING_DISP_V is used define the list of workitem which need to be executed to fulfill the given service sales action. ,  implementation_dba_data: APPS.XDP_SVE_WI_MAPPING_DISP_V , 

  • View: XDP_SVE_WI_MAPPING_DISP_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:XDP.XDP_SVE_WI_MAPPING_DISP_V,  object_name:XDP_SVE_WI_MAPPING_DISP_V,  status:VALID,  product: XDP - Provisioning ,  description: The view XDP_SERVICE_WI_MAPPING_DISP_V is used define the list of workitem which need to be executed to fulfill the given service sales action. ,  implementation_dba_data: APPS.XDP_SVE_WI_MAPPING_DISP_V , 

  • View: XDP_WORKITEMS_VL 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:XDP.XDP_WORKITEMS_VL,  object_name:XDP_WORKITEMS_VL,  status:VALID,  product: XDP - Provisioning ,  description: The view XDP_WORKITEMS_VL is used to define an SFM workitem. An SFM workitem can be viewed as a job to fulfill a service offering/sales action. A typical workitem will consist of a list of fulfillment actions to be executed. The WI_TYP ,  implementation_dba_data: APPS.XDP_WORKITEMS_VL , 

  • View: XDP_WORKITEMS_VL 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:XDP.XDP_WORKITEMS_VL,  object_name:XDP_WORKITEMS_VL,  status:VALID,  product: XDP - Provisioning ,  description: The view XDP_WORKITEMS_VL is used to define an SFM workitem. An SFM workitem can be viewed as a job to fulfill a service offering/sales action. A typical workitem will consist of a list of fulfillment actions to be executed. The WI_TYP ,  implementation_dba_data: APPS.XDP_WORKITEMS_VL , 

  • View: XDP_ORDER_DETAILS_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:XDP.XDP_ORDER_DETAILS_V,  object_name:XDP_ORDER_DETAILS_V,  status:VALID,  product: XDP - Provisioning ,  description: This view contains an order details such as line items, work items, services and packages. ,  implementation_dba_data: APPS.XDP_ORDER_DETAILS_V , 

  • View: XDP_ORDER_DETAILS_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:XDP.XDP_ORDER_DETAILS_V,  object_name:XDP_ORDER_DETAILS_V,  status:VALID,  product: XDP - Provisioning ,  description: This view contains an order details such as line items, work items, services and packages. ,  implementation_dba_data: APPS.XDP_ORDER_DETAILS_V ,