Let us discuss how to configure JDeveloper in our system, we are here discussing in Windows environment step wise.
Step 1: First step is we need to set the Jdev environment variables for windows. Go to environment variable in windows properties. Right Click on Computer/My Computer select properties. The same scenario is shown in the below figure.
Select Advanced System Settings after choosing the Properties of Computer, the same scenario is shown in the below figure:
Now in the top User Variables select New Button for adding a New User variable as show in the below figure:
Note that you must give Variable name as “JDEV_USER_HOME” and Variable Value is the path of the jdevhome\jdev. Let us consider as a example I downloaded the patch and extracted it to Bharath\Softwares in D: drive now my path for Variable value is:
The same thing is shown in the below figure:
Step 2: After setting Variable name and Variable value we need to select DBC file into from Oracle Apps fnd top, copy DBC file and paste it in JDeveloper patch.
To know where exactly the DBC file is located in Oracle Apps go to About this Page and select Java System Properties tab then in the list we can find an System Property called DBC FILE, in the Value behind to DBC FILE is the path where exactly the DBC file located in the Oracle Apps.
The same scenario is shown in the below figure:
Step 3: After finding where exactly the DBC file located go to that particular path and copy the DBC file (note that don’t delete the dbc file and also don’t cut it).
Here we are using WinScp which connects to the server from our desktop system, we can also use putty to connect to the server or any other tool which works similar like WinScp or Putty connection manager.
Install WinScp and the following figure shows the icon how it look like:
While giving path name directly don’t give /naora1.dbc, according to the above figure give the path as
After giving path you will find DBC file just copy it, the same scenario is shown in the below figure:
After copying in your desktop system go to the jdevhome folder , then jdev, next dbc_files, and then next secure, here we will not find any files or documents the folder is empty now we need to paste the DBC file which we copied from the Oracle Apps Instance Server.
The following figures shows the same scenario:
Step 4: After pasting the DBC file now open the JDeveloper and create the Data Base Connection. After opening the file it will ask for Configure File Type Associations, on check box check all the available types to associate with JDeveloper. The below figure shows how the opening page looks like:
Step 5: Create a data base connection, go to Connections tab after that Right Click on Data Base folder and then select New Database Connection…, the same scenario is shown in the below figure:
After selecting New Database Connection… Welcome to the create Data Base connection window opens simply click on Next button. After that give the Connection Name here in the below figure if we observe the connection name is NewtonApples, and the Connection Type must be Oracle (JDBC)
Click on next button after giving Connection Name, in the next window it asks for username and password give Toad/Oracle SQL Developer tool connection name. The same scenario is shown in the below figure:-
After giving Username and Password click on the Next button, now you need to give connection details all the connection details we even can find in DBC file, to check those detail open the DBC file with notepad there you can find Host Name , JDBC Port, and Service Name. Give appropriate names and note that Driver type is thin.
Now after giving proper names click on the Next button we can find Test Connection button click on the Test Connection button to check the connection is success or not.
Click Next button and then click Finish button.
Step 6: This is the last step in JDeveloper configuration, set the JDeveloper default Project Properties. Go to Tools à Default Project Properties. The same scenario is shown in the below figure:
After selecting Default Project Properties… from Tools menu, in the highlighted Project Properties extract Oracle Applications and select Run time Connection.
The same scenario is shown in the below figure:
Now give the following details:
DBC File Name: Give the path where exactly the DBC File is stored which actually we copied from server to our desktop system.
User Name: The user name is Oracle Apps instance User Name
Password: Password is Oracle Apps instance Password.
Application Short Name: Any application short name which user got access permit and also note that whatever the application short name we are giving it must contain at least one OAF page and also that must be attached to the responsibility of the User Name which we are giving.
Responsibility Key: Responsibility key of the Application Short Name.
The below figure shows the example showing DBC file path, User Name, Password, Application Short Name, Responsibility Key. Just have a look into the picture.
Finally click on OK button, so that we finished our JDeveloper Configuration process.