Order Management - EBS (MOSC)

MOSC Banner

Close WorkFlow OMERROR message 2

edited May 30, 2023 11:06AM in Order Management - EBS (MOSC) 4 commentsAnswered ✓

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center