Search Results xdp_fmc_audit_trails




Overview
Explore in AI Chat

Overview

The XDP_FMC_AUDIT_TRAILS table is a core data object within the Oracle E-Business Suite (EBS) Provisioning (XDP) module, specifically in versions 12.1.1 and 12.2.2. It functions as an audit and error-handling repository for the service fulfillment process. As per the official ETRM documentation, its primary role is to store responses from upstream systems concerning service fulfillment errors. This makes it a critical table for troubleshooting failed fulfillment orders, tracking error communication between systems, and maintaining an audit trail for diagnostic and compliance purposes within the complex order-to-activation workflows managed by Oracle Provisioning.

Key Information Stored

While the provided metadata does not list all columns, the documented primary and foreign keys reveal the essential structural data points. The primary key, FMC_ID, uniquely identifies each audit trail record. The WORKITEM_INSTANCE_ID column is a foreign key linking each audit entry to a specific work item in the fulfillment process, stored in the XDP_FULFILL_WORKLIST table. This connection allows analysts to trace error responses back to the exact fulfillment task that failed. The table's description indicates it holds the response payload or message from the upstream system, which would typically be stored in additional columns not listed, potentially containing error codes, descriptive text, timestamps, and system identifiers.

Common Use Cases and Queries

The primary use case is diagnosing and reporting on service fulfillment failures. Support and operations teams query this table to understand why an order provisioning step did not complete. A common query pattern involves joining to the worklist table to get order context. For example, to find all audit trails for a specific work item: SELECT * FROM XDP_FMC_AUDIT_TRAILS WHERE WORKITEM_INSTANCE_ID = <instance_id>;. For broader reporting, a join retrieves work item details: SELECT wl.*, audit.* FROM XDP_FMC_AUDIT_TRAILS audit, XDP_FULFILL_WORKLIST wl WHERE audit.WORKITEM_INSTANCE_ID = wl.WORKITEM_INSTANCE_ID AND wl.STATUS = 'ERROR';. This table is also central to any custom interface monitoring or error-dashboard reports built within the EBS environment.

Related Objects

The documented foreign key relationships explicitly define this table's integration within the XDP schema. It has two key dependencies:

  • XDP_FULFILL_WORKLIST: This is the parent table. Each record in XDP_FMC_AUDIT_TRAILS is associated with a specific fulfillment work item via the foreign key on WORKITEM_INSTANCE_ID.
  • XDP_FMC_AUD_TRAIL_DETS: This is a child table. The primary key FMC_ID in XDP_FMC_AUDIT_TRAILS is referenced by the foreign key in XDP_FMC_AUD_TRAIL_DETS, suggesting a one-to-many relationship where a single audit header may have multiple detailed audit lines.
These relationships form a logical chain from the work item (XDP_FULFILL_WORKLIST) to the error response header (XDP_FMC_AUDIT_TRAILS) and its associated details (XDP_FMC_AUD_TRAIL_DETS).