Follow us: Connect on YouTube Connect on YouTube Connect on YouTube

Pages

Friday, 15 April 2016

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
Share this article :

4 comments:

  1. Oracle Apps R12 and Oracle Fusion Cloud Self Paced Online Training Videos Published on Udemy with Life Time Access & Live Meeting Support to Clear your Queries. Avail 25% to 80% discount. Please Check https://www.oracleappstechnical.com for Never Before Offers and Discount Coupon Codes.

    ReplyDelete
  2. Excellent article. Very interesting to read. I really love to read such a nice article. Thanks! keep rocking. humidity chamber

    ReplyDelete
  3. You probably know this, there are various different kinds of essays that you can be asked to write throughout your academic career. One is likely to be a persuasive essay. And for people which have little experience scripting this particular style, It could be very difficult at first. belltestchamber.com

    ReplyDelete
  4. Very informative post! There is a lot of information here that can help any business get started with a successful social networking campaign. small environmental chamber

    ReplyDelete