Post

How to programmatically update profile values at the SERVRESP level

Defining an external server in the E-Business Suite environment requires setting agent profile values at the SERVER level.

Here is the PL/SQL block that programmatically updates the profile values at the SERVER level:

declare 

  stat boolean; 

  m_node_id fnd_nodes.node_id%type := 0;

begin

  select node_id into m_node_id

    from fnd_nodes

   where node_name = upper('[SERVER]');

  stat:=fnd_profile.save('NODE_TRUST_LEVEL',

                         '3',

                         'SERVER',

                         m_node_id); -- 3 - External

  stat:=fnd_profile.save('APPS_WEB_AGENT',  

                         'http://[SERVER].[DOMAIN]/pls/[TWO_TASK]',

                         'SERVER',

                         m_node_id);

  stat:=fnd_profile.save('APPS_SERVLET_AGENT',               

                         'http://[SERVER].[DOMAIN]/OA_HTML',

                         'SERVER',

                         m_node_id);

  stat:=fnd_profile.save('APPS_JSP_AGENT',

                         'http://[SERVER].[DOMAIN]',

                         'SERVER',

                         m_node_id);

   stat:=fnd_profile.save('APPS_FRAMEWORK_AGENT',

                          'http://[SERVER].[DOMAIN]',

                          'SERVER',

                          m_node_id);    

   stat:=fnd_profile.save('ICX_FORMS_LAUNCHER',

                          'http://[SERVER].[DOMAIN]/forms/frmservlet', 

                          'SERVER',

                          m_node_id);

   commit;

end;

Metalink note 380490.1 "Oracle E-Business Suite R12 Configuration in a DMZ" describes how to configure the E-Business Suite for DMZ Deployments.

In section 5 you are required to update the Hierarchy Type of the following profiles:

Applications Web Agent
Applications Servlet Agent
Applications JSP Agent
Applications Framework Agent
ICX:Forms Launcher
ICX: Oracle Discoverer Launcher
ICX: Oracle Discoverer Viewer Launcher
Applications Help Web Agent
Applications Portal
BOM:Configurator URL of UI Manager
QP: Pricing Engine URL
TCF:HOST

The default hierarchy type value for the above profile options could be either Security or Server. See the image below:

Configuration of the E-Business Suite environment for DMZ requires these profile option hierarchy types to be set to SERVER-RESPONSIBILITY TYPE, or “SERVRESP”.

To change the profile options hierarchy type values to SERVRESP, execute the txkChangeProfH.sqlSQL script as shown below:

sqlplus apps/[email protected]/patch/115/sql/txkChangeProfH.sql SERVRESP

In this case defining an external server in an E-Business Suite environment requires setting agent profile values at the SERVRESP level.

Solution:

Here is the PL/SQL block that programmatically updates the profile values at the SERVRESP level without specifying the responsibility and the application ID:

declare

  stat boolean;

  m_node_id fnd_nodes.node_id%type := 0;

begin

  select node_id into m_node_id

    from fnd_nodes

   where node_name = upper('[SERVER]');

  stat:=fnd_profile.save('NODE_TRUST_LEVEL',

                         '3',

                         'SERVRESP', -1, -1,

                         m_node_id); -- 3 - External

  stat:=fnd_profile.save('APPS_WEB_AGENT',  

                         'http://[SERVER].[DOMAIN]/pls/[TWO_TASK]',

                         'SERVRESP', -1, -1,

                         m_node_id);

  stat:=fnd_profile.save('APPS_SERVLET_AGENT',               

                         'http://[SERVER].[DOMAIN]/OA_HTML',

                         'SERVRESP', -1, -1,

                         m_node_id);

  stat:=fnd_profile.save('APPS_JSP_AGENT',

                         'http://[SERVER].[DOMAIN]',

                         'SERVRESP', -1, -1,

                         m_node_id);

   stat:=fnd_profile.save('APPS_FRAMEWORK_AGENT',

                          'http://[SERVER].[DOMAIN]',

                          'SERVRESP', -1, -1,

                          m_node_id);    

   stat:=fnd_profile.save('ICX_FORMS_LAUNCHER',

                          'http://[SERVER].[DOMAIN]/forms/frmservlet', 

                          'SERVRESP', -1, -1,

                          m_node_id);

   commit;

end;

Contacts

www.RadugaApps.com

Feel free to contact our representative at [email protected]

Comments

Michael Dvorkin
17.07.2017

You can use the FND_PROFILE.DELETE function to set the profile value to blank

Prakash
29.05.2017

Hi , The above is nice useful post. I was trying to set one of the profile to blank @ site level using the below
stat:=fnd_profile.save('APPS_AUTH_AGENT', '', 'SITE');

But its failing .. how to set blank values for the profiles

Leave a comment