Technical Blog Post
How do I decommission a storeroom that is no longer needed?
In Maximo 7.1 and 7.5, storeroom locations are not status-able objects. This means that storerooms that have no inventory items in them, and are no longer in use for any reason, are still available in applications and location lookup dialogs. Currently there is a Request for Enhancement record created to add this functionality to future releases of Tpae, however there is a way to set this up to prevent these storerooms from being visible to users using current releases, without significant administration efforts.
The following sets of instructions show an example of how you can mark storerooms as decommissioned, preventing them from showing up for users in applications. You can customize these instructions to meet your specific needs.
1. The first step is to add a field to the LOCATIONS object within the database configuration application as a YorN field. Once added, run configdb
2. Next, add the field to the storeroom application in application designer:
3. Navigate to Application Designer and bring up the storeroom application
4. Add the new Decommissioned field to the storeroom tab
5. Save and log out and in again, navigating to the storeroom application, and select a storeroom, then check the "decommissioned" checkbox, saving the record
6. Now navigate to the Conditional Expressions application and create a new condition
7. Add the following to the where clause and save the condition:
8. Next, navigate to the security groups application and select a security group who should not see these storerooms
9. Click on the Data Restrictions tab and then, on the object restrictions tab, select the LOCATIONS object
10. Set the type to QUALIFIED and set select the new condition you created above from the lookup
11. Save the restriction and log out and in again with a user that should not be able to view the storeroom you decommissioned and test
In order to filter the location field in the affected applications, a table domain needs to be created, and added to the field representing the storeroom for each application in database configuration. In the following example, the steps to do this for the PR application are shown below:
1. Navigate to the domains application and create a new Table domain.
2. Give it a name, such as STOREROOMS.
3. Enter the following in the list where clause as well as the validation where clause fields:
TYPE='STOREROOM' AND DECOMMISSIONED='0'
Set the Error Message group value to "locations"
Set the error message key to "NotValidLoc"
4. Save the changes
5. Navigate to database configuration and bring up the PR object. On the attributes tab, select the STORELOC attribute
6. enter the domain created above called STOREROOMS in the domain field, save the changes, and run database configuration.
7. Perform the same steps for all other affected applications. Attribute names may differ but the values to use are consistent with those found in step 3.