How to get Apps password in R12???
Connect to sysdba and follow the below procedure
alter session set current_schema=apps ;
CREATE OR REPLACE PACKAGE get_pwd AS FUNCTION decrypt ( KEY IN VARCHAR2 ,VALUE IN VARCHAR2 ) RETURN VARCHAR2;
END get_pwd;
/
CREATE OR REPLACE PACKAGE BODY get_pwd AS FUNCTION decrypt ( KEY IN VARCHAR2 ,VALUE IN VARCHAR2 )
RETURN VARCHAR2 AS LANGUAGE JAVA NAME ‘oracle.apps.fnd.security.
END get_pwd;
/
SELECT (SELECT get_pwd.decrypt (UPPER ((SELECT UPPER (fnd_profile.VALUE (‘GUEST_USER_PWD’)) FROM DUAL)), usertable.encrypted_founda
AS apps_password FROM applsys.fnd_user usertable WHERE usertable.user_name LIKE UPPER ((SELECT SUBSTR (fnd_profile.VALUE (‘GUEST_USER_PWD’) ,1 , INSTR (fnd_profile.VALUE(‘GUEST_
Nagulu Polagani
Latest posts by Nagulu Polagani (see all)
- ORA-12012 ORA-20001 ORA-06512: at “SYS.DBMS_STATS” - April 3, 2018
- PKIX path building failed, unable to find valid certification path - January 30, 2018
- ORA-16057: server not in Data Guard configuration - December 19, 2017