All custom process failing and says Procedure should be declared. It started happening few weeks back. Below is the error:
WARN 2018-09-17 23:03:32,431 [Custom script execution pool-7-thread-4] utils.Utils (clarity:arunasa:61538288__D6D22F36-ABA8-4B03-AB3B-1FEAD1624CE6:none) ----> The exception trace is too big to be attached to the process error message. Only a truncated exception trace will be attaced to the process error message. Here is the complete exception trace: org.apache.commons.jelly.JellyTagException: null:3:15: <sql:update> CALL NIKU.MY_CUSTOM_SP(null, null, 7142071, null, null): [CA Clarity][Oracle JDBC Driver][Oracle]ORA-06550: line 1, column 12:
PLS-00302: component 'MY_CUSTOM_SP' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
Dropping the niku table which was created in niku schema resolved the issue.