E-Business Suite R12 SSO Login Shows "Unexpected PLSQL Error" And 'SEVERE exception while finding AppsUser details for GUID nnn java.sql.SQLException: ORA-01465: invalid hex number' In The FNDAUTH.log (Doc ID 2177900.1)

Last updated on SEPTEMBER 13, 2016

Applies to:

Oracle Applications Technology Stack - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

E-Business Suite R12 Applications Technology Stack, OID SSO Technologies

 

 

When logging into SSO via the EBS login screen, the initial responsibility page displays the following errors:

 

ERROR
-----------------------
(IE browser error:)
You have encountered an unexpected PLSQL error. Please contact System Administrator for assistance.

(fndauth.log error:)
Aug 2, 2016 10:01:31 AM oracle.apps.fnd.ext.sso.SsoUser getAppsUsers
SEVERE: SEVERE exception while finding AppsUser details for GUID x00a001 -->
java.sql.SQLException: ORA-01465: invalid hex number
...
Aug 2, 2016 10:01:31 AM oracle.apps.fnd.ext.common.server.FndSsoLoginProcess2 doGet
SEVERE: SEVERE SQL error==>
java.sql.SQLException: ORA-01465: invalid hex number

The issue can be reproduced via the following steps:


1. Access the EBS server via the standard URL http://<server>.<domain>:<port>/ .
2. It will redirect to SSO Login Screen.
3. Enter Username and Password and click Login.
4. It will show "You have encountered an unexpected PLSQL error" error.



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