IBM Support

BMXAA7135E - The Boolean value of PURCHVIEW.CREATEREL cannot be retrieved

Technical Blog Post


Abstract

BMXAA7135E - The Boolean value of PURCHVIEW.CREATEREL cannot be retrieved

Body

Problem:
Error message while trying to create Purchase Contract using either Purchase Contracts or Purchase Requisitions application.


Resolving the problem:

Suggestion I:

1. Go to Database Configuration application.

2. Bring up PURCHVIEW object.

3. Go to Relationships tab.

4. Bring up PROPERTYDEFAULT relationship.

5. Make sure that the Where Clause is defined as below:
contracttypeid = :contracttype and orgid = :orgid


Suggestion II:

1. Go to Domains application.

2. Bring up CONTRACTTYPE domain.

3. For PURCHASE Internal Value, make sure that PURCHASE Value is set as Default.


Suggestion III:

Check if you have default value correctly defined for the PROPERTYID CREATEREL in both CONTRACTDEFAULT and PROPERTYDEFAULT objects by running the following queries:

SELECT DEFAULTVALUE FROM CONTRACTDEFAULT WHERE MAXCONTRACTTYPE = 'PURCHASE' AND PROPERTYID = 'CREATEREL';

SELECT DEFAULTVALUE FROM PROPERTYDEFAULT WHERE CONTRACTTYPEID = 'PURCHASE' AND PROPERTYID = 'CREATEREL' AND ORGID = 'EAGLENA';
(replacing EAGLENA by the Organization in question)


If the problem still persists even after trying all the suggestions above, please contact IBM Maximo Support.

[{"Business Unit":{"code":"BU005","label":"IoT"}, "Product":{"code":"SSLKT6","label":"Maximo Asset Management"},"Component":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"","Edition":""}]

UID

ibm11112421