Results for “xdp_fa_fulfillment_proc”

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

Overview

The XDP.XDP_FA_FULFILLMENT_PROC table is a Provisioning module (XDP) repository object that stores the executable fulfillment procedures associated with individual fulfillment actions. In Oracle EBS, provisioning workflows frequently need to invoke PL/SQL logic at the moment a fulfillment action fires — for example, to activate a service, push configuration data to a network element, or execute a compensating reversal. This table provides that binding: it maps a given fulfillment action and software generation lookup context to one or more stored procedure bodies held in XDP_PROC_BODY.

From a data-modeling perspective, the metadata supports treating this object as a link entity in a Data Vault style model. It carries no natural descriptive attributes about a business entity in its own right; instead it resolves relationships between fulfillment actions, software generation lookups, procedure bodies, and security groups. The presence of multiple foreign keys pointing outward, combined with a surrogate primary key, is consistent with a link table joining hubs. The status is VALID in both 12.1.1 and 12.2.2, and the documented physical schema comprises 14 columns.

Key Information Stored

The most significant columns are:

• FA_FULFILLMENT_PROC_ID — the surrogate primary key (constraint XDP_FA_FULFILLMENT_PROC_PK) and the value most commonly searched via the term fa_fulfillment_proc_id.
• FULFILLMENT_ACTION_ID — foreign key to XDP_FULFILL_ACTIONS, identifying the fulfillment action to which the procedure is bound.
• FE_SW_GEN_LOOKUP_ID — foreign key to XDP_FE_SW_GEN_LOOKUP, scoping the procedure to a particular software generation lookup.
• FULFILLMENT_PROC — foreign key to XDP_PROC_BODY, holding the forwarded fulfillment procedure executed during normal provisioning.
• UNDO_PROVISIONING_PROC — the procedure invoked to reverse or compensate a completed provisioning step.
• TEST_PROVISIONING_PROC — foreign key to XDP_PROC_BODY, used for test or dry-run provisioning paths.
• PROTECTED_FLAG — indicates whether the record is protected from modification or deletion.
• SECURITY_GROUP_ID — foreign key to FND_SECURITY_GROUPS, enforcing Oracle EBS multi-org/data security.
• ZD_EDITION_NAME — the editioning column supporting Online Patching in 12.2.2.
• CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — standard EBS audit columns.

Two unique indexes act as business-key candidates. XDP_FULFILLMENT_PROC_U1 spans (FA_FULFILLMENT_PROC_ID, ZD_EDITION_NAME), and XDP_FULFILLMENT_PROC_U2 spans (FULFILLMENT_ACTION_ID, FE_SW_GEN_LOOKUP_ID, ZD_EDITION_NAME). The U2 index is the more meaningful business key, as it prevents duplicate procedure bindings for the same action and software generation.

Common Use Cases and Queries

Typical uses include auditing which procedures fire for a given fulfillment action, troubleshooting provisioning failures, and migrating procedure bindings between environments.

Retrieve all procedures for a specific fulfillment action:

• SELECT p.FA_FULFILLMENT_PROC_ID, p.FULFILLMENT_PROC, p.UNDO_PROVISIONING_PROC, p.TEST_PROVISIONING_PROC FROM XDP.XDP_FA_FULFILLMENT_PROC p WHERE p.FULFILLMENT_ACTION_ID = :action_id;

Join to procedure bodies to resolve the actual PL/SQL names:

• SELECT p.FA_FULFILLMENT_PROC_ID, b.PROC_NAME FROM XDP.XDP_FA_FULFILLMENT_PROC p, XDP.XDP_PROC_BODY b WHERE p.FULFILLMENT_PROC = b.PROC_BODY_ID;

Reporting scenarios commonly list the fulfillment action, software generation lookup, and resolved procedure names to verify configuration completeness, and integrity checks scan for rows whose referenced procedure bodies are missing.

Related Objects

• XDP_FULFILL_ACTIONS — joined via XDP_FA_FULFILLMENT_PROC.FULFILLMENT_ACTION_ID; provides the parent fulfillment action definition.
• XDP_FE_SW_GEN_LOOKUP — joined via XDP_FA_FULFILLMENT_PROC.FE_SW_GEN_LOOKUP_ID; supplies the software generation context.
• XDP_PROC_BODY — referenced twice, via FULFILLMENT_PROC and TEST_PROVISIONING_PROC; holds the executable procedure source.
• FND_SECURITY_GROUPS — joined via XDP_FA_FULFILLMENT_PROC.SECURITY_GROUP_ID; enforces EBS data security.
• Indexes and constraints — XDP_FA_FULFILLMENT_PROC_PK, XDP_FULFILLMENT_PROC_U1, and XDP_FULFILLMENT_PROC_U2 govern uniqueness and lookup performance.