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:

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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.