Application issues

*************************************************************************
If opmn services is not coming up in R12 then do clean shutdown of all application services then remove following directories.

  rm -fr $INST_TOP/ora/10.1.3/j2ee/oacore/persistence/*
        rm -fr $INST_TOP/ora/10.1.3/j2ee/oafm/persistence/*
        rm -fr $INST_TOP/ora/10.1.3/j2ee/forms/persistence/*

then start opmn services and check services.

*************************************************************************
To find the version of package from database;
select text from  dba_source where name like 'ECS_AR_EDI810_OUTINT_PKG' and line < 10
*************************************************************************

FINDING SYSADMIN PASSWORD IN R12
++++++++++++++++++++++++++++++++++
--> Connect to APPS USER
--> Create PACKAGE and PACKEGE BODY.
--> Query for PASSWORD by providing USERNAME

SQL> CREATE OR REPLACE PACKAGE XXX_GET_PWD AS
FUNCTION decrypt (KEY IN VARCHAR2, VALUE IN VARCHAR2)
RETURN VARCHAR2;
END XXX_GET_PWD;
/  2    3    4    5

Package created.

SQL> CREATE OR REPLACE PACKAGE BODY XXX_GET_PWD AS
FUNCTION decrypt (KEY IN VARCHAR2, VALUE IN VARCHAR2)
RETURN VARCHAR2 AS
LANGUAGE JAVA NAME 'oracle.apps.fnd.security.WebSessionManagerProc.decrypt(java.lang.String,java.lang.String) return java.lang.String';
END XXX_GET_PWD;  2    3    4    5
  6  /

Package body created.

SELECT Usr.User_Name,
       Usr.Description,
       XXARTO_GET_PWD.Decrypt (
          (SELECT (SELECT XXARTO_GET_PWD.Decrypt (
                             Fnd_Web_Sec.Get_Guest_Username_Pwd,
                             Usertable.Encrypted_Foundation_Password)
                     FROM DUAL)
                     AS Apps_Password
             FROM applsys.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)),
          Usr.Encrypted_User_Password)
          Password
  FROM applsys.Fnd_User Usr
 WHERE Usr.User_Name = '&User_Name';