+9
Upon DELETE of a Functional Object - is there a notation in the tables to indicate who deleted it? Apart from History Logging, are there other ways to determine who may have deleted a functional or serial object in the Equipment_Object_Tab?
Best answer by Janitha Jinarajadasa
View original
+18
Hi
In Equipment_Object_Tab table we couldn't trace any deleting object as its completely deleting record from this table itself. As the only below status available in Equipment_Object_Tab Active,Inactive,ReDesign,PlannedForOperation,Scrapped there is no way to remain the DELETED object.
History login is the option we can use for this purpose. Otherwise we can try a trigger to fetch the information while removing the record.
Best Regards
-Kelum
+15
Upon DELETE of a Functional Object - is there a notation in the tables to indicate who deleted it? Apart from History Logging, are there other ways to determine who may have deleted a functional or serial object in the Equipment_Object_Tab?
What is the business requirement here? Could we use the “Scrap” option that maintain the traceability instead Delete. ?
Hi
This should be possible if oracle Audits are enabled in customer. Most probably its disabled.
So other possible scenario would be to create a custom event to catch the deletion.
Create a custom event for table EQUIPMENT_OBJECT_TAB to fire when ‘Objects are removed’ . User id can be taken from the session. Create an appropriate action (eg: Email) to gather the information.
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
