"java.sql.SQLException: Initialization failed" Error When Trying To Create Service Request From Agent Dashboard (Doc ID 2185682.1)

Last updated on SEPTEMBER 22, 2016

Applies to:

Oracle Customer Support - Version 12.2.5 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.5 version, Agent Dashboard

Getting the following error when Creating Service request

ERROR
-----------------------

You have encountered an unexpected error.Please contact the System Administrator for assistance.
Click here for exception details

Exception Details.
 oracle.apps.fnd.framework.OAException: java.sql.SQLException: Initialization failed
  at oracle.apps.fnd.framework.server.OAUtility.invokeMethod(Unknown Source)
  at oracle.apps.fnd.framework.server.OAUtility.invokeMethod(Unknown Source)
  at oracle.apps.fnd.framework.server.OAApplicationModuleImpl.invokeMethod(OAApplicationModuleImpl.java:783)
  at oracle.apps.cs.logs.webui.logsCO.processRequest(logsCO.java:56)
  at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:631)
  at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:283)
 ## Detail 0 ##
 java.sql.SQLException: Initialization failed
  at oracle.sql.NUMBER.(NUMBER.java:305)
  at oracle.jbo.domain.Number.(Number.java:289)
  at oracle.apps.cs.logs.server.logsAMImpl.execQuery(logsAMImpl.java:188)
  at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
  at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  at java.lang.reflect.Method.invoke(Method.java:606)
  at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:120)
  at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2283)
  at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2182)
  at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1491)
  at weblogic.work.ExecuteThread.execute(ExecuteThread.java:256)
  at weblogic.work.ExecuteThread.run(ExecuteThread.java:221)

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Login to Applications
2. (R)"Case Worker" or "Customer Support Specialist"
3. Click on Agent Dashboard
4. Enter the problem summary in the create service request page and click on Apply button

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms