Skip to main content

Command Palette

Search for a command to run...

Easy profile options for development purposes

Updated
•View as Markdown
Easy profile options for development purposes

Sometimes you need to set some profile options on a development environment to be able to find that OAF personalization or the name of that ViewObject. These are some of the profile options that play a part.

declare
  l_usr_id number;
  l_bool   boolean;
begin
  select user_id into l_usr_id from fnd_user where user_name = upper('&1');
  l_bool := fnd_profile.save('FND_CREATE_SEEDED_PERSONALIZATIONS', 'Y', 'USER', l_usr_id);
  l_bool := fnd_profile.save('FND_DIAGNOSTICS', 'Y', 'USER', l_usr_id);
  l_bool := fnd_profile.save('FND_PERSONALIZATION_REGION_LINK_ENABLED', 'Y', 'USER', l_usr_id);
  l_bool := fnd_profile.save('FND_PERSONALIZATION_SEEDING_MODE', 'Y', 'USER', l_usr_id);
  l_bool := fnd_profile.save('FND_DISABLE_ACCESS_KEYS', 'N', 'USER', l_usr_id);
  l_bool := fnd_profile.save('HR_ENABLE_USER_PERSONALIZATION', 'Y', 'USER', l_usr_id);
  l_bool := fnd_profile.save('DIAGNOSTICS', 'Y', 'USER', l_usr_id);
  l_bool := fnd_profile.save('SQL_TRACE', 'Y', 'USER', l_usr_id);
  l_bool := fnd_profile.save('ICX_NUMERIC_CHARACTERS', ',.', 'USER', l_usr_id);
  l_bool := fnd_profile.save('ICX_LANGUAGE', 'DUTCH', 'USER', l_usr_id);
  l_bool := fnd_profile.save('ICX_SESSION_TIMEOUT', '600', 'USER', l_usr_id);
  l_bool := fnd_profile.save('FND_HIDE_DIAGNOSTICS', 'N', 'USER', l_usr_id);
  l_bool := fnd_profile.save('APPS_SSO_LOCAL_LOGIN', 'BOTH', 'USER', l_usr_id);
  l_bool := fnd_profile.save('FND_CUSTOM_OA_DEFINTION', 'Y', 'USER', l_usr_id);
  l_bool := fnd_profile.save('APPLICATIONS_HOME_PAGE', 'FWK_TREE', 'USER', l_usr_id);
end;
/