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

Last updated on DECEMBER 19, 2022

Applies to:

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

Changes

Cause

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