Blogs >> Technology >>
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;
|