What is difference between database logging and audit trails when I run report I see a bunch of transactions and who created etc but how is this enabled and how do you set this up?
How is audit trails set up?
The audit trail is a log related to ledger transaction postings. Using this feature, multiple related records can be reviewed to analyse what happened in the system. Assume there was a journal with 30 vouchers posted. If you are looking at one ledger transaction, you can go to the audit trail to be able to see all 30 vouchers which were posted at the same time. This audit trail is always related to a new transaction posted in the ledger.
The database log is a mechanism where you can setup which tables and/or fields should be logged when there is a record created, updated or deleted, but there is no tracking for possible related changes. E.g. the creation of a vendor bank account and then also having this changed as default bank for the vendor are two separate log records.
How does audit trails get enabled I am looking at audit trail report and see several lines but how does it get enabled in first place... or is this automatically enabled by default? Is it just ledger trans? Thanks
Like I tried to mention above, the audit trail is always related to new ledger transactions. It is always running. There is no configuration for it.
Business Applications communities