Date and time is not coming in oracle sql developer for DateTime Field.

Date and time is not coming in oracle sql developer

Go to Tools> Preferences > Database > NLS and set the Date Format as MM/DD/YYYY HH24:MI:SS

Maximo Functional Interview questions

 Functional interview Questions :-

1. What is an Asset, Item?( Remeber Asset num is unique and item num is common.. rotating asset is something that we track can be repained but not replaced..and move or out from inventory....

2. On what basis you can select architecture to be single site / multisite etc.(Remember glaccounts)...
3. What are ways you can create Work order in Maximo?
4. What are ways you can create Invoice in Maximo?
5. What is Asset life cycle?
6. What is Purchasing Life Cycle?
7. What are different modules of Maximo?
8. How many types of contract can be created in Maximo?
9. What is EAM?
10. Explain reorder process?
11. Explain Pm functionality and how earliest next due date calculated?
12. How do you configure security groups?
13. What is an independent security group and dependent security group?
14. You have uploaded some workorders and next day activated pmwogen cron which created some more wo's ? Now client does not wants pmwogen wos sequence to be after uploaded wo's sequence how would you correct it?
15. What is reorder point and economic order quantity?
16. How to call an automation script from another automation script?
17. What type of assets are focus in Maximo?
18. What is the difference between TSRM, SCCD and Maximo
19. What is the difference between Maximo 7.5 and 7.6.
20. How to let maximo not to track status history for tasks workorder?

21. What are features of Maximo 7.6
22. How will you make Maximo Service request application to work as a work order if in case client requires it ? Is it possible?

23. Is there any search criteria for vendor if yes where and how it is used if not how can we create one....in case of po creation automatically by system....

24. Where does entry for Order number (PONUM) for reciept from PO created in vendor ERP goes in maximo.........?

25. What will be setup and what value to be setup for say your invoice is just double the Po cost.?

24. What is required to create a compony in Maximo?.............

25. Can a non-stock material have a storage location in Maximo?

26 Explain in basic terms why we create Company master and Item master? Why we design maximo like that instead of directly creating a item's ?........

27. What is FOB and NET30 ? //Net 30 is 30 days of credit i.e vendor gives you 30 days for the payment and FOB is free of board means vendor will diliver the goods at your warehouse these are payments terms and frieght terms.....

28. If a pm has both route and location? then how many workorders'  will the pm will generate from pmwogen  or manually?

29 How to transfer an asset from one storeroom to another ( hint inventory usage)

30 How u can manage missing/found scenarion in asset application?

31. What is QBR reporting?

32. What are stocked , Non stocked and special items...

33. What is required to track inventory cost when issueing item ( Either it should HV one of the following. Wo, gl debit, location or an asset... So maximo will charge against it... ) 

Team Lead Questions..(If you are going for this position pls. answer confidently)

1. How u use Agile in your project.. what's the process...?

2. How do you handle difficult clients..?

3. How you keep team motivated...?

4. How much you are involved in Solutioning..

5. What is the size of team you are handling...

6. What are your day to day activities as a Team Lead...

Add space between table column in maximo / Increase width of table column

 Add space between table column in maximo / Increase width of table column

Steps 

1. In table add width like width="1200" in application xml.

2. In table column add width like width="120".

import xml.

SOP

 What is an SOP document:- 

When we get a ticket we fix it using configuration, automation or customization which goes release process. Their are some fixes which are repeated for which we can define clear-cut step by step instructions these are  defined in our SOP document.

Maximo best practices

What are maximo best practices as a technical consultant

1. Go for server restart when u can't get desired results from application restart else use application restart.

2. Do no use Create statement use prepared statement for Update.

3. Do no use printstacktrace use logger.

4. raise TypeError(complewhere) instead of using print while debugging issue in autoscript.

5. Whenever designing a workflow think about all possibilities for example what happen in case record does not have role present to which you are assigning what will happen if it gets to delegate of person? never assume their will always be role what will happen for else logic in condition this way you can frame more questions for Client and make your workflow more safe.

6. Do not use Customization more than necessary try to simplify things by confirmation only for example its always a bad practice to use same field for 2 different purposes and use the script or class to populate or set value for such field instead if you can achieve the same using a single field.

7. Before starting integration always ask whether the requirement is for Synchronous or Asynchronous.

8. Do regular refresh of Lower environments and Keep one environment as Out of box.

9. Clean junk code/escalation/logging in your environment which are no longer necessary once in every couple of years.

10. Check health of you system regularly  like time taken to run queries, time for startcenter load.

11. Do check with IBM PMR team in case you are not sure for implementation rather than assuming.

12. Maintain product.xml

13. Do not use errorgroup and errorkey instead using service.error because service.error will stop the flow from further execution unlike the errorgroup and errorkey.

14. Use best coding guidlines of language u are using like java/ python etc.

15. Use lot of comments in your code.

16. Seperate custom things with names like X or Cust.

17. Put your Custom classes in custom (Customer name folder ) example put your workorder classes in micorsoft.workorder folder if microsoft is your client.

18. Rather than Multiple If 's use If else if else if ........else. in java code and python scripts...

19. Use break and continue inside scripts..

20. Use datasource mainrecord for Sigoption.. so to specify which object you are referring to with the sigoption 

Changing Item status at particular location from Obsolete to Active

 Changing Item status at particular location from Obsolete to Active

Script to do this : -

Query to Change inventory status 

Query to delete status in History 

Reasons for not installing Maximo with Root account

 Reasons for not installing Maximo with Root account

1. For small small work like Was patching you will be require root account access inorder to install updates on websphere or db...

Fastest Way to clear AWS Developer Associate Certification

 1. Complete stephen's course form Udemy.

2. Complete dumps from Youtube.

3. Go throw AWS site for certification topics and whitepapers.

4. Practice Stephen's dumps.

Changing lookup Dynamically on field in Maximo

 Basically their are 2 ways to changing lookup id on a field 

1. In field class override getLookupName Method and return lookup name.

2. Configure conditional properties in sigoption advance tab on field to set lookup name.

Maximo Remove blank from combobox

 Blank is added because user can't able to remove value from picked list. If the value is not blank or cannot be set to blank then set allowblank="false" in xml and set default value in attribute in db config.

Internal Server Error mxloader /meaweb/os/MXASSET

 Internal Server Error mxloader /meaweb/os/MXASSET

500 error 

can be possible your MIF jvm is down and only ui is up.

Command to check java class version

Check version of java class by command prompt windos

set path=Path of Java C:\Program Files\Java\jdk1.8.0_291\bin

cd Path_where_class_exists

Path_where_class_exists:>  javap -verbose Your_class_Name findstr "major"

or copy the class in java/folder and run command

Version 51 :- Java 7

Version 52 :- Java 8

Maximo Go To application is not working + Appends where clause

 Maximo Go To application is not working  

One reason could be maxlookup map entry, these entries which gets appended whereclause in applicaiton you are linking.  Please use script to map these values instead of maxlookup map........

Adhar card error We are unable to reach authentication service to serve you OTP. Please try again later

 Your mobile no is not updated on Adhar please visit nearby adhar center to update your mobile no. Maximum time to update is 60 days to 90 days....

AWS Certification Path and training material

 AWS Certification Path and training material

1. Go to through whitepaper.

2. Go through online dumps.

3. Go through faq's on aws site 

BMXAA5654I - Package preview or deploy is in progress

 2 ways resolve :-

your package in inprogress either update it or set deploy in progress

select * from dmpkgstatus where status ='DEPLOY_INPROGRESS' ;

or select * from maximo.DMPACKAGE where 

status='DEPLOY_INPROGRESS' ;

1. find you latest package and either udpate it from db using query 

UPDATE MAXIMO.dmpkgstatus SET STATUS='DEPLOYED' WHERE  status ='DEPLOY_INPROGRESS' ;

or click on continue deploymed in migration manager.

BMXAA7107E - site is not allowed because the Site of the classification must match the Site of the children and attributes.

 Go to selection action associated attributes 

Their site id is mentioned on your attribute i.e why when u are crating attriute without siteid its not taking as you need to remove that attribute from associated list.

another reason could be classification or child classification in associate classification dialog has siteid and orgid i.e it its giving this error.

check index on field or checking index before deliting in sql explorer oracle

 Right click on connection.

Select Schema browser

Select your schema

Select you table 

Go to Index tab

you will be able to see unique indexes.

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...