External iSupplier Users Unable To Login Via External Oracle Apps Url Error java.sql.SQLException: ORA-01403: no data found ORA-06512 in FND_SESSION_MANAGEMENT.CHECK_SESSION (Doc ID 1448707.1)

Last updated on JANUARY 23, 2017

Applies to:

Oracle iSupplier Portal - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms


On : 12.1.3, External iSupplier users unable to log in via external URL and get an error.

Error

Oracle error 1403: java.sql.SQLException: ORA-01403: no data found ORA-06512: at line 1 has been detected in FND_SESSION_MANAGEMENT.CHECK_SESSION



Steps To Reproduce:
1. New iSupplier users are created as contacts on the Supplier record, using an email ID.
2. An emails notification is sent to the email address.
-- The email contains the external Oracle Applications URL, a user name and password.
3. The link is valid and the supplier is able to access Oracle Applications in order to log in.
4. User is prompted for a password change.
5. On attempting to submit the password change the reported error is displayed.


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