Our Maximo

   Split string and extract nth word in Oracle Here I am taking 5 word from string glaccount example  222-333-23434-2222333-000-0000-888 select REGEXP_SUBSTR(glaccount, '[^-]+', 1, 3) AS glaccount from Workorder Output : 23434  Here  we are separting word with delimitter - if you have comma replace hiphen with comma.

 Giving error in Maximo on New Row using Automation Script Give exception to user on click of New Row :- For this you need to use Object Creation type object launchpoint which is equivalent to canAdd Method in Maximo MBo's and give this  service.error("MESSAGEGROUP",MESSAGEKEY")

Getting Mboset from session / Getting Mboset from Memory   This is typical sometimes you need to supply attribute of newly created MBO like id field to a child object which is in Memory on save of object.  When we do getMboSet ()  we don't get this object because its in Memory and get Mboset get it from db via relationship Inorder to do this you need to explicity get object from MXserver.getMboset() and then  call Add() method and save it. Now in child Mbo you will get that object.

 If this error occurs in your new customization then don't change boolean value on initialize  because at initialize it will be blank although you suppied default to 0 but it will not catch this value.