Search Results xdp_fa_runtime_list

Overview

The XDP_FA_RUNTIME_LIST table is a core runtime data object within the Oracle E-Business Suite Provisioning (XDP) module. It functions as the central execution queue and tracking mechanism for Fulfillment Actions (FAs) during the order fulfillment process. When a work item (a unit of provisioning work) is processed, this table stores the definitive list of all FAs that must be executed for that specific work item instance. It is integral to the orchestration engine, linking work items to their required actions, tracking execution state, and maintaining relationships with other key provisioning entities like Fulfillment Engines (FEs) and resubmission logs.

Key Information Stored

The table's primary key is FA_INSTANCE_ID, a unique identifier for each FA execution instance. Critical foreign key columns establish the table's operational context. The WORKITEM_INSTANCE_ID links the FA to its parent work item in XDP_FULFILL_WORKLIST. The FULFILLMENT_ACTION_ID references the master definition of the action in XDP_FULFILL_ACTIONS. The FE_ID associates the FA with a specific Fulfillment Engine (from XDP_FES) responsible for its execution, while PROC_NAME can link to a specific procedure body in XDP_PROC_BODY. The RESUBMISSION_JOB_ID column is pivotal for error handling and retry logic, connecting to the XDP_FA_RESUBMISSION_LOG to track resubmission attempts.

Common Use Cases and Queries

This table is central to monitoring and troubleshooting the fulfillment workflow. Common operational queries include identifying pending or failed actions for a specific order or service, analyzing FA execution bottlenecks, and auditing the history of actions for a work item. For instance, to find all FAs currently queued for execution for a given work item, one might query:

• SELECT * FROM xdp_fa_runtime_list WHERE workitem_instance_id = <ID> ORDER BY creation_date;

Another critical use case involves resubmission analysis. To investigate failed actions and their retry status, a join with the resubmission log is typical:

• SELECT rl.*, log.resubmission_status FROM xdp_fa_runtime_list rl, xdp_fa_resubmission_log log WHERE rl.resubmission_job_id = log.resubmission_job_id AND rl.workitem_instance_id = <ID>;

Related Objects

The XDP_FA_RUNTIME_LIST table is a central hub with extensive relationships. It references the following parent tables via foreign keys:

• XDP_FULFILL_ACTIONS via FULFILLMENT_ACTION_ID
• XDP_FA_RESUBMISSION_LOG via RESUBMISSION_JOB_ID
• XDP_FULFILL_WORKLIST via WORKITEM_INSTANCE_ID
• XDP_FES via FE_ID
• XDP_PROC_BODY via PROC_NAME

Conversely, it is referenced as a parent table by these key runtime and audit objects:

• XDP_FA_DETAILS references via FA_INSTANCE_ID
• XDP_FE_CMD_AUD_TRAILS references via FA_INSTANCE_ID
• XNP_CALLBACK_EVENTS references via FA_INSTANCE_ID
• XNP_MSGS references via FA_INSTANCE_ID
• XNP_TIMER_REGISTRY references via FA_INSTANCE_ID