Some Users are not able to Login to PeopleSoft HCMS and Error "APP-FND-01926: The Custom Event WHEN-LOGON-CHANGED Raised Unhandled Exception: ORA-06502: Pl/SQL: numeric or value error ORA-01403: no data found" Occurs (Doc ID 2144713.1)

Last updated on JULY 07, 2017

Applies to:

Oracle WebCenter Content: Imaging - Version 11.1.1.9.0 and later
Information in this document applies to any platform.

Symptoms

Certain users are unable to login to PeopleSoft.  These same users are able to login to Oracle HTML forms.  The issue occurs with the professional forms. Any professional form causes the issue. This problem is reproduced on other computers and it is not related to a specific browser.  The below error occurs:

APP-FND-01926: The Custom Event WHEN-LOGON-CHANGED Raised Unhandled Exception: ORA-06502: Pl/SQL: numeric or value error ORA-01403: no data found

All other users can login with no issue.

Recompiling the Custom.pll does not resolve the issue.

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