Skip to main content

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? 

Hi @Nipun Gunaratne 
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

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 @Nipun Gunaratne ,

 

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.

Terms & ConditionsCookie settings