Search Results provision_line

Overview

XDPCORE_OM is an Oracle E-Business Suite PL/SQL package owned by the APPS schema and classified under ETRM as an "OTHER" API. Its name reflects its role at the intersection of Oracle's fulfillment integration layer (the XDP product family) and Order Management (OM). XDPCORE_OM provides the orchestration logic that drives order lines through orchestration and fulfillment processing, bridging native EBS order capture tables with the XDP staging and fulfillment structures that support distributed order orchestration and fulfillment flows. In release 12.1.1 and 12.2.2 the package is valid and resides entirely in APPS, exposing a set of callable routines rather than a formal public API contract. The package coordinates the lifecycle of a fulfillment order — creation, status polling, completion detection, and reconciliation back to the originating order line — making it a programmatic control point for automated order fulfillment rather than an end-user-facing component.

Key Procedures and Functions

Eight documented routines constitute the package interface:

• CREATE_FULFILLMENT_ORDER — Initiates a fulfillment order for the qualifying order context, establishing the record that downstream fulfillment processing will act upon.
• START_FULFILLMENT_PROCESS — Kicks off the fulfillment execution for a previously created fulfillment order.
• WAIT_FOR_FULFILLMENT — Blocks or polls until the fulfillment process reaches a terminal or actionable state, supporting synchronous or controlled-asynchronous integration patterns.
• IS_FULFILLMENT_COMPLETED — Evaluates whether fulfillment for the given context has finished, returning a status indicator to the caller.
• PROVISION_LINE — Provisions an order line into the fulfillment environment, preparing it for downstream fulfillment activity.
• LINE_FULFILLMENT_DONE — Marks or detects that an individual order line has completed fulfillment.
• UPDATE_TXN_DETAILS — Writes transaction-level details back to the relevant records, keeping fulfillment and order data consistent.
• UPDATE_OM_LINE_STATUS — Synchronizes the Order Management order line status with the outcome of fulfillment processing.

Parameter lists are not published in the ETRM excerpt and must be confirmed against the package specification in the target instance.

Tables Accessed

Via APPS synonyms, XDPCORE_OM reads and writes order and fulfillment structures:

• OE_ORDER_HEADERS_ALL and OE_ORDER_LINES_ALL — the core Order Management header and line tables, used to identify the order context and to update line status.
• XDP_ORDER_HEADERS and XDP_ORDER_LINE_ITEMS — the XDP fulfillment-side header and line records created, provisioned, and updated during fulfillment.
• DBMS_APPLICATION_INFO — used to register module and action context for monitoring and diagnostics during long-running fulfillment operations.
• PLITBLM — the standard EBS PL/SQL table and index-by table utility package, supporting in-memory collections.

Usage Notes

XDPCORE_OM is referenced by no other documented packages, indicating it is invoked as an entry point rather than called internally by peer APIs. It is typically driven by fulfillment orchestration flows, concurrent programs, or custom integration code that must create, monitor, and reconcile fulfillment orders programmatically. Because routines such as WAIT_FOR_FULFILLMENT may block, callers should invoke the package from controlled batch or background processes rather than interactive forms. Implementations extending or debugging fulfillment behavior should review the package body and specification directly, as the ETRM metadata documents only the named routines and dependent objects, not signatures or exception behavior.