NoViableAltException Error In CM Search Zones After ORMB 126.96.36.199 Upgrade
(Doc ID 2244624.1)
Last updated on JULY 07, 2021
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:
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