Search Results xdp_fmc_aud_trail_dets




Overview
Explore in AI Chat

Overview

The XDP_FMC_AUD_TRAIL_DETS table is a core audit and historical data object within the Oracle E-Business Suite Provisioning (XDP) module. It functions as a detailed log, capturing the complete history of service parameter value modifications associated with a faulty order. This granular audit trail is critical for troubleshooting, compliance, and order lifecycle management, providing a forensic record of changes made to service parameters during provisioning processes, particularly when errors or exceptions occur. Its existence supports diagnostic analysis and ensures accountability for parameter updates within the complex order fulfillment workflows managed by Oracle EBS.

Key Information Stored

The table's structure is designed to precisely identify the changed parameter and its context. The primary key is a composite of three columns, ensuring a unique record for each parameter change instance. The most critical columns include:

  • FMC_ID: The foreign key linking directly to the parent audit header record in the XDP_FMC_AUDIT_TRAILS table. This is the primary identifier for the faulty order audit session.
  • PARAMETER_TYPE: A component of the primary key, this column classifies the category or type of the service parameter that was altered.
  • PARAMETER_NAME: The final component of the primary key, this specifies the exact name of the service parameter whose value was changed.
  • Additional columns (implied by the description) store the historical values, likely including old value, new value, and timestamps related to the parameter change event.

Common Use Cases and Queries

This table is primarily accessed for audit reporting and root cause analysis of provisioning failures. A common scenario involves tracing all parameter modifications for a specific faulty order to identify which change may have caused an error. A typical diagnostic query would join to the parent audit table using the FMC_ID.

Sample Query Pattern:
SELECT det.*, aud.creation_date
FROM xdp_fmc_aud_trail_dets det,
xdp_fmc_audit_trails aud
WHERE det.fmc_id = aud.fmc_id
AND aud.order_number = '<ORDER_NUMBER>'
ORDER BY aud.creation_date, det.parameter_type, det.parameter_name;
This query retrieves the full audit detail for an order, enabling analysts to review the sequence and nature of parameter changes. Reporting use cases often aggregate this data to identify frequently modified parameters or patterns leading to faults.

Related Objects

The table has a direct and essential relationship with the XDP_FMC_AUDIT_TRAILS table, which acts as its parent header. The foreign key constraint XDP_FMC_AUD_TRAIL_DETS.FMC_ID references XDP_FMC_AUDIT_TRAILS.FMC_ID, enforcing referential integrity. This means every detailed parameter change record must be associated with a master audit record for a faulty order. The provisioning module's business logic and APIs, particularly those handling order exception management and audit logging, will populate and potentially query these tables in tandem. Understanding this parent-child relationship is fundamental for any effective data extraction or analysis.