Status Of Cases In ECM Is Not Going From New To Investigation Status
(Doc ID 2809029.1)
Last updated on NOVEMBER 28, 2022
Applies to:
Oracle Financial Services Enterprise Case Management - Version 8.0.7 and laterInformation in this document applies to any platform.
Symptoms
New cases was not changed as Investigation(INV) when open new cases.
Steps.
1. Go to case list page
2. select new case and link the case id
3. It open case detail page but the case status still remain as new instead of Inv
Expected result:
The case status should be shown as INV
Error in weblogic.out log
insert into aai_wf_process_execution(V_PROCESS_INSTANCE_ID,v_Process_Id,v_infodom_code,v_segment_code,D_START_EXECUTION_DATE,D_MODIFIED_DATE,V_PROCESS_STATUS,kbd1,kbd2,kbd3,kbd4,kbd5) values(?,?,?,?,SYSDATE,SYSDATE,?,?,?,?,?,?), Error Msg = ORA-02290: check constraint (OFSACONFIG.SYS_C00186635) violated
at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:513)
... 37 more
java.lang.reflect.InvocationTargetException
at sun.reflect.GeneratedMethodAccessor144.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at com.ofs.aai.service.wf.common.nextgen.adapter.PreparedStatementDecorator.logAndExecuteQuery(PreparedStatementDecorator.java:205)
at com.ofs.aai.service.wf.common.nextgen.adapter.PreparedStatementDecorator.executeUpdate(PreparedStatementDecorator.java:804)
at com.ofs.aai.service.wf.dao.ora.OracleWorkflowDAO.instantiateWorkflow(OracleWorkflowDAO.java:919)
at com.ofs.aai.service.wf.engine.core.WorkflowEngine.instantiateWorkflow(WorkflowEngine.java:149)
at sun.reflect.GeneratedMethodAccessor592.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Cause |
Solution |
References |