EBS Auditing and Monitoring

AuditTrail 保留了以下三个问题的历史记录：
What changed 什么改变了
Who changed it 谁改变了
When did the change take place 改变什么时候发生的

Here’s additional informaiton on auditing:

• http://docs.oracle.com/cd/E51111_01/current/acrobat/122ebssc.pdf – Take a look at Chapter 5 Auditing and Monitoring

NOTE:1622411.1 – How to Capture IP Address for User Transactions?
NOTE:402116.1 – Page Access Tracking in Oracle Applications Release 12
NOTE:60828.1 – Overview of Audit Trails in Oracle E-Business Suite Applications
NOTE:420996.1 – How to Enable the Audit Trail On the Table APPLSYS.FND_USER
NOTE:1600075.1 – How To Determine The Current Value and Set The Retention Time To Keep the Runtime Instance Data Of Table FND_OAM_FORMS_RTI In The Database?
NOTE:1355549.1 – how To Show The Client IP Address In The Access Log When Using A Load Balancer
NOTE:751658.1 – How to Get the terminal ID for the Machine From Which a User is Logged to E-Business Suite Applications
NOTE:1900795.1 – R12 E-Business Suite Technology Stack Forms Session Timeout Occurs Even While Logged In To the Core EBS Applications
NOTE:107330.1 – FAQ on E-Business Audit Trail
NOTE:1642530.1 – Can The FND_USER Table Be Used For Auditing Purposes In Tracking The Password Changes
NOTE:233871.1 – 11i : Oracle Application Object Library Active Users Data Collection Test
NOTE:69660.1 – E-Business Suite Applications Auditing FAQ For Understanding Data Auditing in Oracle Applications Tables using Audit Trail (AuditTrail)
NOTE:99176.1 – Signon Audit Users report showing users that are no longer logged on
NOTE:567954.1 – Audit Trail Update Tables Failing on AP_SYSTEM_PARAMETERS_AC1 View
NOTE:383053.1 – How To Remove a Column From Audit Trail Tables?
NOTE:393582.1 – How to Cleanup Auditing on an Applications Audited Table OR Address: APP-00016
NOTE:879092.1 : How To Find The IP Address Of The Client Machine From Where A Particular Forms User Is Connected ?
NOTE:878931.1 : How to Track IP Address of the Form Session in Oracle application 11i

#Doc ID 60828.1
The following is an example of a _A Shadow Table, FND_LOGINS_A:
Name Null? Type
---------------------- ------- ----
AUDIT_TIMESTAMP NOT NULL DATE
AUDIT_TRANSACTION_TYPE NOT NULL VARCHAR2(1)
AUDIT_USER_NAME NOT NULL VARCHAR2(100)
AUDIT_TRUE_NULLS VARCHAR2(250)
AUDIT_SESSION_ID NOT NULL NUMBER
AUDIT_SEQUENCE_ID NOT NULL NUMBER
AUDIT_COMMIT_ID NOT NULL NUMBER
LOGIN_ID NUMBER
END_TIME DATE
START_TIME DATE
LOGIN_NAME VARCHAR2(30)