Maximo – Menu – Create a menu items:

A lof of changes, like this, cannot be made via application but via SQL.. damn you IBM.

1. Create a new Test Module

INSERT INTO maxmodules (MODULE,DESCRIPTION,MAXMODULESID)VALUES('TEST','Test Module',(SELECT NVL(MAX (M.maxmodulesid),0)+1 FROM MAXMODULES M ))

2. Create menus for Test module

The module has been created and now we need to put it into the correct position. Value of moduleapp is same as module from maxmodules.

INSERT INTO MAXMENU(MENUTYPE,MODULEAPP,POSITION,SUBPOSITION,ELEMENTTYPE,KEYVALUE,HEADERDESCRIPTION,URL,VISIBLE,IMAGE,ACCESSKEY,TABDISPLAY,MAXMENUID)
VALUES('MODULE','TEST',9500,0,'MODULE','TEST',NULL,NULL,1,'modimg_wo.gif',NULL,NULL,MAXMENUSEQ.NEXTVAL)

btw: you must insert application into this module because empty module is not shown.

3. Attaching an application to the Test Module:

INSERT INTO MAXMENU(MENUTYPE,MODULEAPP,POSITION,SUBPOSITION,ELEMENTTYPE,KEYVALUE,HEADERDESCRIPTION,URL,VISIBLE,IMAGE,ACCESSKEY,TABDISPLAY,MAXMENUID)
VALUES('MODULE','TEST',9510,0,'APP','WOTRACK',NULL,NULL,1,'appimg_wotrack.gif',NULL,NULL,MAXMENUSEQ.NEXVAL)

Functional example

Adding a newapplication View Incident in a new Incident Sub Module under Self Service Module.

Self Service ==> Incidents ==> View Incidents

INSERT INTO MAXMENU( (MENUTYPE,MODULEAPP,POSITION,SUBPOSITION,ELEMENTTYPE,KEYVALUE,HEADERDESCRIPTION,URL,VISIBLE, IMAGE,ACCESSKEY,TABDISPLAY,MAXMENUID)
values ('MODULE','SSDR',3230,0,'HEADER',null,'Incidents',NULL,1,'modimg_wo.gif', NULL,NULL,MAXMENUSEQ.NEXTVAL);

INSERT INTO MAXMENU((MENUTYPE,MODULEAPP,POSITION,SUBPOSITION,ELEMENTTYPE,KEYVALUE,HEADERDESCRIPTION,URL,VISIBLE,IMAGE,ACCESSKEY,TABDISPLAY,MAXMENUID)
values ('MODULE','SSDR3',3230,10,'APP','VWINC',null,NULL,1,'modimg_wo.gif', NULL,NULL,MAXMENUSEQ.NEXTVAL);