I am trying to add a custom field in Production that I was able to add in Test. I tried activating the rowkey on ShopOrd on the Shop Orders Screen and received the following error when trying to run as background job.
Argument DISABLE_TRIGGERS_ is of an unsupported data type. ORA-20105: Transaction.UNSUPPORT_DATATYPE
+18
we got the below information from our RnD team regarding this issue in a previous occurrence.
Database_Sys.Enable_Rowkey method has a parameter of type BOOLEAN. Background processing does not support procedures with parameter type BOOLEAN. This is to cater an Oracle limitation in binding variables. So, it is not possible to run the above method in background. Hence you are getting this error.
RnD have identified this as a limitation due to oracle and they will change this functionality in next IFS versions.
Hence, the customer needs to remove/disable the two options (Background Job, Schedule Background job) in Activate RowKey dialog box
IFS Solution : 299286
+18Yes, it will work as only two background options (Background Job, Schedule Background job) gives the mentioned error.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
