Search Results add_fa_towi

Overview

XDP_ENG_UTIL is a PL/SQL utility package owned by the APPS schema in Oracle E-Business Suite 12.1.1 and 12.2.2. Its object name and API classification (UTIL) indicate that it serves as a shared engineering utility layer for the Oracle Advanced Supply Chain Planning / fulfillment execution family of modules, specifically the XDP (Execution and Distribution Processing) product suite. Rather than implementing a single business transaction, XDP_ENG_UTIL provides reusable programmatic services that other XDP packages call to create, execute, resubmit, and monitor fulfillment actions (FA) — the discrete units of work that move orders, reservations, and shipments through the fulfillment engine.

The package is central to the orchestration layer of the fulfillment engine. It abstracts common operations that would otherwise be duplicated across XDPCORE, XDP_ORDER_SYNC, XDP_DRC_UTIL_PVT, and related modules, allowing those callers to invoke a consistent interface for launching and re-launching fulfillment actions. In ETRM documentation for 12.2.2, XDP_ENG_UTIL is recorded as VALID and is classified as a utility API with no public form of its own.

Key Procedures and Functions

• ADD_FA_TOWI — Adds a fulfillment action to a work item or work queue structure. It is the registration step used before a fulfillment action can be executed by the engine.
• RESUBMIT_FA — Re-queues an existing fulfillment action for processing, typically after a prior attempt ended in error or was interrupted.
• EXECUTE_FA — Executes a fulfillment action, driving it through the appropriate engine logic and updating runtime status.
• EXECUTE_RESUBMIT_FA — Combines execution and resubmission in a single call, used when a fulfillment action must be retried programmatically without manual intervention.

ETRM lists six documented procedures/functions in total for this package; the four above are the named entry points, with the remainder consisting of supporting internal routines. Parameter lists are intentionally omitted from this summary because ETRM does not publish signatures for this object.

Tables Accessed

All table references are resolved through APPS synonyms, consistent with the package's schema. The documented tables are:

• XDP_FA_DETAILS — Stores the detailed definition of each fulfillment action, including its type, state, and associated data. Read and written during add, execute, and resubmit operations.
• XDP_FA_PARAMETERS — Holds the input parameters that govern how a fulfillment action behaves. Read by the execution routines.
• XDP_FA_RUNTIME_LIST and XDP_FA_RUNTIME_LIST_S — The runtime work list (and its sequence/tracking counterpart) that the engine consumes when deciding which fulfillment actions are eligible to run. Written by ADD_FA_TOWI and updated by the execute routines.
• XDP_FES — The fulfillment execution status/event table, used to record engine outcomes.
• XDP_FULFILL_ACTIONS — The master fulfillment action repository; read to validate and update action state.
• DUAL — Used for scalar PL/SQL evaluation and configuration lookups.

Usage Notes

XDP_ENG_UTIL is an internal engine utility, not an end-user API. It is invoked programmatically by sibling packages, including XDPCORE, XDPCORE_FA, XDPCORE_ORU, XDP_DRC_UTIL_PVT, XDP_ORDER_SYNC, and XNP_WF_STANDARD, and by itself recursively. In practice this means it is triggered indirectly through order synchronization, fulfillment concurrent programs, and workflow activities rather than through a dedicated form or concurrent program.

Customizations should call the package only through the owning XDP modules, because direct invocation bypasses engine state management. The package depends solely on SYS and STANDARD, confirming that it is self-contained and portable across 12.1.1 and 12.2.2. All references resolve through APPS synonyms, so no additional grants are required beyond the standard APPS access already held by the caller.