My Oracle Support Banner

Upgrading To eBilling Version 6.2 Error ORA-00904 (Doc ID 2038108.1)

Last updated on FEBRUARY 28, 2018

Applies to:

Oracle Self-Service E-Billing Consumer Edition - Version 6.2 and later
Information in this document applies to any platform.

Goal

Durring upgrade Process from 6.0.4 to 6.2 , following error was observed

IUser user = UserFactory.getUserManager().findUser(valid_userID);

WLS12 throw error below in its console:
WARNING: SQL Error: 904, SQLState: 42000
Jul 29, 2015 11:43:35 AM org.hibernate.util.JDBCExceptionReporter logExceptions
SEVERE: ORA-00904: "THIS_"."ISACCESSIBLE": invalid identifier

java.lang.RuntimeException: java.lang.RuntimeException: Exception occured while getting User: org.hibernate.exception.SQLGrammarException: could not execute query
at com.edocs.common.umf.core.UserManager.findUser(UserManager.java:290)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:309)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
at $Proxy102.findUser(Unknown Source)
at com.ups.ebs.ebill.sso.actions.LiemSSOAction.execute(LiemSSOAction.java:138)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at com.opensymphony.xwork2.Defaul
 

 

Solution

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
Goal
Solution


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