Viewing Work Notes and Comments for Audit Purposes


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



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.