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

How To View Reports in Oracle Apps directly in HTML

I think all the users in Oracle Apps use Tools > Copy function to view and print their reports. But Oracle has a useful Profile Option to view all the reports directly in HTML and not in a window. I found it really usefull and want to share the same with you all.

1. Query for profile option Viewer:Text
2. At the appropriate level put "Browser"
3. Save

Log back and check.This should work