My Oracle Support Banner

In Alert Management, Account balance information display issue (Doc ID 2715288.1)

Last updated on OCTOBER 05, 2020

Applies to:

Oracle Financial Services Behavior Detection Platform - Version 8.0 and later
Information in this document applies to any platform.

Symptoms

Account balance information display issue in Alert Management -->Research-->Account Tab --> Account Balance

In UMMService log below error

[01-04-20 09:37:55,700 GMT AM] [ERROR] [WEB] [UMM] [NA] [LOGGER] ORA-00936: missing expression

java.sql.SQLSyntaxErrorException: ORA-00936: missing expression

at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:494)
at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:446)
.
.
.
.
Caused by: Error : 936, Position : 522, Sql = SELECT count(1) FROM (SELECT ACCT_INTRL_ID ACCT_ID, acct.acct_type1_cd||','||acct.acct_type2_cd||','||acct.MANTAS_ACCT_BUS_TYPE_CD TYPES,ACCT_DSPLY_NM NAME,acct.bus_dmn_list_tx Bs_dmn,acct.jrsdcn_cd Jrdctn,(case when ACCT_TAX_ID is not null then TAX_ID_FRMT_CD ||' '||ACCT_TAX_ID end)TAX_ID,ORG_NM BU,DMCLD_BRCH_CD BRANCH,RGSTN_TYPE_CD REG,(select count(1) from kdd_review kr inner join kdd_centricity kc on kr.cntry_id=kc.cntry_id where kc.cntry_type_cd ='AC' and kr.cntry_key_id =acct.acct_intrl_id and kr.jrsdcn_cd in ([userJuris]) and OVERLAYS(cast(:1 as varchar(255)), Kr.BUS_DMN_ST) <> 'N') Alert_Count FROM ACCT LEFT OUTER JOIN ORG on org.ORG_INTRL_ID=ACCT.FIRM_ACCT_ORG_INTRL_ID WHERE OVERLAYS(cast(:2 as varchar(255)), ACCT.BUS_DMN_LIST_TX) <> 'N' and 1=1 ORDER BY ACCT_INTRL_ID) Acc_Grid, OriginalSql = SELECT count(1) FROM (SELECT ACCT_INTRL_ID ACCT_ID, acct.acct_type1_cd||','||acct.acct_type2_cd||','||acct.MANTAS_ACCT_BUS_TYPE_CD TYPES,ACCT_DSPLY_NM NAME,acct.bus_dmn_list_tx Bs_dmn,acct.jrsdcn_cd Jrdctn,(case when ACCT_TAX_ID is not null then TAX_ID_FRMT_CD ||' '||ACCT_TAX_ID end)TAX_ID,ORG_NM BU,DMCLD_BRCH_CD BRANCH,RGSTN_TYPE_CD REG,(select count(1) from kdd_review kr inner join kdd_centricity kc on kr.cntry_id=kc.cntry_id where kc.cntry_type_cd ='AC' and kr.cntry_key_id =acct.acct_intrl_id and kr.jrsdcn_cd in ([userJuris]) and OVERLAYS(cast(? as varchar(255)), Kr.BUS_DMN_ST) <> 'N') Alert_Count FROM ACCT LEFT OUTER JOIN ORG on org.ORG_INTRL_ID=ACCT.FIRM_ACCT_ORG_INTRL_ID WHERE OVERLAYS(cast(? as varchar(255)), ACCT.BUS_DMN_LIST_TX) <> 'N' and 1=1 ORDER BY ACCT_INTRL_ID) Acc_Grid, Error Msg = ORA-00936: missing expression

at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:498)
... 68 more

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.