hello, thank you for you answer but what is the function i can use in my sql to do that? thank you again @mohamed_akrouh Hi, You use the code below. DECLARE attr_ VARCHAR2(2000); info_ VARCHAR2(2000); objid_ VARCHAR2(20); objversion_ VARCHAR2(100); CURSOR openoracleusers IS SELECT username FROM ifsapp.oracle_account t WHERE account_status = 'OPEN' AND t.username in ('HASANYUCEL','USER1','USER2');BEGIN FOR rec_ IN openoracleusers LOOP ifsapp.client_sys.clear_attr(attr_); ifsapp.client_sys.add_to_attr('FROM_USER', 'IFSAPP', attr_); ifsapp.client_sys.add_to_attr('TO_USER', rec_.username, attr_); ifsapp.client_sys.add_to_attr('HEADER', 'TEST', attr_); ifsapp.client_sys.add_to_attr('MESSAGE', 'Whats up man!', 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(
HIi got same problem did you find a solution :/
thank you so much @Link and @hhy38 i will test this and i will let you know
hello,thank you for you answer but what is the function i can use in my sql to do that? thank you again
Hi, In response to Ines, I agree it’s less than Ideal the create new was removed. However, I tested the migration job and it can do this as well. Typically, I could create a new external file type in a minute or two. The Migration job is not as fast for the same thing. But it does work. See me if you need a quick and dirty (non-elegant) document on how to use that tool. Send me an email. Best regards, Hi Thomas I hope youre doing good ;could you pleas tell me how you did this ? thank you somuch
hi jmaguire;did you fix this issue ? thankyou
hi bhaveshHow did you resolve issue ?thank you
Already have an account? Login
No account yet? Create an account
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.