Reinstate MO Operating Unit at Site level

Many times it happen, specially to new users, that the value at the site level for pofile option MO:Opertaing Unit is nulled or deleted. This can cause some problems to them. Belive me i was scared like hell when i did it accidentally. But you can use the following script to reinstate the value at the site level for this profile option.


QUOTE
--------------------

DECLARE
   stat       BOOLEAN;
BEGIN
   DBMS_OUTPUT.DISABLE;
   DBMS_OUTPUT.ENABLE (100000);

   stat := fnd_profile.SAVE ('ORG_ID', <<Org Id>>, 'SITE');

   IF stat
   THEN
      DBMS_OUTPUT.put_line ('Stat = TRUE - profile updated');
   ELSE
      DBMS_OUTPUT.put_line ('Stat = FALSE - profile NOT updated');
   END IF;

   COMMIT;
END;
/


----------------
UNQUOTE