Search Results xdp_fa_runtime_list




Overview
Explore in AI Chat

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:

  • Table: XDP_FA_RUNTIME_LIST 12.1.1

    owner:XDP,  object_type:TABLE,  fnd_design_data:XDP.XDP_FA_RUNTIME_LIST,  object_name:XDP_FA_RUNTIME_LIST,  status:VALID,  product: XDP - Provisioning ,  description: This table contains the list of the FAs which need to be executed for a workitem instance. ,  implementation_dba_data: XDP.XDP_FA_RUNTIME_LIST , 

  • Table: XDP_FA_RUNTIME_LIST 12.2.2

    owner:XDP,  object_type:TABLE,  fnd_design_data:XDP.XDP_FA_RUNTIME_LIST,  object_name:XDP_FA_RUNTIME_LIST,  status:VALID,  product: XDP - Provisioning ,  description: This table contains the list of the FAs which need to be executed for a workitem instance. ,  implementation_dba_data: XDP.XDP_FA_RUNTIME_LIST , 

  • Table: XDP_FE_CMD_AUD_TRAILS 12.2.2

    owner:XDP,  object_type:TABLE,  fnd_design_data:XDP.XDP_FE_CMD_AUD_TRAILS,  object_name:XDP_FE_CMD_AUD_TRAILS,  status:VALID,  product: XDP - Provisioning ,  description: FE Command Audit Trail ,  implementation_dba_data: XDP.XDP_FE_CMD_AUD_TRAILS , 

  • Table: XDP_FA_DETAILS 12.1.1

    owner:XDP,  object_type:TABLE,  fnd_design_data:XDP.XDP_FA_DETAILS,  object_name:XDP_FA_DETAILS,  status:VALID,  product: XDP - Provisioning ,  description: XDP_FA_DETAILS contains the runtime FA parameter values. ,  implementation_dba_data: XDP.XDP_FA_DETAILS , 

  • Table: XDP_FE_CMD_AUD_TRAILS 12.1.1

    owner:XDP,  object_type:TABLE,  fnd_design_data:XDP.XDP_FE_CMD_AUD_TRAILS,  object_name:XDP_FE_CMD_AUD_TRAILS,  status:VALID,  product: XDP - Provisioning ,  description: FE Command Audit Trail ,  implementation_dba_data: XDP.XDP_FE_CMD_AUD_TRAILS , 

  • Table: XDP_FA_DETAILS 12.2.2

    owner:XDP,  object_type:TABLE,  fnd_design_data:XDP.XDP_FA_DETAILS,  object_name:XDP_FA_DETAILS,  status:VALID,  product: XDP - Provisioning ,  description: XDP_FA_DETAILS contains the runtime FA parameter values. ,  implementation_dba_data: XDP.XDP_FA_DETAILS , 

  • Table: XDP_FULFILL_ACTIONS 12.2.2

    owner:XDP,  object_type:TABLE,  fnd_design_data:XDP.XDP_FULFILL_ACTIONS,  object_name:XDP_FULFILL_ACTIONS,  status:VALID,  product: XDP - Provisioning ,  description: Fulfillment Action definition ,  implementation_dba_data: XDP.XDP_FULFILL_ACTIONS , 

  • Table: XDP_FA_RESUBMISSION_LOG 12.1.1

    owner:XDP,  object_type:TABLE,  fnd_design_data:XDP.XDP_FA_RESUBMISSION_LOG,  object_name:XDP_FA_RESUBMISSION_LOG,  status:VALID,  product: XDP - Provisioning ,  description: This table records the resubmission jobs for Oracle Service Fulfillment Manager. The fulfillment elements may be restarted in Order Resubmission mode to resubmit orders to the provisioning workflow. ,  implementation_dba_data: XDP.XDP_FA_RESUBMISSION_LOG , 

  • Table: XDP_FA_RESUBMISSION_LOG 12.2.2

    owner:XDP,  object_type:TABLE,  fnd_design_data:XDP.XDP_FA_RESUBMISSION_LOG,  object_name:XDP_FA_RESUBMISSION_LOG,  status:VALID,  product: XDP - Provisioning ,  description: This table records the resubmission jobs for Oracle Service Fulfillment Manager. The fulfillment elements may be restarted in Order Resubmission mode to resubmit orders to the provisioning workflow. ,  implementation_dba_data: XDP.XDP_FA_RESUBMISSION_LOG , 

  • Table: XDP_FULFILL_ACTIONS 12.1.1

    owner:XDP,  object_type:TABLE,  fnd_design_data:XDP.XDP_FULFILL_ACTIONS,  object_name:XDP_FULFILL_ACTIONS,  status:VALID,  product: XDP - Provisioning ,  description: Fulfillment Action definition ,  implementation_dba_data: XDP.XDP_FULFILL_ACTIONS , 

  • Table: XDP_FULFILL_WORKLIST 12.2.2

    owner:XDP,  object_type:TABLE,  fnd_design_data:XDP.XDP_FULFILL_WORKLIST,  object_name:XDP_FULFILL_WORKLIST,  status:VALID,  product: XDP - Provisioning ,  description: This table identifies a list of services that need to be fulfilled for the given order ,  implementation_dba_data: XDP.XDP_FULFILL_WORKLIST , 

  • View: XDP_ORU_ORDERS_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:XDP.XDP_ORU_ORDERS_V,  object_name:XDP_ORU_ORDERS_V,  status:VALID,  product: XDP - Provisioning ,  description: This view contains the details of resubmitted orders. ,  implementation_dba_data: APPS.XDP_ORU_ORDERS_V , 

  • Table: XDP_FULFILL_WORKLIST 12.1.1

    owner:XDP,  object_type:TABLE,  fnd_design_data:XDP.XDP_FULFILL_WORKLIST,  object_name:XDP_FULFILL_WORKLIST,  status:VALID,  product: XDP - Provisioning ,  description: This table identifies a list of services that need to be fulfilled for the given order ,  implementation_dba_data: XDP.XDP_FULFILL_WORKLIST , 

  • View: XDP_READY_FAS_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:XDP.XDP_READY_FAS_V,  object_name:XDP_READY_FAS_V,  status:VALID,  product: XDP - Provisioning ,  description: This View shows all the Orders in the Fulfillment Actions Queue. ,  implementation_dba_data: APPS.XDP_READY_FAS_V , 

  • Table: XDP_PROC_BODY 12.2.2

    owner:XDP,  object_type:TABLE,  fnd_design_data:XDP.XDP_PROC_BODY,  object_name:XDP_PROC_BODY,  status:VALID,  product: XDP - Provisioning ,  description: XDP_PROC_BODY stores the source of all the user defined procedures ,  implementation_dba_data: XDP.XDP_PROC_BODY , 

  • View: XDP_READY_FAS_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:XDP.XDP_READY_FAS_V,  object_name:XDP_READY_FAS_V,  status:VALID,  product: XDP - Provisioning ,  description: This View shows all the Orders in the Fulfillment Actions Queue. ,  implementation_dba_data: APPS.XDP_READY_FAS_V , 

  • Table: XDP_FES 12.2.2

    owner:XDP,  object_type:TABLE,  fnd_design_data:XDP.XDP_FES,  object_name:XDP_FES,  status:VALID,  product: XDP - Provisioning ,  description: This table holds all the names of the Fulfillment Elements (Network Elements). This data contains the definition of a fulfillment element. ,  implementation_dba_data: XDP.XDP_FES , 

  • Table: XDP_PROC_BODY 12.1.1

    owner:XDP,  object_type:TABLE,  fnd_design_data:XDP.XDP_PROC_BODY,  object_name:XDP_PROC_BODY,  status:VALID,  product: XDP - Provisioning ,  description: XDP_PROC_BODY stores the source of all the user defined procedures ,  implementation_dba_data: XDP.XDP_PROC_BODY , 

  • View: XDP_ORU_ORDERS_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:XDP.XDP_ORU_ORDERS_V,  object_name:XDP_ORU_ORDERS_V,  status:VALID,  product: XDP - Provisioning ,  description: This view contains the details of resubmitted orders. ,  implementation_dba_data: APPS.XDP_ORU_ORDERS_V , 

  • View: XDP_WAITING_FES_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:XDP.XDP_WAITING_FES_V,  object_name:XDP_WAITING_FES_V,  status:VALID,  product: XDP - Provisioning ,  description: This View shows all the Orders Waiting for the Fulfillment Elements ,  implementation_dba_data: APPS.XDP_WAITING_FES_V , 

  • View: XDP_WAITING_FES_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:XDP.XDP_WAITING_FES_V,  object_name:XDP_WAITING_FES_V,  status:VALID,  product: XDP - Provisioning ,  description: This View shows all the Orders Waiting for the Fulfillment Elements ,  implementation_dba_data: APPS.XDP_WAITING_FES_V , 

  • Table: XDP_FES 12.1.1

    owner:XDP,  object_type:TABLE,  fnd_design_data:XDP.XDP_FES,  object_name:XDP_FES,  status:VALID,  product: XDP - Provisioning ,  description: This table holds all the names of the Fulfillment Elements (Network Elements). This data contains the definition of a fulfillment element. ,  implementation_dba_data: XDP.XDP_FES , 

  • View: XDP_READY_FES_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:XDP.XDP_READY_FES_V,  object_name:XDP_READY_FES_V,  status:VALID,  product: XDP - Provisioning ,  description: This View shows all the Orders in the Fulfillment Elements Ready Queue ,  implementation_dba_data: APPS.XDP_READY_FES_V , 

  • View: XDP_READY_FES_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:XDP.XDP_READY_FES_V,  object_name:XDP_READY_FES_V,  status:VALID,  product: XDP - Provisioning ,  description: This View shows all the Orders in the Fulfillment Elements Ready Queue ,  implementation_dba_data: APPS.XDP_READY_FES_V ,