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,