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 (Doc ID 2124137.1)

Last updated on APRIL 06, 2016

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