Search Results icx_audit




Overview
Explore in AI Chat

Overview

The ICX_AUDIT table is a core data object within the Oracle iProcurement (ICX) module of Oracle E-Business Suite (EBS) versions 12.1.1 and 12.2.2. As its documented description states, it serves as the web transactions audit table. Its primary role is to log and persist detailed audit trails for user interactions and transactions conducted through the iProcurement web interface. This table is fundamental for security monitoring, compliance reporting, and troubleshooting user activity, providing a historical record of procurement-related actions performed within the EBS environment.

Key Information Stored

The table captures a comprehensive set of attributes for each audited event. Based on the provided metadata, the structure is anchored by a primary key column, AUDIT_ID, which uniquely identifies each audit record. Two critical foreign key relationships are explicitly documented, linking the audit data to user and session information. The column ICX_AUDIT.SESSION_ID references the ICX_SESSIONS table, tying each audit entry to a specific user session. The column ICX_AUDIT.WEB_USER_ID references the FND_USER table, definitively associating the activity with an EBS application user. While the full column list is not detailed in the excerpt, a typical ICX_AUDIT table would also store data such as transaction type, timestamp, IP address, function or page accessed, parameters submitted, and details about the specific procurement operation performed.

Common Use Cases and Queries

This table is essential for generating audit reports and conducting forensic analysis. Common use cases include investigating specific user actions, tracking the history of a procurement document, and generating compliance reports for internal or external auditors. A foundational query retrieves a user's activity by joining with FND_USER for the username.

  • Sample Query: Basic Audit Trail for a User
    SELECT a.audit_id, u.user_name, a.creation_date, a.transaction_type
    FROM icx.icx_audit a,
         applsys.fnd_user u
    WHERE a.web_user_id = u.user_id
    AND u.user_name = 'JDOE'
    ORDER BY a.creation_date DESC;
  • Sample Query: Session Analysis
    SELECT a.*, s.session_id
    FROM icx.icx_audit a,
         icx.icx_sessions s
    WHERE a.session_id = s.session_id
    AND s.creation_date > TRUNC(SYSDATE-1);

Related Objects

The ICX_AUDIT table has defined dependencies on other key EBS objects, as per the provided metadata. The primary foreign key relationships are with the ICX_SESSIONS table, which manages web session data, and the foundational FND_USER table, which stores all application users. These relationships are critical for enriching audit data with contextual user and session information. While not listed in the excerpt, this table may also be referenced by standard iProcurement audit reports, custom BI Publisher templates, or other diagnostic scripts within the ICX product family. Its data is often the source for purging or archival programs managed by the Oracle Applications DBA.