Oracle Cloud offers a broad portfolio of software as a service applications, platform as a service, and social capabilities, all on a subscription basis. Oracle Cloud delivers instant value and productivity for end users, administrators, and developers alike through functionally rich, integrated, secure, enterprise cloud services.
 Get a Free Magzine ...Profit:The Executive's Guide to Oracle Applications

Subscribe to the OracleAppsHub to receive notifications when there are new posts:

 get RSS feed
 Oracle Fusion Applications (OFA) is a portfolio of next generation suite of software applications from Oracle Corporation. It is distributed across various product families; including financial management, human capital management, customer relationship management, supply chain management, procurement, governance, and project portfolio management
 Get a Free Magzine ...Profit:The Executive's Guide to Oracle Applications

ADVANCED AUDIT

Posted on July 18th, 2011 by Sanjit Anand ||Email This Post Email This Post

Have you tried OracleappsHub in ipad/iphone/smart Phone? Don't wait. try it today

Oracle E-Business Suite implements its own auditing mechanisms, Audit Trails.

Auditing database row changes is performance intensive. Limit auditing to non-transactional data. Auditing transactional data may cause significant performance degradation. Tables with more than a few changes an hour should not be considered for row level auditing. Plan and consult with a DBA before enabling Audit Trails.

This feature keeps a complete history of changes made at a table and column level. When initialized, a concurrent program creates a shadow table and places triggers on the columns to be audited. The triggers store column changes in the shadow table (a table whose name is the instance table’s name appended with _A)

dgreybarrow CONFIGURING AUDIT TRAIL

To enable Audit Trail, follow these steps:

  1. Set System profile option AuditTrail: Activate to True
  2. Navigate through Security -> AuditTrail -> Install to set schemas for auditing
  3. Navigate through Security -> AuditTrail -> Groups to create audit groups and set tables to be audited. Set audit group to Enabled Requested
  4. Navigate through Security -> AuditTrail -> Tables to set columns in tables to be audited
  5. Run AuditTrail Update Tables to activate auditing

dgreybarrow PURGE AUDIT TRAIL RECORD

Purge the audit trail information on a regular basis. Prior to purging, disable the Audit Trail. Use the following procedure to purge audit data:

  1. As System Administrator, select Security -> Audit Trail -> Groups.
  2. Select the Security Audit group and set the group state to Disable – Purge Table.
  3. Run the Audit Trail Update Tables Report.
  4. Purge the data from the shadow table.
  5. Select Security -> Audit Trail -> Groups.
  6. Select the Security Audit group and set the group state to Enable.
  7. Run the Audit Trail Update Tables Report
Related Posts

Posted in Oracle Application | No Comments »Email This Post Email This Post |

Have you tried OracleappsHub in ipad/iphone/smart Phone? Don't wait. try it today
Leave a Comment

Please note: Comment moderation is enabled and may delay your comment. There is no need to resubmit your comment.