ORA-01422 When trying to Query and Update User Information in FNDSCAUS form
(Doc ID 1073498.1)
Last updated on DECEMBER 24, 2023
Applies to:
Oracle Application Object Library - Version 12.1 to 12.1.2 [Release 12.1]Information in this document applies to any platform.
Symptoms
On Oracle Applications Instance, when trying to query a user in "Security: User > Define" form (FNDSCAUS), the following error occurs.
Error
------------
ORA-01422: exact fetch returns more than requested number of rows.
FRM-40735: POST-QUERY trigger raised unhandled exception ORA-01422
Steps to reproduce the issue
------------------------------------
1. Login to Oracle Applications.
2. Select "System Administrator" responsibility.
3. Navigate to "Security: User > Define"
4. Query any user and it will fail with above error.
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 |