Question
Prevent Decommissioned and Not Ready locations from getting displayed in the locations lookup
Answer
Workaround:
1. Go to the domains application. Create a new Table domain
click New Row button. Enter the following:
DOMAIN: OPERATINSTATUS
Object: LOCATIONS
List Where Clause:
siteid=:assetsiteid and status in (select value from synonymdomain where domainid=’LOCASSETSTATUS’ and maxvalue=’OPERATING’)
Validation Where Clause:
siteid=:assetsiteid and status in (select value from synonymdomain where domainid=’LOCASSETSTATUS’ and maxvalue=’OPERATING’)
Error Message Key NotValidLoc
Error Message Group locations
NOTE: all these fields are case sensitive
2. Go to database configuration application
search for Object=SR and attribute=LOCATION
3. On the location attribute, enter OPERATINSTATUS in the domain field
4. Shut down the Maximo Server
5. Run the ConfigDB.bat under MaximoToolsMaximo directory
6. Restart the Maximo Server
7. Go to the Create Service Request application, click on the Select Value besides the Location field. Now you will only see locations that are in Operating status
i.e. You will not see any location that has NOT READY / DECOMMISIONED status [IBM Support]
About Chon Neth
