Search Results xdp_cancel_order




Overview
Explore in AI Chat

Overview

XDP_CANCEL_ORDER is a server-side PL/SQL package owned by the APPS schema in Oracle E-Business Suite. It belongs to the fulfillment and order management domain associated with Oracle's Enterprise Territory and Resource Management (ETRM) / Supply Chain Execution product family, and is specifically responsible for cancelling orders within the Supply Fulfillment Management (SFM) process. The package is declared with AUTHID CURRENT_USER, meaning that its procedures execute with the privileges of the invoking user rather than the definer, and it is intended to be called as an API by other application components rather than being exposed directly to end users through a form.

The package header dates to 2003, and the ETRM classification for this object is "OTHER," indicating that it is not a public, fully supported Open Interface API but an internal helper used by the broader order-cancellation flow. It carries no inbound package dependencies — the metadata records zero packages referencing it — which suggests it is invoked by concurrent programs, workflows, or forms rather than being nested inside other documented APIs.

Key Procedures and Functions

The package exposes a single documented procedure:

  • CANCEL_SFM_ORDER — This is the sole entry point of the package. Its purpose is to cancel an order that is being processed within Supply Fulfillment Management. The procedure accepts a set of identifying and contextual parameters, including an application identifier, an entity short name, a validation entity short name, a validation template short name, a record set short name, and a scope indicator. It returns a result value through an OUT parameter, which the caller interprets to determine the success or failure of the cancellation request. The parameter set follows the standard ETRM validation-and-execution pattern, in which the caller supplies entity and template names so that the same procedure can be reused across different order types and validation rulesets. No other procedures or functions are documented in the package specification.

Tables Accessed

The metadata documents three tables accessed through APPS synonyms:

  • XDP_ORDER_HEADERS — The primary order record. Cancellation logic reads and updates header-level information to reflect the cancelled state of the order.
  • XDP_FA_RUNTIME_LIST — A runtime worklist table used by the SFM engine to hold records currently being processed. Entries relevant to the cancelled order are typically removed or updated so that downstream processing no longer picks them up.
  • XDP_FULFILL_WORKLIST — The fulfillment worklist that tracks order lines or fulfillment tasks awaiting action. Cancellation requires that pending work items associated with the order be cleared from this list.

Usage Notes

XDP_CANCEL_ORDER is an internal API rather than a public interface. It is most commonly invoked by the SFM runtime components — including concurrent programs and workflow activities — when an order must be cancelled before or during fulfillment. Custom code should call this package only with a complete understanding of the entity, validation template, and record set naming conventions used by the deployment, and should always check the OUT result parameter before assuming the cancellation succeeded. Because the package runs with AUTHID CURRENT_USER and references APPS-owned synonyms, callers must be granted EXECUTE on the package and must have visibility to the underlying tables. Direct DML against XDP_ORDER_HEADERS, XDP_FA_RUNTIME_LIST, or XDP_FULFILL_WORKLIST is strongly discouraged, since bypassing this procedure can leave the SFM runtime worklists in an inconsistent state.