Audit Trail Standard Columns

[Saad Qaiser Khan]

Hello,

I have enabled the audit trail on UAT server. I found that oracle adds four columns by itself by default like
AUDIT_TIMESTAMP
AUDIT_TRANSACTION_TYPE
AUDIT_USER_NAME
AUDIT_TRUE_NULLS

These have information on internet also.

but what I do not understand are these

AUDIT_SESSION_ID
AUDIT_SEQUENCE_ID
AUDIT_COMMIT_ID
ROW_KEY

Can you please tell me what are these 4 above columns for?

Thanks and Regards,
Saad

[ErmanArslansOracleBlog]

There is no detailed description for these columns and they are actually not important columns (except the audit_session_id, in my opinion)

 AUDIT_SESSION_ID(NUMBER): ID for the session.
 AUDIT_COMMIT_ID (NUMBER): ID for the COMMIT.
 AUDIT_SEQUENCE_ID : ID for the COMMIT.
 ROW_KEY not needed at all.

[Saad Qaiser Khan]

https://docs.oracle.com/cd/A60725_05/html/comnls/us/fnd/auddat02.htm

found this document after a lot of searching but this line

Changes to the primary key are marked as deletes, but new primary key values are inserted also.

does it telling about row_key or primary key of tables?

I think its telling about primary key of table.

Can you please clear this? I am bit confused

Regards,
Saad Khan

[ErmanArslansOracleBlog]

This document is for EBS 11i.

I don't know your version but, the column name may have changed. At that time, the name of the column may be primary_key, but in your version it may be changed to row_key.

If you are asking about the row key, then check it..

Take a table as an example, check the table and see if the row key is defined as the primary key of the table.

I think row_key column is the primary key in your case.