Delete the worklist Error alert on the EBS Homepage

Source: Internet
Author: User

Delete the worklist Error alert on the EBS Homepage
Refer To: How To Remove Error configurations From The Worklist (Doc ID 357904.1)

1.1. Use one of the error configurations to get an item_type from the following select:

Select message_type from wf_ications ications where ication_id _id = <NID>;
Select message_type from applsys. wf_ications ications where ication_id = 93885; -- WFERROR
2. Use the following script to abort all error workflows that has currently configurications with status OPEN: Declare
Cursor c_item_keys is
Select act. item_type, act. item_key
From wf_item_activity_statuses act
, Wf_notifications n
, Wf_items itm
Where act. icationication_id = n. notification_id
And act. item_type = itm. item_type
And act. item_key = itm. item_key
And itm. end_date is null
And act. item_type = '<message_type>' -- value returned in step 1
And act. activity_status in ('error', 'notified ')
And n. status = 'open'
And act. assigned_user = 'sysadmin ';

Counter number;

Begin
Counter: = 1;
For item in c_item_keys loop
Wf_engine.abortprocess (item. item_type, item. item_key );
Counter: = counter + 1;
If counter> 1000 then
Counter: = 1;
Commit;
End if;
End loop;
Commit;
End;
NOTE:
-Replace the <message_type> by the message_type value returned in step 1.
-This script will remove error comprehensions from sysadmin. Replace sysadmin by the end user needed or comment the line to run the script for all end users.
3. Run the concurrent request: "Purge Obsolete Workflow Runtime Data". NOTE:
-In some cases the error workflow may have a child workflow, for example, POERROR workflow may fail to send a notification to a certain user, so that it will generate a WFERROR notification to sysadmin. in that case one has to run the script in step 2 first for WFERROR workflow.

An item_key is not required to run the Purge Obsolete Workflow Runtime Data request. Running it without use of an item_key, all eligible data will be purged.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.