Thursday 6 February 2020

Script to set Profile Option Value for Site from backend

DECLARE
   v_profile1                     BOOLEAN;
BEGIN
   v_profile1 :=
      fnd_profile.SAVE ('OKS_ITEM_DISPLAY_PREFERENCE'
  , 'DISPLAY_NAME'
                      , 'SITE'
                       );
   COMMIT;
EXCEPTION
   WHEN OTHERS
   THEN
      fnd_file.put_line (fnd_file.LOG, 'Exception : '
                          || SQLERRM);
END;
/

No comments:

Post a Comment