Monday, August 26, 2019

How To Set Profiles at the SERVRESP Level (Doc ID 2361202.1) To BottomTo Bottom

GOAL

How to set the profiles at the SERVRESP level
 

SOLUTION

Execute the steps below to enable SERVRESP profile level:

A. The steps below needs to be executed in order to have the SERVRESP level available.

Follow note below to set the profiles at the SERVRESP level:

Oracle E-Business Suite Release 12.2 Configuration in a DMZ (Doc ID 1375670.1) or any other release note.

The configuration of the E-Business Suite environment for DMZ requires these profile options hierarchy type to be set to SERVRESP.

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

 Source the Run Edition Environment file

 $ . ./u01/install/APPS/EBSapps.env run

 Switch the hierarchy type of the profile options to be of type server-responsibility

 $ sqlplus apps/apps @$FND_TOP/patch/115/sql/txkChangeProfH.sql SERVRESP

After the txkChangeProfH.sql script executes successfully, execute AutoConfig on all nodes to set the profile option values at server level

Then, set the profiles (like Application Framework Agent and/or Apps Servlet Agent)  at the server and responsibility level.

B. To set the profiles above to be updatable at the SERVRESP level:

1. Go to Application Developer responsibility > Profiles
2. Query up name like for example APPS_FRAMEWORK_AGENT
3. Check the Server+Responsibility to make Visible and Updatable.
4. Click Save.

Then, go to System Administrator responsibility to update the profiles at the SERVRESP level. Then, clear the cache, bounce the instance and test again.

  . Go to Functional Administrator responsibility > Core Services > Caching Framework > Global Configuration. Then, click Clear All Cache.
Reference note: Note 380489.1 - Using Load-Balancers with Oracle E-Business Suite Release 12.0 and 12.1 (Doc ID 380489.1)

REFERENCES

BUG:25702976 - DATAFIX - NEED A SCRIPT TO CLEAR PROFILE APPS FRAMEWORK AGENT AT USER LEVEL
NOTE:2153947.1 - Script POS_UPG_USR.sql Not Updating Profile Application Framework Agent at the User Level . Includes Clean Up Script: DATA_CLEANUP_SCRIPT_ALL.SQL
NOTE:380489.1 - Using Load-Balancers with Oracle E-Business Suite Release 12.0 and 12.1

No comments:

Post a Comment

fnd concurrent request queues and logs update

  create table apps.fnd_concurrent_queues_oci as select * from apps.fnd_concurrent_queues; create table fnd_concurrent_requests_oci as selec...