Last updated on MARCH 20, 2017
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:
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms