DCP

Wednesday 28 June 2017

Duplicate PO Emails being sent out to Supplier that is registered on iSupplier Portal



Known Oracle Issue: Metalink Note References:
How Suppliers Can Avoid E-mail Notifications? (Doc ID 461963.1)

Fix: Customize PO Approval Workflow:

Open up Email PO Process.


This Process calls Function: Send Notification all web Suppliers










CREATE OR REPLACE PACKAGE XXPO_REQAPPROVAL_INIT1 AS
procedure Send_WS_Notif_Yes_No(     itemtype        in varchar2,
                              itemkey         in varchar2,
                              actid           in number,
                              funcmode        in varchar2,
                              resultout       out NOCOPY varchar2    ) ;
END;
/
                           
CREATE OR REPLACE PACKAGE BODY XXPO_REQAPPROVAL_INIT1 AS
procedure Send_WS_Notif_Yes_No(     itemtype        in varchar2,
                              itemkey         in varchar2,
                              actid           in number,
                              funcmode        in varchar2,
                              resultout       out NOCOPY varchar2    )  IS
l_send_notif varchar2(1):= 'N';                             
BEGIN                             
   l_send_notif := 'N'; 
   resultout := wf_engine.eng_completed || ':' || l_send_notif ;
END;
END;
/

  


No comments:

Post a Comment