+2I am facing following error in database background job
1)Job Name: Set Original Latest Finish custom field value. .
2)Error Text: The Event Action "Execute Online SQL" on "WT_ORG_LATEST_FINISH_BJ" has failed. Please contact your System Administrator to manage the Event Actions. ORA-01400: cannot insert NULL into ("IFSAPP"."JT_TASK_CFT"."ROWKEY") ORA-20105: FndEventAction.EVENT_ACTION_ERROR.
Best answer by Charith Epitawatta
Hi
Seems like the ROWKEY column is not updated correctly for JT_TASK_TAB table. Could you please check whether JT_TASK_TAB has it’s ROWKEY column set to “not nullable’ and the default value for the ROWKEY column is set to sys_guid()?
Have a look at following documentation regarding updating the rowkey :
Hope this helps!
+31Hi
Seems like the ROWKEY column is not updated correctly for JT_TASK_TAB table. Could you please check whether JT_TASK_TAB has it’s ROWKEY column set to “not nullable’ and the default value for the ROWKEY column is set to sys_guid()?
Have a look at following documentation regarding updating the rowkey :
Hope this helps!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
