Forgot your Password?

Forgot your Password?
Almost every website that uses username & password have a "forget password" functionality to retrieve users passwords, and so also the Oracle E-Business Suite.This is a very useful functionality since it reduces the number of SR's opened to the helpdesk team regarding login problems and moreover satisfying the customers which can get a new password in a very short time with no helpdesk intervention.The implementation of this functionality is very simple and easy. To enable it you should:set the profile "Local Login Mask" to the current value plus 8 (e.g. current value is 32 -> set value to 40) Bounce Apache The "Local Login Mask" profile used to customize some attributes of the login page (AppsLocalLogin.jsp), one of them is the "forgot your password" link. You should set the value of this profile to the sum of all attribute's mask values you are interested in.The full attributes list is:AttributeMask Value Binary value Hint for Username 01 00000001 Hint for Password 02 00000010 Cancel button 04 00000100 Forgot Password link 08 00001000 Registration link 16 00010000 Language Images 32 00100000 Corporate Policy Message 64 01000000 Setting the Forgot Password link mask value will add the following TIP to the login page:The reset password process:- Click on "Forgot your password?" link will ask for a username to which reset the password.- After typing the username and click OK, a new workflow process is started (Item type UMXUPWD) and you'll get this confirmation message:- Shortly you'll get this email - "Password reset required approval" (expired after 4 hours).- Click on "Approve" to confirm you are interested in a new password.- Shortly you'll get an email with a temporary password which you have to change on first login.Very nice and easy to implement functionality, which could be very beneficial.
Posted by Mohammed Sajid Siddique at 9:18 AM 0 comments

Apps User Connection Details
This is going to be my first post... so I decided to bring a very useful SQL for apps DBA's.This SQL shows details about users connected to the system (sid, responsibilty, form name, Oracle pid, Application pid and more..)The parameters are Apps Username or Oracle Session Id (put % where you don't pass a parameter).Very useful when you have a heavy session or when you have a DB lock and you want to know who is standing from behind (the applicative user)...It contains 3 SQL's with unions:1) 1st sql - OA Framework screens (login screen, iSupport etc...)2) 2nd sql - Responsibility connection details (for Java Applet)3) 3rd sql - Forms connection detailsselect usr.user_name "Apps Username",i.first_connect "First Connect Date",ses.sid,ses.serial#,ses.module,v.spid "Oracle Server Process",ses.process "Application Server Process",rsp.responsibility_name "Responsibility Name",null "Responsibility Start Time",fuc.function_name "Function Name",i.function_type "Function Type",i.last_connect "Function Start Time"from icx_sessions i,fnd_logins l,fnd_appl_sessions a,fnd_user usr,fnd_responsibility_tl rsp,fnd_form_functions fuc,gv$process v,gv$session seswhere i.disabled_flag = 'N'and i.login_id = l.login_idand l.end_time is nulland i.user_id = usr.user_idand l.login_id = a.login_idand a.audsid = ses.audsidand l.pid = v.pidand l.serial# = v.serial#and i.responsibility_application_id = rsp.application_id(+)and i.responsibility_id = rsp.responsibility_id(+)and i.function_id = fuc.function_id(+)and i.responsibility_id not in (select t1.responsibility_idfrom fnd_login_responsibilities t1where t1.login_id = l.login_id)and rsp.language(+) = 'US'and usr.user_name like '&APPS_USER_NAME'and ses.sid like '&SID'unionselect usr.user_name,l.start_time,ses.sid,ses.serial#,ses.module,v.spid,ses.process,rsp.responsibility_name,r.start_time,null,null,null form_start_timefrom fnd_logins l,fnd_login_responsibilities r,fnd_user usr,fnd_responsibility_tl rsp,gv$process v,gv$session seswhere l.end_time is nulland l.user_id = usr.user_idand l.pid = v.pidand l.serial# = v.serial#and v.addr = ses.paddrand l.login_id = r.login_id(+)and r.end_time is nulland r.responsibility_id = rsp.responsibility_id(+)and r.resp_appl_id = rsp.application_id(+)and rsp.language(+) = 'US'and r.audsid = ses.audsidand usr.user_name like '&APPS_USER_NAME'and ses.sid like '&SID'unionselect usr.user_name,l.start_time,ses.sid,ses.serial#,ses.module,v.spid,ses.process,null,null,frm.user_form_name,ff.type,f.start_timefrom fnd_logins l,fnd_login_resp_forms f,fnd_user usr,fnd_form_tl frm,fnd_form_functions ff,gv$process v,gv$session seswhere l.end_time is nulland l.user_id = usr.user_idand l.pid = v.pidand l.serial# = v.serial#and v.addr = ses.paddrand l.login_id = f.login_id(+)and f.end_time is nulland f.form_id = frm.form_id(+)and f.form_appl_id = frm.application_id(+)and frm.language(+) = 'US'and f.audsid = ses.audsidand ff.form_id = frm.form_idand usr.user_name like '&APPS_USER_NAME'and ses.sid like '&SID';