Search Results initialize_workitem_process

Overview

XDPCORE_WI is an Oracle Application Object Library package owned by the APPS schema that forms part of the Oracle Enterprise Trade Management / Advanced Pricing infrastructure in Oracle E-Business Suite 12.1.1 and 12.2.2. The package name suffix "_WI" refers to "work item," and the package serves as the core work item processing engine within the XDP (Oracle Pricing/XDP) architecture. Its principal business function is to create, initialize, evaluate, launch, and complete work items associated with fulfillment worklists and pricing engine processing.

The package is classified as OTHER in the ETRM metadata, indicating that it is an internal, non-public API intended for consumption by other XDP packages rather than by external customizations. Within the pricing and order fulfillment flow, XDPCORE_WI acts as the orchestration layer that coordinates individual work items, sequences, and services so that the pricing engine can process complex order lines and fulfillment workflows. It depends on the XDP_FULFILL_WORKLIST table and on the STANDARD SYS package, and it is referenced by several peer packages including XDPCORE_ERROR, XDPCORE_FA, XDP_ENGINE, and by itself, confirming its role as a shared, reusable component.

Key Procedures and Functions

The package exposes 18 documented procedures and functions. The work item lifecycle is the dominant theme:

• CREATEWORKITEMPROCESS — Creates a work item processing record for a given work item.
• INITIALIZE_WI_LIST, INITIALIZE_WORKITEM_PROCESS, and INITIALIZE_DEP_WI_PROCESS — Initialize work item lists, individual work item processes, and dependent work item processes respectively.
• CONTINUE_WORKITEM — Resumes processing of a work item that is already in progress.
• LAUNCH_WORKITEM_PROCESS, LAUNCH_WI_SEQ_PROCESS, LAUNCH_WI_SERVICE_PROCESS, and LAUNCH_ALL_IND_WIS — Launch work item processes, sequence processes, service processes, and all independent work items.
• ARE_ALL_WIS_DONE — Determines whether all work items in a set have completed.
• EVALUATE_ALL_WIS_PARAMS, EVALUATE_WI_PARAMS, and EVALUATEWIPARAMSONSTART — Evaluate parameters across all work items, for a single work item, and at start time respectively.
• RESOLVE_IND_DEP_WIS — Resolves independent and dependent work item relationships.
• GET_WI_RESPONSIBILITY, GET_ONSTART_WI_PARAMS, and GET_DISPLAY_NAME — Retrieve the responsibility associated with a work item, on-start parameters, and display names.
• OVERRIDE_WI_PARAM — Allows a work item parameter value to be overridden.

Tables Accessed

The package reads and writes the following tables through APPS synonyms:

• XDP_FULFILL_WORKLIST — The fulfillment worklist header table, referenced as a direct dependency.
• XDP_WORKITEMS and XDP_WORKLIST_DETAILS — Core work item and worklist detail records.
• XDP_ORDER_LINE_ITEMS — Order line items processed through the work item flow.
• XDP_WF_ITEMKEY_S — Workflow item key sequence generation.
• DUAL — Used for single-row PL/SQL expressions.

Usage Notes

XDPCORE_WI is an internal engine package and is not intended to be called directly from forms or concurrent programs. It is invoked programmatically by XDP_ENGINE and by the other XDPCORE packages (XDPCORE_ERROR, XDPCORE_FA) during pricing engine and fulfillment work item processing. In 12.1.1 and 12.2.2, no public API classification is assigned, so custom code should avoid direct calls; instead, customizations should target the supported XDP engine entry points. Because the package is VALID and referenced by multiple dependent packages, any modification would invalidate a wide portion of the pricing engine dependency chain, making it a change-controlled object.