Skip to main content

Hi,

i am trying to send a stream message on Oracle Sql Developer i found i topic about this here; Send Stream Notifications in PL / SQL | IFS Community 

here is the sql code i am trying; 

DECLARE
stream_ fnd_stream_tab%ROWTYPE;
BEGIN
stream_.from_user := 'IFSAPP';
stream_.to_user := 'IFSAPP';
stream_.header := 'MESSAGE_TITLE';
stream_.message := 'MESSAGE_TEXT/BODY';
stream_.url := 'ifsapf:frmPurchaseOrder?external_search=ORDER_NO=<VALUE_URL_ENCODE>225</VALUE_URL_ENCODE>';
stream_.stream_type := Fnd_Stream_Type_API.DB_NOTIFICATION;
stream_.lu_name := 'PurchaseOrderApproval';

Fnd_Stream_API.New_Stream_Item(stream_);

END
Commit;

after i execute the command i receive 

PL/SQL procedure successfully completed.

but on IFS i cannot see the notification.

what am i missing?

 

i tried DB_GENERAL for stream type;

stream_.stream_type := Fnd_Stream_Type_API.DB_GENERAL;

didn’t work


hmm, there is something wrong, i see that sql code worked because there are records on db;
 

 

but notification didn’t work


Reply