Adding attachment to custom application Maximo

Note : Cloned application does not require these steps. 

run these queries to create sigoption

insert into maximo.sigoption (hasld,esigenabled,langcode,optionname,description,app,visible,sigoptionid)

values (0,0,'EN','ASSOCFOLD','Associate Folders','App Name',1,SIGOPTIONSEQ.nextval);

insert into maximo.sigoption (hasld,esigenabled,langcode,optionname,description,app,visible,sigoptionid)

values (0,0,'EN','MANAGEFOLD','Manage Folders','APP Name',1,SIGOPTIONSEQ.nextval);

insert into maximo.sigoption (hasld,esigenabled,langcode,optionname,description,app,visible,sigoptionid)

values (0,0,'EN','MANAGELIB','Manage Library','APP Name',1,SIGOPTIONSEQ.nextval);

run following queries

Insert into MAXMENU (MENUTYPE,MODULEAPP,POSITION,SUBPOSITION,ELEMENTTYPE,KEYVALUE,HEADERDESCRIPTION,URL,VISIBLE,IMAGE,ACCESSKEY,TABDISPLAY,MAXMENUID) values ('APPMENU','APP NAME',250,30,'OPTION','ASSOCFOLD',null,null,1,null,null,'ALL',MAXMENUSEQ.NEXTVAL);

Insert into MAXMENU (MENUTYPE,MODULEAPP,POSITION,SUBPOSITION,ELEMENTTYPE,KEYVALUE,HEADERDESCRIPTION,URL,VISIBLE,IMAGE,ACCESSKEY,TABDISPLAY,MAXMENUID) values ('APPMENU','APP NAME',250,20,'OPTION','MANAGEFOLD',null,null,1,null,null,'ALL',MAXMENUSEQ.NEXTVAL);

Insert into MAXMENU (MENUTYPE,MODULEAPP,POSITION,SUBPOSITION,ELEMENTTYPE,KEYVALUE,HEADERDESCRIPTION,URL,VISIBLE,IMAGE,ACCESSKEY,TABDISPLAY,MAXMENUID) values ('APPMENU','APP NAME',250,10,'OPTION','MANAGELIB',null,null,1,null,null,'ALL',MAXMENUSEQ.NEXTVAL);

Add entry to applicationauth

INSERT INTO APPLICATIONAUTH (GROUPNAME, APP, OPTIONNAME, APPLICATIONAUTHID) VALUES ('MAXADMIN', 'APP NAME', 'MANAGEFOLD',APPLICATIONAUTHSEQ.NEXTVAL); INSERT INTO APPLICATIONAUTH (GROUPNAME, APP, OPTIONNAME, APPLICATIONAUTHID) VALUES ('MAXADMIN', 'APP NAME', 'ASSOCFOLD',APPLICATIONAUTHSEQ.NEXTVAL); INSERT INTO APPLICATIONAUTH (GROUPNAME, APP, OPTIONNAME, APPLICATIONAUTHID) VALUES ('MAXADMIN', 'APP NAME', 'MANAGELIB',APPLICATIONAUTHSEQ.NEXTVAL);

RELATIONASHIP

insert into maxrelationship

( name, parent, child, whereclause, remarks,

maxrelationshipid)

values

('DOCLINKS', 'EX8ROLE', 'DOCLINKS', 'ownertable = ''MAIN OBJECT'' and ownerid = :ID FIELD', 'Relationsip to the doclink table',

maxrelationshipseq.nextval);

*****iMP 

INSERT INTO MAXIMO.APPDOCTYPE (APP, DOCTYPE, APPDOCTYPEID) VALUES 

('Appr Name', 'Attachments', (MAXIMO.APPDOCTYPESEQ.NEXTVAL));