how to change Profile Option Value by SQL
Hi
Could you please share me your advice on the following question.
We have 2 external web servers in EBS environment. We want to set profile option "Node Trust Level" to "External" for the 2 external servers
For some reason,we can not log into EBS and change the value from form.
we need to do it through script.
SQL> select node_name, node_id from fnd_nodes;
NODE_NAME NODE_ID
------------------------------ ----------
AAUSRTPE316T 19149
AUTHENTICATION 19150
AAUSRTPE313T 19151
AAUSRTPE312T 19152
AAUSRTPE311T 19153
AAUSRTPE310T 19154
AAEBSQA-DB 19146
AAUSRTPA331T 19147
AAUSRTPA331T-IRCV 19148
AAUSRTPA331T and AAUSRTPA331T-IRCV are our external nodes
we want to set profile option "Node Trust Level" to "External" for the two nodes above