Search Results xdp_fa_fulfillment_proc




Overview
Explore in AI Chat

Overview

The XDP_FA_FULFILLMENT_PROC table is a core data object within the Oracle E-Business Suite Provisioning (XDP) module, specifically for versions 12.1.1 and 12.2.2. It serves as a junction table that maps fulfillment procedures to specific fulfillment actions and fulfillment elements. Its primary role is to define and manage the executable logic—stored as PL/SQL procedure references—required to fulfill a service order for a particular product or service component. This table is essential for the automated provisioning workflow, linking the conceptual definition of a fulfillment action with the concrete procedural code that implements it, including separate procedures for standard fulfillment and test provisioning scenarios.

Key Information Stored

The table's structure centers on foreign key relationships that define these mappings. The critical columns are the foreign keys that establish connections to related master data tables. The FA_FULFILLMENT_PROC_ID column serves as the table's unique primary key identifier. The FULFILLMENT_ACTION_ID column links to the XDP_FULFILL_ACTIONS table, identifying the specific action being performed. The FE_SW_GEN_LOOKUP_ID column links to the XDP_FE_SW_GEN_LOOKUP table, specifying the fulfillment element or software component to which the procedure applies. Crucially, the FULFILLMENT_PROC and TEST_PROVISIONING_PROC columns store references (via foreign keys to XDP_PROC_BODY) to the actual PL/SQL procedure bodies that contain the executable code for live and test provisioning, respectively.

Common Use Cases and Queries

This table is primarily accessed during the design-time configuration of provisioning workflows and at runtime when a service order triggers a fulfillment action. Common operational queries involve retrieving the procedures associated with a given fulfillment action for execution or validation. For instance, a developer might query all procedure mappings for a specific fulfillment element to audit configuration. A sample SQL pattern to retrieve the procedural mappings for a known fulfillment action would be:

  • SELECT fafp.fe_sw_gen_lookup_id, pb.procedure_name AS fulfillment_proc, pb2.procedure_name AS test_proc FROM xdp_fa_fulfillment_proc fafp JOIN xdp_proc_body pb ON fafp.fulfillment_proc = pb.proc_body_id LEFT JOIN xdp_proc_body pb2 ON fafp.test_provisioning_proc = pb2.proc_body_id WHERE fafp.fulfillment_action_id = <ACTION_ID>;

Reporting use cases include generating impact analysis reports to understand which fulfillment elements and actions would be affected by changes to a specific procedure stored in XDP_PROC_BODY.

Related Objects

The XDP_FA_FULFILLMENT_PROC table maintains documented foreign key relationships with several key provisioning tables, as per the provided metadata. These relationships are fundamental to its integrity and function:

  • XDP_FULFILL_ACTIONS: Linked via FULFILLMENT_ACTION_ID. This defines the action for which the procedure is defined.
  • XDP_FE_SW_GEN_LOOKUP: Linked via FE_SW_GEN_LOOKUP_ID. This identifies the specific fulfillment element or software component.
  • XDP_PROC_BODY (two relationships): Linked via FULFILLMENT_PROC and TEST_PROVISIONING_PROC. These relationships point to the stored PL/SQL procedure code for standard and test-mode execution.

These relationships position XDP_FA_FULFILLMENT_PROC as a central hub connecting the definitional tables (Fulfillment Actions, Fulfillment Elements) with the executable code (Procedure Bodies) within the XDP architecture.