My Oracle Support Banner

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 FEBRUARY 12, 2019

Applies to:

Oracle WebCenter Content: Imaging - Version 11.1.1.9.0 to 11.1.1.9.0 [Release 11g]
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.

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.