AnsweredAssumed Answered

In the database, how can I see who updated the resource department and location field?

Question asked by matpj on Sep 2, 2014
Latest reply on Sep 3, 2014 by pjromano

Hi guys,


we are using 12.1.3 at the moment and are building auditing capability to include the resource financial fields in the standard audit trail.


the trouble we are facing at the moment is an inability within the database to identify the user who makes a change to the financial fields.  The PAC_MNT_RESOURCES table does not have a last_Updated_by field



Can anybody suggest an alternative way of doing this.

or some trigger pl/sql that picks up the session user?


Thanks in advance,