Prerequisites
Desktop with 1.5 GB RAM
1.Telnet and FTP access to apps and db server
2.Database connectivity details:
3.Apps username and password,
4.SID,
5.Host Name and port.
6.Exact version of OA Framework on server
Get the JDeveloper software ( Ex:ZIP File : p4141787_11i_GENERIC.zip )
Copy into required drive ( folder ) / ( C:)
Eg: C: JDEV ( create JDEV ( name can be any one ) folder in C-drive
Extract the ZIP file name p4141787_11i_GENERIC.zip )
Right click à WinZip à Extract To Here
After extracting it generates following
JDEV—- ( user created folder )
|____ jdevbin
|____ Jdevdoc
|____ jdevhome
Take the shortcut of C:JDEVjdevbinjdevbin jdevW.exe to desktop
Copy the TEST.dbc file form Oracle Apps Server to JDeveloper
Source Oracle Apps path:
oracleinst_TOPappstest2applfnd12.0.0secureTEST.dbc
JDeveloprer Path: C:JDEVjdevhomejdevdbc_filessecure
Set the Environment variables of O/S
My Computer à Advanced à Environment Variables à New à
Variable Name : JDEV_USER_HOME
Variable Value : C:JDEVjdevhomejdev
OK à OKàOK
Testing Functionality of Jdeveloper
Go to connection à Right Click à New database connection à Next à
Connection Name : test ( as desired )
Connection Type : Oracle ( JDBC )
Next :
User Name : apps
Password : apps
Next
Driver : thin
Host Name : localhost ( if database is on the local system, else URL of DB server )
JDBC Port: 1521
SID : VIS
For details see the vis.dbc located in the folder :
oracleinst_TOPappsfnd12.0.3secureapps
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
Test Connection
Result: success
Next
Finish
Recent Posts
