Saturday, August 7, 2010

Profile Options

Set Profile Options In PLSQL
On request here is how to set the profile option value using PL/SQL

Function FND_PROFILE.SAVE can be used to set the value of any profile option at any level i.e. Site, Publish Post  Application, Responsibility, User etc.

Below is a sample code of how to use this function
   a   BOOLEAN;
   a := fnd_profile.SAVE ('CONC_REPORT_ACCESS_LEVEL'
                        , 'R'
                        , 'USER'
                        , '22746'
                        , NULL
                        , NULL

   IF a
      DBMS_OUTPUT.put_line ('Success');
      DBMS_OUTPUT.put_line ('Error');
   END IF;

Profile Option to View Output of Request submitted by other User

Set the value of profile Concurrent:Report Access Level to Responsibility.
The output submitted by other users can now be viewed from the responsibility through which the request was submitted.
The other option available is User,which restricts the output only to the user who submitted the request.

No comments:

Post a Comment