1 Reply Latest reply on Nov 18, 2015 9:02 AM by Bashar.

    Access FND_PROFILE from CUSTOM Schema

    user12194800

      We have created a Custom User CUSTOMDB. We want CUSTOMDB to acess FND_PROFILE package from APPS user.

      We gave the privilege to CUSTOMDB from APPS user.

      ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

      SQL> show user

      USER is "APPS"

      SQL> GRANT EXECUTE ON APPS.FND_PROFILE TO CUSTOMDB;

      Grant succeeded.

      SQL> commit;

      Commit complete.

      ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

      SQL> show user

      USER is "SYSTEM"

      SQL> GRANT EXECUTE ANY PROCEDURE TO CUSTOMDB

      ;

      2

      Grant succeeded.

      SQL> commit;

      Commit complete.

      ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

      SQL> show user

      USER is "CUSTOMDB"

      SQL> SELECT FND_PROFILE.VALUE_SPECIFIC('ICX_NUMERIC_CHARACTERS',0) FROM DUAL;

      SELECT FND_PROFILE.VALUE_SPECIFIC('ICX_NUMERIC_CHARACTERS',0) FROM DUAL

      *

      ERROR at line 1:

      ORA-00904: "FND_PROFILE"."VALUE_SPECIFIC": invalid identifier

      ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

      We even tried creating a synonym for the CUSTOMDB and tried to access the procedure. We faced the below error.

      SQL> conn apps

      Enter password:

      Connected.

      SQL> create synonym customdb.fnd_profile for apps.fnd_profile;

      Synonym created.

      SQL> commit;

      Commit complete.

      SQL> conn customdb

      Enter password:

      Connected.

      SQL> SELECT FND_PROFILE.VALUE_SPECIFIC('ICX_NUMERIC_CHARACTERS',0) FROM DUAL;

      SELECT FND_PROFILE.VALUE_SPECIFIC('ICX_NUMERIC_CHARACTERS',0) FROM DUAL

      *

      ERROR at line 1:

      ORA-00942: table or view does not exist

      ORA-06512: at "APPS.FND_CORE_LOG", line 45

      ORA-06512: at "APPS.FND_CORE_LOG", line 456

      ORA-06512: at "APPS.FND_PROFILE", line 122

      ORA-06512: at line 1

      SQL>