How To -General Part 1

How to enter in to Oracle Application using AppsLocalLogin.jsp by leaving password field blank?



Step no 1
In the Username field enter UserName/Password, then clcik on Login button, this works fine till R12.
-------------------------------------------------------------------------------------------------

How to get the instance details like SID, Host Name, Apps Version and Database version from the back end?

Step no 1
select i.instance_name, i.host_name, f.release_name release, i.version from v$instancei,fnd_product_groups f where upper(substr(i.instance_name,1,4)) =upper(substr(f.applications_system_name,1,4));