Results for “xdp_fulfill_actions”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

XDP_FULFILL_ACTIONS is the defining table for Fulfillment Actions within the Oracle E-Business Suite Provisioning (XDP) module. A fulfillment action represents a discrete, reusable unit of provisioning activity that the fulfillment engine can invoke as part of a service or order fulfillment workflow. Each row in this table holds the metadata, processing logic references, and routing rules that determine how a specific action is executed, parameterized, and evaluated at runtime. The table is owned by the XDP schema and is valid in both Oracle EBS 12.1.1 and 12.2.2, though the 12.2.2 documented schema carries the additional ZD_EDITION_NAME column characteristic of Edition-Based Redefinition (EBR).

From a Data Vault modeling perspective, the metadata heuristic classifies XDP_FULFILL_ACTIONS as a hub. This is a modeling suggestion: the table originates and centralizes the FULFILLMENT_ACTION_ID business key, and multiple downstream tables reference it via foreign keys, which is the classic signature of a hub surrounded by links and satellites.

Key Information Stored

The documented physical schema contains 14 columns. The most operationally significant are:

• FULFILLMENT_ACTION_ID — the surrogate primary key (XDP_FULFILL_ACTIONS_PK) that uniquely identifies each action and is propagated to all dependent objects.
• FULFILLMENT_ACTION — the human-readable business name of the action; part of the business-key candidate index XDP_FULFILL_ACTIONS_U2 (FULFILLMENT_ACTION, VERSION, ZD_EDITION_NAME).
• VERSION — the version number of the action definition, supporting multiple concurrent revisions of the same logical action.
• FE_ROUTING_PROC — foreign key to XDP_PROC_BODY, identifying the front-end routing procedure that directs the action during fulfillment.
• EVALUATE_PARAM_PROC — foreign key to XDP_PROC_BODY, identifying the procedure used to evaluate the parameters of the action.
• FA_TYPE_CODE — classifies the fulfillment action type, driving behavioral branching in the provisioning engine.
• ROLE_NAME — associates the action with a functional or responsibility role.
• SECURITY_GROUP_ID — foreign key to FND_SECURITY_GROUPS, enforcing multi-tenant data isolation.
• CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — the standard EBS audit trail columns.
• ZD_EDITION_NAME — the EBR edition discriminator, present only in the 12.2.2 documented schema.

The unique index XDP_FULFILL_ACTIONS_U1 (FULFILLMENT_ACTION_ID, ZD_EDITION_NAME) and XDP_FULFILL_ACTIONS_U2 (FULFILLMENT_ACTION, VERSION, ZD_EDITION_NAME) constitute the documented business-key candidates, distinguishing identity from the surrogate primary key.

Common Use Cases and Queries

Typical scenarios include enumerating available actions for a provisioning flow, tracing which procedure backs a given action, and auditing which actions are wired to which workflow items. A representative query joining the action to its routing procedure is:

• SELECT fa.FULFILLMENT_ACTION, fa.VERSION, fa.FA_TYPE_CODE, pb.PROCEDURE_NAME FROM XDP.XDP_FULFILL_ACTIONS fa, XDP.XDP_PROC_BODY pb WHERE fa.FE_ROUTING_PROC = pb.PROC_BODY_ID;
• Reporting all runtime list entries bound to a given action: join XDP_FA_RUNTIME_LIST on FULFILLMENT_ACTION_ID.
• Retrieving translated action names via XDP_FULFILL_ACTIONS_TL using FULFILLMENT_ACTION_ID as the join key.
• Identifying the workflow items linked to an action by joining XDP_WI_FA_MAPPING.

Because audit columns and SECURITY_GROUP_ID are present, trend and ownership reports can be filtered by creation date or security group.

Related Objects

• XDP_FA_FULFILLMENT_PROC — references FULFILLMENT_ACTION_ID; holds fulfillment processing configuration for the action.
• XDP_FA_PARAMETERS — references FULFILLMENT_ACTION_ID; defines the parameters the action accepts.
• XDP_FA_RUNTIME_LIST — references FULFILLMENT_ACTION_ID; runtime execution list entries for the action.
• XDP_FULFILL_ACTIONS_TL — references FULFILLMENT_ACTION_ID; translation (language) table for action names and descriptions.
• XDP_WI_FA_MAPPING — references FULFILLMENT_ACTION_ID; maps workflow items to fulfillment actions.
• XDP_PROC_BODY — referenced by FE_ROUTING_PROC and EVALUATE_PARAM_PROC; the procedure body catalog backing action logic.
• FND_SECURITY_GROUPS — referenced by SECURITY_GROUP_ID; enforces data security grouping.