ECM: Issue With Adding Involved Party Manually.
(Doc ID 2987875.1)
Last updated on NOVEMBER 22, 2023
Applies to:
Oracle Financial Services Enterprise Case Management - Version 8.0.7 and laterInformation in this document applies to any platform.
Symptoms
not able to Add Involved party based on the Party ID or Party name.
Changes
[24-10-23 16:29:15,254 GMT PM] [DEBUG] [WEB] [UMM] [NA] [RDBMSDAOHANDLER] ~~~~ enableArchivedData() Exit ~~~~
[24-10-23 16:29:15,254 GMT PM] [DEBUG] [WEB] [UMM] [NA] [RDBMSDAOHANDLER] Execute Query with Prepared Statement for Debug:::SELECT kdd_case_involved_party_detail.FIRST_NM FFW$_501,kdd_case_involved_party_detail.MIDDL_NM FFW$_511,kdd_case_involved_party_detail.LAST_NM FFW$_521,kdd_case_involved_party_detail.PARTY_ID FFW$_531,kdd_case_involved_party_detail.PARTY_ID_TYPE_CD FFW$_541,pkg_cm_tabs.f_get_rlshptype([IPSeqID],?) FFW$_75,kdd_case_involved_party_detail.PARTY_ID_ISSNG_AUTH_NM FFW$_551,TO_CHAR(kdd_case_involved_party_detail.BIRTH_DT, 'YYYY-MM-DD') FFW$_561,kdd_case_involved_party_detail.HOME_PHON_NB FFW$_571,kdd_case_involved_party_detail.HOME_PHON_EXT_NB FFW$_581,kdd_case_involved_party_detail.TAX_ID_FRMT_CD FFW$_591,kdd_case_involved_party_detail.TAX_ID FFW$_601,kdd_case_involved_party_detail.WORK_PHON_NB FFW$_611,kdd_case_involved_party_detail.WORK_PHON_EXT_NB FFW$_621,kdd_case_involved_party_detail.ADDR_STRT_TX FFW$_631,kdd_case_involved_party_detail.ADDR_CITY_NM FFW$_641,kdd_case_involved_party_detail.ADDR_STATE_CD FFW$_651,kdd_case_involved_party_detail.ADDR_POSTL_CD FFW$_661,kdd_case_involved_party_detail.ADDR_CNTRY_CD FFW$_671,kdd_case_involved_party_detail.OCPTN_NM FFW$_68,kdd_case_involved_party_detail.BUS_DMN_ST FFW$_77,kdd_case_involved_party_detail.RLSHP_YR_CT FFW$_69,kdd_case_involved_party_detail.RLSHP_MNTH_CT FFW$_70,(SELECT NOTE_TX FROM KDD_CASE_NOTE_HIST WHERE NOTE_ID = kdd_case_involved_party_detail.PARTY_DESC_NOTE_ID) FFW$_74,kdd_case_involved_party_detail.INVLVD_PARTY_SEQ_ID FFW$_71,kdd_case_involved_party_detail.INVLVD_PARTY_VRSN_NB FFW$_72,FIRST_NM||' '||MIDDL_NM||' '||LAST_NM FFW$_73,kdd_case_involved_party_detail.INVLVD_PARTY_ACTIVE_FL FFW$_76,(select count(*) from kdd_case_involved_party_link t inner join kdd_case_involved_party_detail t1 on t.invlvd_party_seq_id=t1.invlvd_party_seq_id where t.case_intrl_id=? and t.rlshp_type_cd=[p_rlshp_type] and t.rlshp_active_fl='Y' and t1.party_id = [Party_ID] and t1.invlvd_party_seq_id !=[p_ipseq_id] ) FFW$_5 FROM kdd_case_involved_party_detail WHERE 1=1
[24-10-23 16:29:15,254 GMT PM] [DEBUG] [WEB] [UMM] [NA] [RDBMSDAOHANDLER] VALUES :: 1 CAXXXXXXXX
[24-10-23 16:29:15,254 GMT PM] [DEBUG] [WEB] [UMM] [NA] [RDBMSDAOHANDLER] VALUES :: 2 CAYYYYYYYYY
[24-10-23 16:29:15,258 GMT PM] [ERROR] [WEB] [UMM] [NA] [LOGGER] ORA-00936: missing expression
java.sql.SQLSyntaxErrorException: ORA-00936: missing expression
at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:509)
at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:461)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1104)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:550)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:268)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:655)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:270)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:91)
at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:807)
at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:983)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1168)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3666)
at oracle.jdbc.driver.T4CPreparedStatement.executeInternal(T4CPreparedStatement.java:1426)
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3713)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1167)
at com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.pmiExecuteQuery(WSJdbcPreparedStatement.java:1229)
at com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.executeQuery(WSJdbcPreparedStatement.java:747)
at com.ofs.aai.ff.db.handler.RdbmsDaoHandler.executeQueryWithPreparedStatement(RdbmsDaoHandler.java:1840)
at com.ofs.aai.ff.db.dao.DaoSupporter.buildSelectQueryAndExecute(DaoSupporter.java:142)
at com.ofs.aai.ff.service.db.service.FormService.getFormDataBindingValues(FormService.java:493)
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 |
Changes |
Cause |
Solution |