Results for “wi_parameter_id”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

XDP_WORKLIST_DETAILS is a fulfillment worklist detail table owned by the XDP schema within the Oracle EBS Provisioning module. It stores the parameter-level details associated with each fulfillment worklist instance processed by the provisioning engine, linking a work item instance to the specific parameters it sourced, evaluated, and resolved during order fulfillment. In the context of the user's search for csi_i_extended_attribs, this table is the join path between provisioning worklist records and the CSI inventory extended attributes model, since it carries a foreign key via ATTRIB_SOURCE_ID to CSI_I_EXTENDED_ATTRIBS and CSI_IEA_VALUES.

From a Data Vault modeling perspective, XDP_WORKLIST_DETAILS is best classified heuristically as a link table. It resolves many-to-many relationships between worklist instances, work item parameters, and CSI attribute sources, rather than representing a single business entity or a descriptive satellite of change history.

Key Information Stored

The table contains 17 documented columns. The most significant are:

• WORKITEM_INSTANCE_ID — Together with PARAMETER_NAME, forms the composite primary key XDP_WORKLIST_DETAILS_PK and the unique index XDP_WORKLIST_DETAILS_U1. It identifies the specific fulfillment worklist instance.
• PARAMETER_NAME — The second business-key component; names the work item parameter being resolved.
• WORKITEM_ID — Foreign key to XDP_WI_PARAMETERS, tying the row to the parameter definition.
• WI_PARAMETER_ID — Surrogate/internal reference to the parameter record.
• PARAMETER_VALUE — The resolved value assigned to the parameter during fulfillment.
• PARAMETER_REF_VALUE — A reference value, typically pointing at an external or sourced attribute.
• IS_VALUE_EVALUATED — Flag indicating whether the parameter value has been evaluated.
• TXN_ATTRIB_DETAIL_ID — Foreign key to CSI_T_EXTEND_ATTRIBS, linking transactional extended attribute definitions.
• ATTRIB_SOURCE_TABLE — Identifies the source table from which the attribute value originates.
• ATTRIB_SOURCE_ID — Foreign key to CSI_I_EXTENDED_ATTRIBS and CSI_IEA_VALUES; this is the direct linkage that answers the user's csi_i_extended_attribs search.
• MODIFIED_FLAG — Indicates whether the row has been modified.
• SECURITY_GROUP_ID — Foreign key to FND_SECURITY_GROUPS, enforcing multi-org/security-group data isolation.
• The remaining audit columns (CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN) capture standard EBS row-level auditing.

The composite unique index XDP_WORKLIST_DETAILS_U1 (WORKITEM_INSTANCE_ID, PARAMETER_NAME) is the primary business-key candidate, while WORKITEM_INSTANCE_ID plus PARAMETER_NAME constitutes the declared primary key rather than a single surrogate column.

Common Use Cases and Queries

Typical scenarios include diagnosing why a fulfillment work item resolved a particular inventory extended attribute, auditing parameter evaluation status, and reporting on attribute sources used during provisioning. A common join pattern retrieves extended attribute context:

• Join XDP_WORKLIST_DETAILS to CSI_I_EXTENDED_ATTRIBS on ATTRIB_SOURCE_ID to see which inventory extended attribute definition supplied a value.
• Join to XDP_FULFILL_WORKLIST on WORKITEM_INSTANCE_ID to obtain worklist status and lifecycle context.
• Filter on IS_VALUE_EVALUATED to find unresolved parameters, or on MODIFIED_FLAG to detect changed rows.
• Restrict by SECURITY_GROUP_ID to respect security-group partitioning in multi-org deployments.

Sample pattern: SELECT d.WORKITEM_INSTANCE_ID, d.PARAMETER_NAME, d.PARAMETER_VALUE, c.ATTRIBUTE_NAME FROM XDP_WORKLIST_DETAILS d, CSI_I_EXTENDED_ATTRIBS c WHERE d.ATTRIB_SOURCE_ID = c.ATTRIB_SOURCE_ID; — adapting the CSI column list to the actual definition.

Related Objects

• XDP_FULFILL_WORKLIST — referenced via WORKITEM_INSTANCE_ID; parent worklist instance.
• XDP_WI_PARAMETERS — referenced via WORKITEM_ID; parameter definitions.
• CSI_T_EXTENDED_ATTRIBS — referenced via TXN_ATTRIB_DETAIL_ID; transactional attribute definitions.
• CSI_I_EXTENDED_ATTRIBS — referenced via ATTRIB_SOURCE_ID; the object central to the user's search.
• CSI_IEA_VALUES — also referenced via ATTRIB_SOURCE_ID; extended attribute values.
• FND_SECURITY_GROUPS — referenced via SECURITY_GROUP_ID; security partitioning.
• XDP_WORKLIST_DETAILS_PK / _U1 — primary key and unique index enforcing row uniqueness.