Use API fnd_request.set_target_options to pin a program to a node or instance
Hello all, hope someone can help with this question I got from client......He has a question about use of API fnd_request.set_target_options that they want to use to pin a program to a node or instance. In order to be able to pin all programs running under the same responsibility, they want to place this API in the profile option "Initialization SQL statement - custom" by responsibility.
The code they use is as follows:
"declare v_noderet boolean;
BEGIN v_noderet := fnd_request.set_target_options(node_name1=> null,instance1=>'TORSLS992',node_name2=>NULL,instance2=>NULL);end;"
"declare v_noderet boolean;
BEGIN v_noderet := fnd_request.set_target_options(node_name1=> null,instance1=>'TORSLS992',node_name2=>NULL,instance2=>NULL);end;"
0