Oracle Database and Apps Scripts

Concurrent Managers Status:

set lines 150
set pages 200
column QUEUE format a24
column USER_CONCURRENT_QUEUE_NAME format a46
column TARGET_NODE format a15
Column concurrent_queue_id format 999999 head Q_Id
column cache_size format 999 heading "CACHE"

Select fcq.concurrent_queue_id "Q_Id" ,fcqt.USER_CONCURRENT_QUEUE_NAME,
fcq.CONCURRENT_QUEUE_NAME Queue,TARGET_NODE,MAX_PROCESSES,RUNNING_PROCESSES ,cache_size
from apps.FND_CONCURRENT_QUEUES fcq,APPS.fnd_concurrent_queues_tl fcqt
where ENABLED_FLAG='Y'
and fcq.application_id = fcqt.application_id
and fcq.concurrent_queue_id = fcqt.concurrent_queue_id
and fcqt.language = userenv('LANG')
and MAX_PROCESSES >0
order by fcq.concurrent_queue_id
--order by USER_CONCURRENT_QUEUE_NAME ,MAX_PROCESSES desc;

HOW TO FIND APPLICATIONS USER PASSWORD in R12

Connect apps

SQL> conn apps/pwd

Package:

CREATE OR REPLACE PACKAGE APPS_PKG AS
FUNCTION decrypt (KEY IN VARCHAR2, VALUE IN VARCHAR2)
RETURN VARCHAR2;
END APPS_PKG;

Package body:

CREATE OR REPLACE PACKAGE BODY APPS_PKG 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 APPS_PKG;

Query to get Username and Password:

SELECT Usr.User_Name,
Usr.Description,
APPS_PKG.Decrypt (
(SELECT (SELECT APPS_PKG.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';