EBS Customizations (MOSC)

MOSC Banner

Use API fnd_request.set_target_options to pin a program to a node or instance

edited Sep 21, 2011 5:32PM in EBS Customizations (MOSC) 4 commentsAnswered
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;"

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