How To Clear Too Many Pending Requests For Password Reset [ID 875559.1]

On 12.0.6 in Production:
When attempting to use the "FORGET PASSWORD" feature from the Oracle Applications, the
user is unable to reset it's password due to the following error:

ERROR
Too many pending requests already exists in the system. Please check your email or contact the
System Administrator for further assistance.

Cause

The cause of the issue is that there are five 'Forgot password' requests that are currently active
for a user that have possibly timed out but not been processed by 'Workflow Background Process'.

If user doesn't respond within 4 hours after receiving email notification to reset password, the activity will time out but will remain active till 'Workflow Background Process' is run to process 'Timeout'
activities. When the number of such requests for a user exceeds five, the above warning message is displayed.

The following SQL shows status of request for a user:

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 = '<USER_NAME>'
) QRSLT
where
item_type = 'UMXLHELP';

.

Solution

To close the pending items, please execute the following steps:

1. submit concurrent request 'Workflow Background Process with following parameters:

Item Type : UMX Login Help
Process deferred: Yes
Process Timeout: Yes

2. Retest the issue after request completes to confirm that warning message no longer appears.