Query to Find duplicate Records

   select A, B, C,

       count(*)

from   Mytable where  'My Where clause'

group  by A,B,C,

having count(*) > 1;

Select a folder is empty in Maximo Attachments for custom application

Select a folder shows no option for attachments

Run this query

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

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

commit;

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));

Implementing Multi select lookup

 Steps to enable or implement multiselect lookup in Maximo.

PMWogen is not working

 reason

1. Asset on PM or Location on PM or Asset or location on routestop on route of pm is Not ready i.e not operating or Active....

2. PM is inactive

3. PM is not due yet

4. Some customization causing issue.

5. Cron not active.  

6. Security Access with User running cron...

7. Organization option related to PM...