My Oracle Support Banner

User Receives 'ORA-01722: Invalid Number' When Viewing the Coverage's Results (Doc ID 2566098.1)

Last updated on JULY 22, 2019

Applies to:

Oracle Insurance Policy Administration J2EE - Version 11.2.0.14 and later
Information in this document applies to any platform.

Symptoms

On : 11.2.0.14 version, Plan information

When users search for a contract lead and attempt to view the coverage, the following message appears:


ERROR
-----------------------
java.lang.RuntimeException: java.lang.RuntimeException: javax.persistence.PersistenceException: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.4.v20160829-44060b6): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLSyntaxErrorException: ORA-01722: invalid number

Error Code: 1722
Call: SELECT '' AS Code, 'AsCode.Common.Choose' FROM DUAL UNION SELECT CodeValue AS Code,LongDescription FROM AsCode WHERE CodeName = 'AsCodeMode' AND CodeValue <= 12 ORDER BY Code NULLS FIRST
Query: DataReadQuery(sql="SELECT '' AS Code, 'AsCode.Common.Choose' FROM DUAL UNION SELECT CodeValue AS Code,LongDescription FROM AsCode WHERE CodeName = 'AsCodeMode' AND CodeValue <= 12 ORDER BY Code NULLS FIRST")
at com.adminserver.pas.uip.aspects.UipExtensibilityAspect.extendUipMethod(UipExtensibilityAspect.java:65)
at com.adminserver.pas.uip.PolicyContextSidebarUip.startProcessing(PolicyContextSidebarUip.java:88)
at com.oracle.pas.page.PolicyContextSidebarPage.startProcessing(PolicyContextSidebarPage.java:38)
at com.oracle.pas.service.delegate.PolicyServiceDelegate.getPolicyLeftNavigationPage(PolicyServiceDelegate.java:304)
at com.oracle.pas.service.delegate.PolicySegmentServiceDelegate.initializeSegment_aroundBody0(PolicySegmentServiceDelegate.java:68)
at com.oracle.pas.service.delegate.PolicySegmentServiceDelegate$AjcClosure1.run(PolicySegmentServiceDelegate.java:1)
at org.aspectj.runtime.reflect.JoinPointImpl.proceed(JoinPointImpl.java:221)



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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.