Close WorkFlow OMERROR message 2
Hi,
on R12.2.9 DB 19c on AIX
To close messages I followed note How To Close Notifications Using API? (Doc ID 1560741.1) and ran:
QL> select notification_id, to_user from wf_notifications where message_type='OMERROR' and status = 'OPEN' and begin_date < sysdate and rownum < 5;
NOTIFICATION_ID TO_USER
--------------- ------------------------------
7948918 SYSADMIN SYSADMIN
7948920 SYSADMIN SYSADMIN
7948921 SYSADMIN SYSADMIN
7948922 SYSADMIN SYSADMIN
SQL> begin
wf_notification.close(7948918,'SYSADMIN SYSADMIN');
commit;
end;
/
begin
*
ERROR at line 1:
ORA-20002: 3209: You may not close Notification 'OM Error in Workflow Order Type: SE Order Only, Sales Order 403855 ORA-24033: no recipients for
message' because it requires a response. Use the "Find in page" function within the browser to locate and de-select this Notification. You may