- ERP System: All
- MarkView Version: All
- Item in Workflow Administration queue due to error :
User () could not retrieve workitem (1234567) due to error:ORA-01422: exact fetch returns more than requested number of rows.
- This issue can be caused if you have assigned more than one alternate for a particular user.
- The following query can be used to identify the users with multiple alternates assigned:
select aua.user_id, count(*) from sf_alternate_user_assignment aua
where aua.enabled_yn = 'Y'
and sysdate between aua.enable_date and aua.disable_date
group by aua.user_id
having count(*) > 1;
To resolve, disable all except a single alternate for the user then place the Return To Previous Queue markup. In rare circumstances the previous queue may be Workflow Administration in which case, the Support Tool utility "Set Owner And Reroute" can be used to route the workitem to the intended queue.
Keywords: AUA, MVAUA