1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

How to enable Audit Trail in Oracle Apps

Discussion in 'General' started by yowancristo, Nov 25, 2014.

  1. yowancristo

    yowancristo Forum Advisor

    Messages:
    103
    Likes Received:
    10
    Trophy Points:
    305
    Location:
    Bangalore
    Introduction

    This article shows step by step actions to enable Audit Trail in Oracle Apps.

    Background

    Standard features are provided by Oracle to Audit manipulations of transacitons that hit base tables. This article explains how to enable the Audit Trail with an example.

    Steps are shown to enable audit on the table AP_EXPENSE_REPORT_LINES_ALL.

    Steps

    A. Set profile option value 'AuditTrail:Activate' to Yes.

    B. Navigate to System Administrator > Security > AuditTrial > Install
    Query the Application Short Name in the field 'Oracle User Name'. And check the option 'Audit Enabled'
    In this example our table AP_EXPENSE_REPORT_HEADERS_ALL belongs to AP, Hence search for AP and tick the checkbox 'Audit Enabled'.

    C. Navigate to System Administrator > Security > AuditTrail > Groups and create a new group with information shown below.
    Application Name: Payables
    Application Group: AP_EXPENSE_REPORT_LINES_ALL
    Group State : Enabled
    Description : Enable Audit Trail for AP_EXPENSE_REPORT_LINES_ALL

    User Table Name : AP_EXPENSE_REPORT_LINES_ALL

    D. Navigate to System Administrator > Security > AuditTrail >Tables and add necessary columns to be available in Audit table for Ap Expense Lines.

    REPORT_LINE_ID Primary Key
    VAT_CODE
    CREATED_BY
    CREATION_DATE
    LAST_UPDATED_BY
    LAST_UPDATE_DATE

    Save the work.

    E. Run the standard concurrent program 'AuditTrail Update Tables' from System Administrator responsibility.

    This will enable Audit in the table ap_expense_report_lines_all and the name of audit table will be AP_EXPENSE_REPORT_LINES_ALL_A.
    To confirm the same, query the audit AP_EXPENSE_REPORT_LINES_ALL_A table from back end.


    Thanks,
    Yowan Cristo