5 Replies Latest reply on Jun 5, 2017 8:53 AM by Sanjay Desai EBS

    FND_USER_PKG

    775371

      Hi,

       

        When executing below script as apps user and giving success

       

      set serveroutput on

      begin

      if (apps.fnd_user_pkg.validatelogin(username   => 'test',

                                           password   => 'test')) then

      dbms_output.put_line('SUCCESS');

      else

      dbms_output.put_line('ERROR');

      end if;

      end;

      /

      SUCCESS

       

      PL/SQL procedure successfully completed.

       

       

      But when executing as custom schema, giving error

       

      set serveroutput on

      begin

      if (apps.fnd_user_pkg.validatelogin(username   => 'test',

                                           password   => 'test')) then

      dbms_output.put_line('SUCCESS');

      else

      dbms_output.put_line('ERROR');

      end if;

      end;

      /

       

      ERROR

       

      PL/SQL procedure successfully completed.

       

       

      Please suggest

        • 1. Re: FND_USER_PKG
          mdtaylor

          That is because all apps packages are compiled with invoker's rights. You would have to grant execute on fnd_user, plus cursively grant each and every object referenced within fnd_user to a custom schema.  Even then, it is not guaranteed to work the same as when executed as apps.

          • 2. Re: FND_USER_PKG
            775371

            If we create custom package in custom schema, will it work ?

            • 3. Re: FND_USER_PKG
              775371

              hv already granted execute on fnd_user_pkg

              • 4. Re: FND_USER_PKG
                mdtaylor

                You would need to data pump the apps schema out and import it back into your custom schema.  Apps package call table objects by local synonyms, so you would need to have all of the grants and synonyms present in the normal apps schema.  Doing this would add about 10GB to your system tablespace.  What exactly is the requirement here?  If you want to call this custom process as a concurrent request, it has to run as apps owner.

                 

                Oracle Applications Development guidelines dictate that custom code resides in the apps schema and custom tables reside in a custom product top schema.

                 

                Integrating Custom Objects and Schemas

                Oracle E-Business Suite Developer's Guide

                • 5. Re: FND_USER_PKG
                  Sanjay Desai EBS

                  It's recommend to run the seeded script from APPS schema only because the all the grants of the API and objects referred by this API to APPS schema only.