Skip to main content
Question

Can not send stream message from Oracle Sql Developer

  • August 15, 2024
  • 3 replies
  • 62 views
N
Hero
Forum|alt.badge.img+10

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?

 

IFS Türkçe Yardımlaşma Telegram Grubu: https://t.me/ifs_tr

3 replies

N
Hero
Forum|alt.badge.img+10
  • Noriro2
  • Author
  • Hero
  • 112 replies
  • August 15, 2024

i tried DB_GENERAL for stream type;

stream_.stream_type := Fnd_Stream_Type_API.DB_GENERAL;

didn’t work

IFS Türkçe Yardımlaşma Telegram Grubu: https://t.me/ifs_tr
N
Hero
Forum|alt.badge.img+10
  • Noriro2
  • Author
  • Hero
  • 112 replies
  • August 15, 2024

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

 

but notification didn’t work

IFS Türkçe Yardımlaşma Telegram Grubu: https://t.me/ifs_tr
hhy38
Superhero (Customer)
Forum|alt.badge.img+16
  • hhy38
  • Superhero (Customer)
  • 325 replies
  • December 24, 2024

Hi ​@Noriro2,

Can you try the script below?

DECLARE     attr_       VARCHAR2(2000);     info_       VARCHAR2(2000);     objid_      VARCHAR2(20);     objversion_ VARCHAR2(100);

BEGIN     ifsapp.client_sys.clear_attr(attr_);     ifsapp.client_sys.add_to_attr('FROM_USER', 'IFSAPP', attr_);     ifsapp.client_sys.add_to_attr('TO_USER', 'IFSAPP', attr_);     ifsapp.client_sys.add_to_attr('HEADER', 'Test :)', attr_);     ifsapp.client_sys.add_to_attr('MESSAGE', 'Deneme', attr_);     ifsapp.client_sys.add_to_attr('STREAM_TYPE_DB', 'GENERAL', attr_);     ifsapp.client_sys.add_to_attr('VISIBLE', ifsapp.fnd_boolean_api.decode('TRUE'), attr_);     ifsapp.client_sys.add_to_attr('READ', ifsapp.fnd_boolean_api.decode('FALSE'), attr_);     ifsapp.fnd_stream_api.new__(info_, objid_, objversion_, attr_, 'DO'); END;

 

 

Linkedin Profile: https://www.linkedin.com/in/hhy34/

Reply


Terms & ConditionsCookie settingsAccessibility statement

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings