Search Results xdp_fa_details




Overview
Explore in AI Chat

Overview

The XDP_FA_DETAILS table is a core runtime data repository within the Oracle E-Business Suite Provisioning (XDP) module. It functions as the operational store for parameter values associated with Fulfillment Actions (FAs) during their execution. In the context of service provisioning workflows, a Fulfillment Action represents a discrete automated task, such as configuring a network device or updating a customer record. This table captures the specific input values supplied for each parameter defined for an action, linking the abstract service design to the concrete data required for real-time processing. Its role is critical for the runtime engine, providing the necessary data payload to execute and track individual fulfillment steps.

Key Information Stored

The table's structure is designed to store parameter values keyed to specific FA execution instances. The primary key is a composite of FA_INSTANCE_ID and PARAMETER_NAME, ensuring unique parameter storage per action instance. Key columns include FA_INSTANCE_ID, which uniquely identifies a specific execution of a Fulfillment Action and links to the XDP_FA_RUNTIME_LIST table. The PARAMETER_NAME column holds the name of the FA parameter for which a value is supplied, corresponding to definitions in XDP_FA_PARAMETERS. While the specific value column is not detailed in the provided metadata, a column such as PARAMETER_VALUE would typically store the actual runtime data. The FULFILLMENT_ACTION_ID links to the master definition of the FA, providing context for the parameter being used.

Common Use Cases and Queries

This table is primarily accessed for troubleshooting, auditing, and reporting on provisioning job execution. Common scenarios include reviewing the exact data passed to a failed Fulfillment Action or generating a historical report of parameter values used in service activations. A typical diagnostic query would join to the runtime list to get execution context.

  • Retrieve Parameters for a Specific FA Instance: SELECT parameter_name, parameter_value FROM xdp_fa_details WHERE fa_instance_id = :1 ORDER BY parameter_name;
  • Audit Trail for a Fulfillment Action Type: SELECT d.fa_instance_id, d.parameter_name, d.parameter_value, r.creation_date FROM xdp_fa_details d, xdp_fa_runtime_list r WHERE d.fa_instance_id = r.fa_instance_id AND r.fulfillment_action_id = :action_id;

Related Objects

The XDP_FA_DETAILS table has defined foreign key relationships with two key provisioning tables, forming part of the core FA execution data model.

  • XDP_FA_RUNTIME_LIST: Linked via FA_INSTANCE_ID. This is the primary parent table, where each record represents a single execution instance of a Fulfillment Action. The details table stores the parameter data for each instance listed here.
  • XDP_FA_PARAMETERS: Linked via FULFILLMENT_ACTION_ID and PARAMETER_NAME. This table holds the master definition and metadata (e.g., data type, default value) for parameters belonging to a Fulfillment Action. The details table stores the runtime values for these defined parameters.