To Trace Modifiaction

Hello List,

I am new to OneWorld and would appreciate if some one could point me in right direction.

How could one trace the changes that happened in the system? Example will be some body deleted one of the UDC and I would like to find out who? when? etc. Can this be done in OneWorld or I have to go to SQL side.

Topic might have been discussed on the list but unfortunately after complete day of searching, I could not find it on archives.

Kindest Regards,

Hi,

We setup a trace in oracle to follow these kind of things. Each table has a combined trace table.

No history tracking for UDC changes/delete/adds. OW doesn't even check referential integrity before it allows you to delete it. Don't think you can track changes to UDC in OW. Best bet would be to lock all users out of changing UDC and leave this function to SYSAdmin.
Otherwise, someone may have a DBMS solution to this.
But that'll be too late. the change would have been allowed and the damage occured. You'll only be able to restore instead of prevent.

Some other fields have history. Turn them on and you can track changes.

Good Luck.