NoViableAltException Error In CM Search Zones After ORMB 184.108.40.206 Upgrade
(Doc ID 2244624.1)
Last updated on MARCH 29, 2019
Applies to:Oracle Financial Services Revenue Management and Billing - Version 220.127.116.11.0 and later
Information in this document applies to any platform.
On : 18.104.22.168.0 version, ENV - Environment
NoViableAltException Error in CM Search Zones After 22.214.171.124 Upgrade
User upgraded ORMB 126.96.36.199 environment to 188.8.131.52. 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:
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