My Oracle Support Banner

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 later
Information 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


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