My Oracle Support Banner

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 APRIL 02, 2018

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.

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


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