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

Database Options/Management Packs Usage Reporting for Oracle Databases 11.2 and later (Doc ID 1317265.1)

  Database Options/Management Packs Usage Report You can determine whether an option is currently in use in a database by running options_pa...