Deleting Maximo Application

Deleting Maximo Application

Deleting an application in Maximo is not possible from Front End and it's not advisable too. You can remove the security rights of that application so that it doesn't appear in Go To list.

Still, if you want to delete an Application in Maximo, you have to accomplish it using SQL Scripts which will be executed in the back-end.

Following are the scripts:

delete from maxapps where app='<appName>';
delete from maxpresentation where app='<appName>';
delete from sigoption where app='<appName>';
delete from applicationauth where app='<appName>';
delete from maxlabels where app='<appName>';
delete from maxmenu where moduleapp='<appName>' and menutype !='MODULE';

To remove Label information from database, run the following queries:

delete from L_SIGOPTION where L_SIGOPTIONID in (select L_SIGOPTIONID from SIGOPTION,L_SIGOPTION  
  where (SIGOPTION.SIGOPTIONID=L_SIGOPTION.OWNERID AND app='<appName>'))

delete from L_MAXLABELSID where L_MAXLABELSID in (select L_MAXLABELSID from MAXLABELS,L_MAXLABELS
  where (MAXLABELS.MAXLABELSID=L_MAXLABELS.OWNERID AND app='<appName>'))

delete from L_MAXMENUID where L_MAXMENUID in (select L_MAXMENUID from MAXMENU,L_MAXMENU where (MAXMENU.MAXMENUID=L_MAXMENU.OWNERID AND moduleapp='<appName>'))