oracle apps password reset: Too many pending request already exist in the system. Please check your email or contact the system administrator for further assistance.

When user try to reset the password with the option in login page, He is getting below error

Error:

“Too many pending request already exist in the system. Please check your email or contact the system administrator for further assistance.”

Reference :  How To Clear Too Many Pending Requests For Password Reset (Doc ID 875559.1)

select * from

(

SELECT WorkflowItemEO.ITEM_TYPE,

WorkflowItemEO.ITEM_KEY,

wf_fwkmon.getitemstatus(WorkflowItemEO.ITEM_TYPE,

WorkflowItemEO.ITEM_KEY, WorkflowItemEO.END_DATE,

WorkflowItemEO.ROOT_ACTIVITY,

WorkflowItemEO.ROOT_ACTIVITY_VERSION) STATUS_CODE

FROM WF_ITEMS WorkflowItemEO,

WF_ITEM_TYPES_VL WorkflowItemTypeEO,

WF_ACTIVITIES_VL ActivityEO,

WF_ITEM_ATTRIBUTE_VALUES attrib

WHERE WorkflowItemEO.ITEM_TYPE = WorkflowItemTypeEO.NAME

AND ActivityEO.ITEM_TYPE = WorkflowItemEO.ITEM_TYPE

AND ActivityEO.NAME = WorkflowItemEO.ROOT_ACTIVITY

AND ActivityEO.VERSION = WorkflowItemEO.ROOT_ACTIVITY_VERSION

AND attrib.item_type = WorkflowItemEO.ITEM_TYPE

AND attrib.item_key = WorkflowItemEO.ITEM_KEY

AND attrib.name = 'USER_NAME'

AND attrib.text_value = '<<UserName>>'

) QRSLT

where

item_type = 'UMXLHELP';

The query gives below active request from the user.

Solution: Submit below concurrent request

'Workflow Background Process with following parameters:

Item Type : UMX Login Help

Process deferred: Yes

Process Timeout: Yes

After completion of the concurrent request the status of Active pending request are completed, Run the query again.

Now ask the user to retry