Technology Stack - EBS (MOSC)

MOSC Banner

how to change Profile Option Value by SQL

edited Mar 12, 2016 4:01AM in Technology Stack - EBS (MOSC) 3 commentsAnswered

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center