OAF JDeveloper Installation and Setting Environment

1)       Get the JDeveloper software ( ZIP File  : p8431482_R12_GENERIC.zip )

2)       Copy  into required drive ( folder ) / ( C:\)

Eg: C:\ JDEV  ( create JDEV ( name can be any one ) folder in C-drive

3)       Extract the ZIP file name p8431482_R12_GENERIC.zip )

Right click à WinZip à ExtractToHere

                After extracting it generates following

              

JDEV---- ( user created folder )

                                                |____      jdevbin

                                                |____      Jdevdoc

                                                |____   jdevhome

4)       Take the shortcut of  C:\JDEV\jdevbin\jdev\bin\ jdevW.exe     to desktop

5)       Copy the  vis.dbc file form Oracle Apps Server to JDeveloper

Source Oracle Apps path:   /u03/ERPDEV1/applmgr/inst/apps/ERPDEV_erpdev1/appl/fnd/12.0.0/Secure/ERPDEV1.dbc

See below screen shot (You can find the below screen shot by press "About the page" on any OAF page in apps)

JDevelopre Path: C:\JDEV\jdevhome\jdev\dbc_files\secure

6)       Set the Environment variables of O/S

My Computer -> Advanced ->Environment Variables-> New

Variable Name : JDEV_USER_HOME

Variable Value : C:\JDEV\jdevhome\jdev

OK > OK >OK

Testing Functionality of Jdeveloper

 1)  Open Jdeveloper and go to connection  Right Click  New database connection 
Next

Connection Name : test ( as desired )

Connection Type : Oracle ( JDBC )

Next :

2)       User Name            : apps

          Password               : apps

                Next

3)       Driver  : thin

   Host Name : localhost ( if database is on the local system, else URL of DB server )

   JDBC Port : 1521(your database port Number)

   SID            : VIS (Your Database SID)

For details see the vis.dbc located in the folder :

/u03/ERPDEV1/applmgr/inst/apps/ERPDEV_erpdev1/appl/fnd/12.0.0/Secure/ERPDEV1.dbc

APPS_JDBC_URL=jdbc\:oracle\:thin\:@(DESCRIPTION\=(LOAD_BALANCE\=YES)(FAILOVER\=YES)(ADDRESS_LIST\=(ADDRESS\=(PROTOCOL\=tcp)(HOST\=APPS.ora.com)(PORT\=1521)))(CONNECT_DATA\=(SID\=VIS)))

                Next

4)       Test Connection

          Result : success

          Next

5)       Finish