When searching for a Works Order on the works order forms get an error message
FRM-40735 POST QUERY trigger raised unhandled exception ORA-06502
This can happens searching using the full works order number of with a wild charcter in the search and then using the arrow keys to move on.
In this case the issue happened when using interfaces and a boq item description exceeded the length of a description that was allowed to be returned in the form. Each parent child relationship of bills of quantity items appends 2 characters dynamically on output to the form.The data was unusual in that it had 61 levels , so appending 61 levels of 2 characters for each ( to represent ) made 122 characters to display, plus the length of the description or the item (which was 136 characters) meant that it was trying to display 258 characters in the form where only 254 were allowed.
To overcome apply Maintenance Manager patch 4500 Fix 16 Build 3 or version 4700 MM Fix 15 depending on version being used.