Viewing Work Notes and Comments for Audit Purposes


Description

When it is desired to view user activity related to adding Work Notes/Comments in the system over some period of time, querying the sys_audit table is inefficient.

Release or Environment

All

Resolution

Seeing what user created work notes on tables that include Work Notes and Comments can be done by querying the sys_journal_field table, and using the desired conditions.


A query using "Name" (the table the record is associated with), "Element" (= 'work_notes') and add the 'Created' and 'Created by' fields to a list view of the table's records.