Search Results xdp_adapter_job_queue_s

Overview

APPS.XDPCORE_FA is a core PL/SQL package body within the Oracle E-Business Suite Advanced Supply Chain / Enterprise Transportation and Logistics fulfillment framework (XDP schema family). It implements the server-side logic that drives fulfillment element (FE) provisioning and fulfillment action (FA) processing. In practical terms, the package coordinates the lifecycle of an FA — from initialization and channel verification, through enqueueing and executing a fulfillment process, to releasing and resetting the associated channel or fulfillment element. It operates as an orchestration layer that interacts with the Oracle Workflow engine, the XDP adapter registry, and a set of XDP runtime bookkeeping tables.

The package is classified as OTHER and carries VALID status in both 12.1.1 and 12.2.2. It is referenced by eight other database objects, making it a shared dependency rather than an entry-point API, and it is not referenced by any database object in the reverse direction. It depends heavily on XDPCORE, XDPCORE_WI, XDPCORE_ERROR, XDP_ADAPTER, XDP_ADAPTER_CORE, XDP_ENGINE, XDP_UTILITIES, WF_CORE, WF_ENGINE, WF_NOTIFICATION, FND_GLOBAL, and FND_PROFILE.

Key Procedures and Functions

Thirty-six documented procedures and functions are exposed. The major groupings are:

• Initialization and setup: INITIALIZE_FA, INITIALIZE_FA_LIST, CREATEFAPROCESS, IS_CHANNEL_AVAILABLE, IS_COD_CHANNEL_AVAILABLE, CONNECT_ON_DEMAND.
• Launch and provisioning: LAUNCH_FA_PROCESS, LAUNCH_FA_PROCESS_SEQ, LAUNCH_FA_PROVISIONING_PROCESS, PROVISION_FE, GET_FE, OVERRIDE_FE, GET_FA_CALLER.
• Queue management: ENQUEUE_FP_QUEUE, WAIT_IN_FP_QUEUE, ARE_ALL_FAS_DONE, STOP_FA_PROCESSING.
• Channel lifecycle: VERIFY_CHANNEL, RELEASE_FE_CHANNEL, RESET_CHANNEL.

In aggregate, these routines acquire and release fulfillment elements, schedule fulfillment processes onto the job queue, track completion of all fulfillment actions in a batch, and provide caller-identification and macro-expansion utilities via XDP_MACROS.

Tables Accessed

All table access occurs through APPS synonyms. The package reads and writes XDP_ADAPTER_JOB_QUEUE and its sequence XDP_ADAPTER_JOB_QUEUE_S to place and retrieve fulfillment process entries; XDP_ADAPTER_ADMIN_REQS and XDP_ADAPTER_REG for adapter administration and registration lookups; XDP_FES, XDP_FA_FULFILLMENT_PROC, XDP_FA_RUNTIME_LIST, and XDP_FULFILL_ACTIONS / XDP_FULFILL_ACTIONS_VL for fulfillment element and action state; XDP_FULFILL_WORKLIST and XDP_WORKITEMS for work item tracking; XDP_WI_FA_MAPPING and XDP_WF_ITEMKEY_S to relate workflow item keys to fulfillment actions; XDP_FE_SW_GEN_LOOKUP for seeded lookup values; and XDP_ERROR_COUNT to record errors. DUAL supplies sequence and scalar selects.

Usage Notes

XDPCORE_FA is not a user-facing API. It is invoked internally by the XDP engine, by workflow business event subscribers (WF_ENGINE / WF_NOTIFICATION), and by fulfillment concurrent programs that enqueue work into XDP_ADAPTER_JOB_QUEUE. Custom code should not call these procedures directly; instead, integration should target XDP_ADAPTER_CORE, XDP_ADAPTER_CORE_DB, or the documented fulfillment action APIs. Because the package uses FND_GLOBAL and FND_PROFILE, it depends on a valid applications session context. Any direct diagnostic query against XDP_ADAPTER_JOB_QUEUE_S should use the APPS synonym and account for concurrent processing by the fulfillment agent.