Results for “time_estimate”

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

Overview

XDP_WORKITEMS is a provisioning-module table owned by the XDP schema in Oracle E-Business Suite 12.1.1 and 12.2.2. Its documented description states that it "is used to define a work item." In practice, each row represents a discrete unit of fulfillment or provisioning activity — a work item — that the provisioning engine can invoke, schedule, track, and report against. The table serves as the definitional master for work items, carrying attributes such as type code, validity window, workflow assignments, procedure references, and estimated effort, which downstream fulfillment and order-line processes consume.

From a Data Vault modeling perspective, the mined foreign-key structure classifies XDP_WORKITEMS heuristically as a hub. It anchors a stable business key (the work item identity) and is referenced by numerous satellites and link-style tables (for example, XDP_WI_PARAMETERS and XDP_SERVICE_WI_MAP), with only limited outbound references of its own (to XDP_PROC_BODY and FND_SECURITY_GROUPS). This classification is offered as a modeling suggestion rather than a documented fact.

Key Information Stored

The table physically contains 23 columns in the ETRM 12.2.2 schema. The most significant are listed below.

• WORKITEM_ID — the surrogate primary key, defined by constraint XDP_WORKITEMS_PK. It is the join key used by every dependent table.
• WORKITEM_NAME and VERSION — the business-key pair. Unique index XDP_WORKITEMS_U2 (WORKITEM_NAME, VERSION, ZD_EDITION_NAME) enforces uniqueness, and the documented secondary key XDP_WORKITEMS_UK1 anchors name plus version. Together they provide the human-readable identity of a work item across versions.
• WI_TYPE_CODE — classifies the work item category, driving behavior in the provisioning engine.
• VALID_DATE and INVALID_DATE — define the effective-dating window during which the work item definition is usable.
• FA_EXEC_MAP_PROC — foreign key to XDP_PROC_BODY; names the procedure that maps execution during fulfillment.
• WF_EXEC_PROC — foreign key to XDP_PROC_BODY; names the workflow execution procedure.
• USER_WF_ITEM_TYPE, USER_WF_ITEM_KEY_PREFIX, and USER_WF_PROCESS_NAME — control how the work item surfaces in the Oracle Workflow engine, including its item type, key prefix, and owning process.
• TIME_ESTIMATE — the expected duration or effort for the work item, used in scheduling and capacity calculations.
• PROTECTED_FLAG — indicates whether the definition is protected from modification.
• ROLE_NAME — the role associated with executing the work item.
• VALIDATION_PROCEDURE and VALIDATION_ENABLED_FLAG — the validation routine and its enablement toggle.
• SECURITY_GROUP_ID — foreign key to FND_SECURITY_GROUPS, providing multi-org / security-group isolation.
• ZD_EDITION_NAME — the editioning column used by the EBS online patching (edition-based redefinition) model in 12.2.x.
• Standard audit columns — CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN.

Common Use Cases and Queries

Typical scenarios include resolving a work item's definition from a fulfillment record, validating effective-dated work items, and reporting on work item assignments and volume by type. A representative join resolves the work item behind an order line:

• SELECT w.WORKITEM_ID, w.WORKITEM_NAME, w.VERSION, w.WI_TYPE_CODE, w.TIME_ESTIMATE FROM XDP_WORKITEMS w WHERE w.WORKITEM_NAME = :name AND SYSDATE BETWEEN w.VALID_DATE AND NVL(w.INVALID_DATE, SYSDATE+1);
• SELECT li.ORDER_LINE_ID, w.WORKITEM_NAME, w.WI_TYPE_CODE FROM XDP_ORDER_LINE_ITEMS li JOIN XDP_WORKITEMS w ON w.WORKITEM_ID = li.WORKITEM_ID;
• SELECT l.WORKITEM_ID, w.WORKITEM_NAME, w.ROLE_NAME FROM XDP_FULFILL_WORKLIST l JOIN XDP_WORKITEMS w ON w.WORKITEM_ID = l.WORKITEM_ID;

These queries support fulfillment tracking, role/assignment reporting, and configuration validation during implementations.

Related Objects

XDP_WORKITEMS sits at the center of a family of dependent tables, joined on WORKITEM_ID:

• XDP_WI_PARAMETERS — stores parameters for each work item (referencing WORKITEM_ID).
• XDP_SERVICE_WI_MAP — maps services to work items.
• XDP_ORDER_LINE_ITEMS — links order lines to their work items.
• XDP_FULFILL_WORKLIST — the fulfillment work queue referencing the work item.
• XDP_WI_FA_MAPPING — fulfillment-assignment mapping.
• XDP_WORKITEMS_TL — the translated (MLS) description table.
• XNS_ACTION_WI_MAPPING — maps external actions to work items.
• XDP_PROC_BODY — referenced by FA_EXEC_MAP_PROC and WF_EXEC_PROC.
• FND_SECURITY_GROUPS — referenced by SECURITY_GROUP_ID.

Taken together, these relationships confirm XDP_WORKITEMS as the central hub in the provisioning work item model.