NoViableAltException Error In CM Search Zones After ORMB 126.96.36.199 Upgrade
Last updated on MARCH 20, 2017
Applies to:Oracle Financial Services Revenue Management and Billing - Version 188.8.131.52.0 and later
Information in this document applies to any platform.
On : 184.108.40.206.0 version, ENV - Environment
NoViableAltException Error in CM Search Zones After 220.127.116.11 Upgrade
User upgraded ORMB 18.104.22.168 environment to 22.214.171.124. After the upgrade, noticed that all initiated look ups on CM search zones fail with SQL errors. These search zones worked fine until the upgrade. The error messages indicate a parsing related issue.
com.splwg.base.support.sql.CustomSQLParserErrorListener$ParseErrorCancellationException: line 1:253 no viable alternative at input '(SELECT*FROM(SELECTPP.PER_ID,PN.ENTITY_NAMEASCUSTOMER_NAME,P.POLICY_ID,P.POLICY_NBR,L.DESCRASSRC_SYSTEM_CD,PP.START_DT,PP.END_DT,F.DESCRASBO_STATUS_CD,(SELECT'
The issue can be reproduced at will with the following steps:
1. Navigate to “Main Menu > Customer 360”.
2. In the search zone, look up any client using any filter (This example uses “Customer Name = agu” as the search criteria).
3. The lookup ends up with an SQL error:
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms