Change Site Name Profile After Cloning Through Backend.
Sign in

Change Site Name profile after cloning through backend.

Use folowing query to Change Site Name profile after cloning through backend.

begin
fnd_profile_option_values_pkg.UPDATE_ROW(
      X_APPLICATION_ID => 0,
      X_PROFILE_OPTION_ID => 125,
      X_LEVEL_ID => 10001,
      X_LEVEL_VALUE => 0,
      X_LEVEL_VALUE_APPLICATION_ID => NULL,
      X_LEVEL_VALUE2 => NULL,
      X_PROFILE_OPTION_VALUE => 'test system Cloned as on Date xyz,
      X_LAST_UPDATE_DATE =>SYSDATE,
      X_LAST_UPDATED_BY => 0,
      X_LAST_UPDATE_LOGIN => 1
   );
   dbms_output.put_line('Done ');
   commit;
exception
when others then
dbms_output.put_line('Error is '||substr(sqlerrm,1,200));
end;

start_blog_img