Rate Matrix allows spaces after the resource/resource role/location/transaction class causing not to accept proper rate

Document ID : KB000095178
Last Modified Date : 09/05/2018
Show Technical Document Details
Issue:
When creating a new row for the data matrix, a resource can be entered with additional spaces, and this makes the rate not to be found for the intended resource (i.e.: "admin" != "admin "). It is also difficult to identify at a glace which rows have additional spaces as they are not visible - although they can still be observed by selecting the whole cell text.

Steps to Reproduce
  1. Go to Administration > Finance > Manage Matrix, click New 
  2. Fill in the details for the rate matrix except the resource 
  3. For the resource, try either: 
    • Using the binoculars, select a resource (e.g.: "admin"), select "Add" and then add one or more blank spaces after the ID ("admin "), or
    • Type "admin " (including one or more blank spaces after the ID) 
  4. Click Save and Return
Expected Results: The blank spaces are not saved or an error is displayed (REVMGR-20187:Resource code is not valid.), as "admin " is not valid resource ID. 
Actual Results: Blank spaces are saved and row is inserted in the matrix. Rates for that row are not found as do not match resource ID ("admin" != "admin "). 

Same can be reproduced with Resource Roles, Locations and Transaction Classes.
Environment:
This issue has been observed in CA PPM 14.3.0.9 and reproduced in 15.3.0.0.
Cause:
This issue has been reported to Engineering as DE38843.
Resolution:
This defect has been fixed in CA PPM 15.4.1.

Workaround

Edit the matrix, change any one attribute and save. Change back to the original value and save.
This will remove all the unwanted spaces saved in database and after that there will not be any problem in finding a matrix match as desired.