3 Replies Latest reply on Mar 11, 2016 1:55 PM by Pravin Takpire

    Error in finding password?

    Jithin Thomas

      Hi all

      'oracle.apps.fnd.security.WebSessionManagerProc.decrypt(java.lang.String,java.lang.String) return java.lang.String' working in APPS schema, in finding password. While showing the error shown below in other schema.


      ORA-00942: table or view does not exist

      ORA-06512: at "APPS.FND_VAULT", line 948

      ORA-06512: at "APPS.FND_WEB_SEC", line 2779

      00942. 00000 -  "table or view does not exist"

      Can someone ..Pls Help.

        • 1. Re: Error in finding password?



          Oracle EBS code should only be run under APPS schema. I think that this applies to Java classes as well.


          How To Run FND_GLOBAL.APPS_INITIALIZE (or any other API) Using A User Other Than APPS (Doc ID 822225.1)




          • 2. Re: Error in finding password?
            Jithin Thomas

            Thanks for the response..


            Actually the plsql code i am using is the  below one..

              SELECT FSMOB_GET_PASSWORD.decrypt (


                    (SELECT FSMOB_GET_PASSWORD.decrypt (fnd_web_sec.get_guest_username_pwd, usertable.encrypted_foundation_password )

                    FROM DUAL

                    ) AS apps_password

                  FROM fnd_user usertable

                  WHERE usertable.user_name =

                    (SELECT SUBSTR (fnd_web_sec.get_guest_username_pwd, 1, INSTR (fnd_web_sec.get_guest_username_pwd, '/' ) - 1 )

                    FROM DUAL


                  ), fu.encrypted_user_password ) PASSWORD

                FROM fnd_user fu

                WHERE UPPER(fu.user_name) = upper(p_username);

            the java code is given inside  FSMOB_GET_PASSWORD API..

            if this is possible only in APPS schema , how can the passwords be retrieved in other schema?

            Pls Help..

            • 3. Re: Error in finding password?
              Pravin Takpire

              you should run that as apps user. As you don't know which all internal tables/view/objects are being referred