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:

Symptoms

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:

xxx.xxx.xxx.xxx - - [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 "http://xxxx.xxx.xxx:7777/ebsauth_SID/OAMLogin.jsp?authn_try_count=0&contextType=external&username=string&contextValue=%2Foam&password=sercure_string&challenge_url=http%3A%2F%2Fssoaccessprod.up.edu.ph%3A7777%2Febsauth_SID%2FOAMLogin.jsp&request_id=-2690489391614776851&OAM_REQ=&locale=en_US&resource_url=http%253A%252F%252Fxxxx.xxx.xxx%253A7777%252Febsauth_SID%252Fssologin"

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(T4CTTIoer.java:457)
      at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:405)
      at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:889)
      at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:476)
      at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:204)
      at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:540)
      at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:217)
      at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:924)
      at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1261)
      at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1419)
      at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3752)
      at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3806)
      at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1667)
      at weblogic.jdbc.wrapper.PreparedStatement.executeQuery(PreparedStatement.java:135)
      at oracle.apps.fnd.ext.jdbc.utils.QueryRunner.query(QueryRunner.java:92)
      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(__oamlogin.java:226)
      ....
Mar 10, 2013 4:45:41 PM oracle.apps.fnd.ext.sso.AppsHttpServletRequestWrapper <init>
SEVERE: Cannot retrieve LDAP information for guid='NOT_FOUND'

Changes

 New implementation of SSO.

Cause

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