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?
Solved
Is there a notation in the Functional object tables to indicate who deleted it
+9Best answer by Janitha Jinarajadasa
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.
This topic has been closed for replies.
+18Hi
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
+19Upon 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. ?
/ mayura
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 E-mail address. We'll send you an e-mail with instructions to reset your password.