To remove an application from Maximo we must use a database editor. We only have to delete the applications created by us. Therefore, I emphasize that it is NOT recommended to remove an out-of-the-box application.
Before removing an application, we must stop the Maximo services and, if possible, make a backup of the database.
These are the SQL statements that we must execute to remove an application:
delete from l_maxapps where ownerid in (select maxappsid from maxapps where app='<APPLICATION_NAME>');
delete from maxapps where app='<APPLICATION_NAME>';
delete from maxpresentation where app='<APPLICATION_NAME>';
delete from l_sigoption where ownerid in (select sigoptionid from sigoption where app='<APPLICATION_NAME>');
delete from sigoption where app='<APPLICATION_NAME>';
delete from applicationauth where app='<APPLICATION_NAME>';
delete from l_maxlabels where ownerid in (select maxlabelsid from maxlabels where app='<APPLICATION_NAME>');
delete from maxlabels where app='<APPLICATION_NAME>';
delete from l_maxmenu where ownerid in (select maxmenuid from maxmenu where menutype!='MODULE' and moduleapp='<APPLICATION_NAME>');
delete from maxmenu where menutype!='MODULE' and moduleapp='<APPLICATION_NAME>';
delete from l_maxmenu where ownerid in (select maxmenuid from maxmenu where menutype='MODULE' and elementtype='APP' and keyvalue='<APPLICATION_NAME>');
delete from maxmenu where menutype='MODULE' and elementtype='APP' and keyvalue='<APPLICATION_NAME>';
delete from appdoctype where app='<APPLICATION_NAME>';
delete from sigoptflag where app='<APPLICATION_NAME>';
delete from wfapptoolbar where app='<APPLICATION_NAME>';
Note: Deleting an application does not delete the tables, fields, or domains associated with that application.
If you found my post interesting or useful and just want to say thanks, you can always buy me a coffee.
