Restricting Location field in Create Service Request app based on Organization

Summary

You may face a scenario where you are trying to customize the List Where Clause for the particular standard crossover domain called TKLOCATIONCROSSCI (Crossover CI from location) due to some business need that you may have.

Depending on the customization or clause present in the List Where Clause field for the TKLOCATIONCROSSCI domain, this could result in the Locations that have the same name appearing in the Select Value list from the Location field in the Create Service Request application, even if the locations with the same name belong to sites that are part of different organizations in Maximo.

This configuration may cause the error message "Error message BMXAA3906E - Site CONCSITE is not valid", in Create Service Request application for example, if your user default insert site does not belong to the same organization of the CONCSITE (used as example) in the message above.

It is important to consider that for the domain, the Validation Where Clause is used to validate the value when queried against the object in the Object field to return at least one record. For example, if you want a field named Z (attribute Z) to contain values from the assetnum field in the Assets application, you would type: ASSETNUM = :Z (the colon represents the bind variable).

The List Where Clause is used to specify the value that you want to select based on the validation WHERE clause. (Maximo adds the list clause automatically to the validation clause when validating the value)