Search Results xdp_wi_parameters




Overview
Explore in AI Chat

Overview

The XDP_WI_PARAMETERS table is a core data object within the Oracle E-Business Suite Provisioning (XDP) module. It functions as the central repository for all parameters and their associated metadata that are defined for a specific work item. A work item represents a discrete unit of provisioning or fulfillment activity. This table is critical for the dynamic and configurable nature of the XDP engine, as it stores the runtime parameters that control the behavior, data flow, and execution logic of each work item. Its integrity is maintained through defined primary and foreign key relationships with other fundamental XDP tables, ensuring data consistency across the provisioning workflow.

Key Information Stored

The table's primary key is a composite of WORKITEM_ID and PARAMETER_NAME, establishing a unique parameter definition for each work item. While the full column list is not detailed in the provided metadata, the documented foreign key relationships reveal several critical columns. The WORKITEM_ID column links the parameter to its parent work item in the XDP_WORKITEMS table. The PARAMETER_NAME column identifies the specific parameter. Importantly, the table includes columns for EVALUATION_PROCEDURE and VALIDATION_PROCEDURE, which store references to stored procedures (in the XDP_PROC_BODY table) used to calculate the parameter's value and validate it, respectively. This design allows for sophisticated, programmatically-driven parameter management within provisioning processes.

Common Use Cases and Queries

This table is primarily accessed for runtime execution and administrative reporting of work item configurations. A common operational use case is retrieving all parameters for a specific work item to drive a user interface or an automated process. A typical query would be: SELECT * FROM XDP.XDP_WI_PARAMETERS WHERE WORKITEM_ID = :workitem_id ORDER BY PARAMETER_NAME;. For troubleshooting or analysis, one might join with XDP_WORKITEMS to see parameters across work items for a specific service order or provisioning type: SELECT w.WORKITEM_NUMBER, p.* FROM XDP_WI_PARAMETERS p, XDP_WORKITEMS w WHERE p.WORKITEM_ID = w.WORKITEM_ID AND w.SERVICE_ID = :service_id;. Administrators may also query to audit which parameters use custom validation or evaluation logic by checking for non-NULL values in the respective procedure columns.

Related Objects

The XDP_WI_PARAMETERS table has integral relationships with other key XDP tables, as documented in the ETRM metadata.

  • Parent Tables (Foreign Key References From):
    • XDP_WORKITEMS: Via WORKITEM_ID. This is the primary parent table, defining the work item to which the parameters belong.
    • XDP_PROC_BODY: Via EVALUATION_PROCEDURE and VALIDATION_PROCEDURE columns. These links reference the stored procedures used for parameter logic.
  • Child Table (Foreign Key References To):
    • XDP_WORKLIST_DETAILS: References XDP_WI_PARAMETERS on the composite key (WORKITEM_ID, PARAMETER_NAME). This table likely stores instance-specific values for these parameters as assigned within a worklist.