My collegue has recently shown me an error in IEE stating that event action (ie. MWORKORDER_4_8) has an issue. When I got into PLSQL code of that I’ve copied the whole statement into Oracle SQL Developer and found an error on the line objversion_:= to_char(&NEW:ROWVERSION); Obvious thing was to enclose &NEW:ROWVERSION in single quotes. So I’ve fixed that and a number of other events too.
Some time later we’ve migrated TAS server and redeployed mWorkOrder_4_9_0.dll, browsing the same page we’ve got the same error text in IEE again. All these MWORKORDER event actions were regenerated having the same syntax error. Finally, I got to the source (/fndmob/source/fndmob/server/packages/MobileClientAdministration/ifs/application/mobileclientadministration/impl/EventAndActionUtilities.java) and found what’s causing this:
else if(OBJVERSION_FORMAT_NUMBER.equals(entity.objversionFormat.getValue())){
objVersionFormat = "to_char(&NEW:ROWVERSION)";
Hense, no single quotes. We’re currently running IFS 10 UPDATE 17 and as I’ve checked it is still not fixed in later updates.