To get the apps user name and password

Write the following shell script and register it as conc program. log file will contain the username password of apps schema.

********************************************************************

# Created By : Vijaya Kumar Reddy

# Creation Date : 23-Feb-2009

# Script Name : xxbr100.prog

# Description : This Script accepts three parameters

#

#** ********************************************************************

#Parameters from 1 to 4 i.e $1 $2 $3 $4 are standard parameters

# $1 : username/password of the database

# $2 : userid

# $3 : USERNAME

# $4 : Concurrent Request ID

Details=$1

echo "-------------------------------------------------"

echo "Parameters received from concurrent program .."

echo "Time :" `date`

echo "Details :" ${Details}

echo "****************************************************************"


query to get Application Password:

Select Usr.User_Name, Usr.Description,

get_data.Decrypt((Select (Select get_data.Decrypt

(apps.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)), Usr.Encrypted_User_Password) Password

From Fnd_User Usr

Where Usr.User_Name = 'JASONMA';