send notifications to all users

Hi

This is not a pop-up, but maybe “Broadcast message” is an option for you.

We’re using it to announce maintenance window.

BR,

Wiktor

Hi @k.yilmaz,

You can send stream messages to all logon users. Just use fnd_client_logon as the cursor view to send stream messages.

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

	CURSOR openoracleusers IS
		SELECT username FROM oracle_account WHERE account_status = 'OPEN';

BEGIN
	FOR rec_ IN openoracleusers
	LOOP
		client_sys.clear_attr(attr_);
		client_sys.add_to_attr('TO_USER', rec_.username, attr_);
		client_sys.add_to_attr('MESSAGE', 'Deneme Test!', attr_);
		client_sys.add_to_attr('STREAM_TYPE_DB', 'GENERAL', attr_);
		client_sys.add_to_attr('VISIBLE', fnd_boolean_api.decode('TRUE'), attr_);
		client_sys.add_to_attr('READ', fnd_boolean_api.decode('FALSE'), attr_);
		ifsapp.fnd_stream_api.new__(info_, objid_, objversion_, attr_, 'DO');
		--COMMIT;
	END LOOP;
END;