My Oracle Support Banner

Applications Login Using OAM Fails with 'The Login/Portal Server Installation may be incomplete' Caused by 'java.sql.SQLException: ORA-01465: invalid hex number' (Doc ID 1538812.1)

Last updated on JUNE 01, 2024

Applies to:

Oracle E-Business Suite Technology Stack - Version 12.1.1 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.


After implementing Single Sign On for R12.1 the SSO login page is rendered fine, but passing the user credentials  redirect is done to error page showing:

There was an error processing your request. The Login/Portal Server Installation may be incomplete. Please contact your System Administrator.




The access_log reports: - - [28/Feb/2013:14:43:06 +0800] "GET /OA_HTML/jsp/fnd/fnderror.jsp?msg_app=FND&msg_name=FND-9930 HTTP/1.1" 200 4393 0 ""

and the fndauth.log shows the following underlying exception:

Mar 10, 2013 4:45:41 PM oracle.apps.fnd.ext.sso.SsoUser calculateAppsUsers
SEVERE: SEVERE exception while finding AppsUser details for GUID NOT_FOUND -->
java.sql.SQLException: ORA-01465: invalid hex number

      at oracle.jdbc.driver.T4CTTIoer.processError(
      at oracle.jdbc.driver.T4CTTIoer.processError(
      at oracle.jdbc.driver.T4C8Oall.processError(
      at oracle.jdbc.driver.T4CTTIfun.receive(
      at oracle.jdbc.driver.T4CTTIfun.doRPC(
      at oracle.jdbc.driver.T4C8Oall.doOALL(
      at oracle.jdbc.driver.T4CPreparedStatement.doOall8(
      at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(
      at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(
      at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(
      at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(
      at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(
      at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(
      at weblogic.jdbc.wrapper.PreparedStatement.executeQuery(
      at oracle.apps.fnd.ext.jdbc.utils.QueryRunner.query(
      at oracle.apps.fnd.ext.sso.SsoUser.calculateAppsUsers(Unknown Source)
      at oracle.apps.fnd.ext.sso.SsoUser.<init>(Unknown Source)
      at oracle.apps.fnd.ext.sso.SsoUser.<init>(Unknown Source)
      at oracle.apps.fnd.ext.sso.OamSsoUser.<init>(Unknown Source)
      at oracle.apps.fnd.ext.sso.AppsHttpServletRequestWrapper.<init>(Unknown Source)
      at oracle.apps.fnd.ext.sso.OAMHelper.login(Unknown Source)
      at jsp_servlet.__oamlogin._jspService(
Mar 10, 2013 4:45:41 PM oracle.apps.fnd.ext.sso.AppsHttpServletRequestWrapper <init>
SEVERE: Cannot retrieve LDAP information for guid='NOT_FOUND'


 New implementation of SSO.


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

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