Mobile Web Appications (MWA) Pick Transactions Fail on HandHeld Devices with Error "MWA_PM_UNEXPECTED_ERROR_MESG" and ORA-01422: exact fetch returns more than requested number of rows
Last updated on OCTOBER 21, 2017
Applies to:
Oracle Mobile Application Server - Version 11.5.10.2 to 12.2.5 [Release 11.5.10 to 12.2]Oracle Human Resources - Version 11.5.10.2 to 12.2.5 [Release 11.5.10 to 12.2]
Information in this document applies to any platform.
Symptoms
E-Business Suite 11.5.10.2, Mobile Application Server
Users are unable to perform a Pick action on their handheld devices using MWA application, and are receiving errors:
”Error in retrieving task id against user 3044 ; ORA-01422: exact fetch returns more than requested number of rows”
“Unexpected error occurred. Please check logs” .
ERROR
-----------------------
"MWA_PM_UNEXPECTED_ERROR_MESG: Unexpected error occurred, Please check the log"
”Error in retrieving task id against user [userid] ; ORA-01422: exact fetch returns more than requested number of rows”
BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot execute Pick tasks on handheld devices.
Changes
System administrator end-dated employees and/or created a new employees.
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