IBM Support

Make Items Statusable in Maximo 6



Is it possible to configure Maximo to allow items to be statusable?

Resolving The Problem

1. Create an ALN domain in the Domains application

IBM Logo

2. Go to the Database Configuration application
Bring up the Item object
Add a new attribute called ITEMSTAT
Enter ITEMSTAT in the domain field
Stop the Maximo Application Server
Run configdb.bat under \\maximo\tools\maximo

IBM Logo

3. Start up the Maximo application server
Go to the Database Configuration application
Bring up MR object
Check that there is a relationship called ITEMSONLY

IBM Logo

Where Clause is:
itemtype in (select value from synonymdomain where maxvalue ='ITEM' and domainid='ITEMTYPE') and itemsetid in (select itemsetid from organization where orgid=:orgid)

4. Go to the Security Groups application
Bring up the PURCHREQ security group
Click the Restriction tab
Click New Row
Entity = ITEM
Restriction = ITEMSTAT='ACTIVE'
Save the record

IBM Logo

5. Log in as a user that belongs to the PURCHREQ group
Go to PR application
Go to PR line tab
Enter an item in 'INACTIVE' status
Tab out of the item field
A look-up dialog box comes up i.e. it is not possible to enter inactive items on the PR lines

IBM Logo

[{"Product":{"code":"SSLKT6","label":"IBM Maximo Asset Management"},"Business Unit":{"code":"BU055","label":"Cognitive Applications"},"Component":"Item Master","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF033","label":"Windows"}],"Version":"6.2;6.2.1;6.2.2;6.2.3;6.2.4;6.2.5;6.2.6;6.2.7;6.2.8","Edition":"","Line of Business":{"code":"LOB02","label":"AI Applications"}}]

Document Information

Modified date:
17 June 2018