Upon execution, the Audit Trail Update Table concurrent request performs the following tasks:.
1) Creates shadow tables, one for each audited table, to contain the audit information.
2) Creates database triggers on the tables in your audit groups for your installations.
3) Creates two views for each column with the names _AC# and _AV# where # is a s.
You may disable auditing at any time. When you disable auditing, you should do the following procedure:.
1) Stop auditing new transactions.Disable auditing using either "Disable - Prepare for Archive" or "Disable - Interrupt Audit" and running the Audit Trail Update Tables report.
2) Archive your audit data.You should archive the information in the .
Oracle provides functionality to address this, but some EBS customers, concerned that audit tracking may create performance issues, don’t enable it
Too often, audit tracking in EBS has been an afterthought to the overall implementation, when it should be a core component
Important:Because the structure of the audited table may change between product versions, Audit Trail does not support upgrading existing shadow tables or audited data. Before an upgrade, you should archive the shadow tables and perform all necessary reporting on the audited data. Auditing database row changes is performance intensive. Limit auditi.
We recently announced the certification of unified auditing with Oracle E-Business Suite (EBS) Release 12
2This blog article is part two in a series of blog articles to highlight the certification of unified auditing with EBS Release 12
2What Should You Do To Prepare to Enable Unified Auditing?
You can choose to store and retrieve a history of all changes users make on a given table. Auditing is accomplished using audit groups, which functionally registered Oracle IDs or group tables to be audited. For a table to be audited, it must be included in an enabled audit group. Audit Trail Groups are groups of tables and columns. You do not nece.
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) Pur.
Audit Trail reports are not provided with Oracle E-Business Suite. You may write audit reports as needed using SQL. Audit Trail provides the views of your shadow tables to make audit reporting easier; you can write your reports to use these views. You may want to create one or more indexes to your shadow table to speed up your reporting. However, s.
If desired, you can restart auditing by setting the audit group to Enable Requested and running the Audit Trail Update Tables report again. Important:If you disable using Disable Purge Table and then re-enable auditing for a table, Audit Trail flushes the contents of the shadow table when auditing is re-enabled. You should archive any shadow table .
To enable Oracle E-Business Suite Audit Trail, review and perform the following steps as required:.
1) Granted required privileges.Have your database administrator grant SELECT privileges on SYS.DBA_TABLES to the APPLSYS account. Normally, this step will already have been done as part of the installation or upgrade.
2) Register custom tables and pri.
Tables to Audit with Audit Trail
Audit Trail stores change information in a shadow table of the audited table
This mechanism saves audit data in an uncompressed but sparse format, and you enable auditing for particular tables and groups of tables (audit groups)
Additional details for enabling the Audit Trail are found in Enabling Oracle E-Business Suite Audit Trail
Traditional auditing is recommended for Oracle E-Business Suite releases prior to 12
211 if the minimum required for Unified Auditing with Oracle E-Business Suite Release 12
2 have not been metSee My Oracle Support Knowledge Document 2793599
1, Traditional Database Auditing with Oracle E-Business Suite Release 12
2, for more informationWe recently announced the certification of unified auditing with Oracle E-Business Suite (EBS) Release 12
2This blog article is part two in a series of blog articles to highlight the certification of unified auditing with EBS Release 12
2What Should You Do To Prepare to Enable Unified Auditing?
EBS functionality to log Web and HTML use and navigation
Configured through Oracle Application Manager and stores audit data in JTF_PF_* tables
Concurrent programs to stage data daily
AuditTrail functionality stores row changes to EBS tables in shadow tables using database triggers
Only tracks insert, update, and deletes to Oracle EBS tables
Standard EBS functionality to log Professional Forms use and navigation
Enabled by the system profile option Sign-on: Audit Level and the default is None
EBS functionality to log Web and HTML use and navigation
Configured through Oracle Application Manager and stores audit data in JTF_PF_* tables
Concurrent programs to stage data daily
