Wednesday, December 11, 2013

JDeveloper Installation and OAF Setup Guide


Note: The instructions for Jdeveloper Setup are for Windows-XP


Step1: Selecting JDeveloper version – Please refer below table for the correct JDeveloper patch, corresponding to the Oracle Apps ATG patch level. You can refer Metalink Doc ID: 416708.1 for the same.

To determine the ATG patch level – try running the below SQL

SELECT MAX(MAINT_PACK_LEVEL) FROM AD_APPLIED_PATCHES

Release 11i

OA Framework 5.10 patch
JDeveloper 9i Patch
ATG.PF.H (patch 3438354 or Oracle Applications 11.5.10)
Patch 4045639 9IJDEVELOPER WITH OA EXTENSION ARU FOR FWK.H
ATG PF CU1 (patch 4017300)
Patch 4141787 9IJDEVELOPER WITH OA EXTENSION ARU FOR CU1
ATG PF CU2 (patch 4125550)
Patch 4573517 Oracle9i JDeveloper with OA Extension for 11.5.10 CU2
11i.ATG_PF.H RUP3 (patch 4334965)
Patch 4725670 9IJDEVELOPER WITH OA EXTENSION ARU FOR 11i10 RUP3
11i.ATG_PF.H RUP4 (patch 4676589)
Patch 5455514 9IJDEVELOPER WITH OA EXTENSION ARU FOR 11i10 RUP4
11i.ATG_PF.H RUP5 (patch 5473858)
Patch 6012619 9IJDeveloper With OA Extension ARU FOR 11i10 RUP5
11i.ATG_PF.H.RUP6 (patch 5903765)
Patch 6739235 9IJDeveloper With OA Extension ARU FOR 11i10 RUP6
Patch 6469392 9IJDEVELOPER WITH OA EXTENSION ARU FOR 11I10 RUP6

Release 12

ATG Release 12 Version
JDeveloper 10g Patch
12.0.0
Patch 5856648 10g Jdev with OA Extension
12.0.1  (patch 5907545)
Patch 5856648 10g Jdev with OA Extension
12.0.2  (patch 5484000 or 5917344)
Patch 6491398 10g Jdev with OA Extension ARU for R12 RUP2 (replaces 6197418)
12.0.3  (patch 6141000 or 6077669)
Patch 6509325 10g Jdev with OA Extension ARU for R12 RUP3
12.0.4 (patch 6435000 or 6272680)
Patch 6908968 10G JDEVELOPER WITH OA EXTENSION ARU FOR R12 RUP4
12.0.5 (No new ATG code released)
No new JDev patch required
12.0.6  (patch 6728000 or patch 7237006)
Patch 7523554 10G Jdeveloper With OA Extension ARU for R12 RUP6
12.1 (Controlled Release - only included for completeness)
Patch 7315332 10G Jdev with OA Extension ARU for R12.1 (Controlled Release)

(Courtesy: Metalink)


Note: For GPI01 – the ATG version is 12.0.2 and corresponding JDev Patch is 6491398.

Step 2: Extract JDev patch - Unzip the downloaded patch file on to a directory of your choice (see **NOTE below) in your local drive. This will contain JDeveloper and FND libraries under your <jdev_install_dir>.

E.g. extract the zip file to “D:\fwksg2” (<jdev_install_dir>) folder. This will contain the following sub-folders – “jdevbin”, “jdevdoc” and “jdevhome”. Below screenshot shows the directory structure.

   **NOTE: The installation directory to which you are unzipping this file must NOT contain spaces i.e. Do not unzip to “C:\Program Files\jdeveloper”.





Step 3: Set Environment variable -

Go to My Computer > right-click > properties > Advanced > Environment Variables > New

On the New User Variable dialog, enter JDEV_USER_HOME in the Variable Name field. Set the Variable Value field to <jdev_install_dir>\jdevhome\jdev where <jdev_install_dir> is the drive where you installed the JDeveloper OA Extension zip file. For example:D:\fwksg2”.

Refer below screenshot



Step 4: Obtaining a Database Connection File - Obtain the database connection (.dbc) file under FND_SECURE top from the system administrator and place this file in <JDEV_USER_HOME>\dbc_files\secure directory (Refer step 3 for <JDEV_USER_HOME>). Attached is the “GPI01.dbc” file for GPI01. Refer below screenshot for the file path “D:\fwksg2\jdevhome\jdev\dbc_files\secure\GPI01.dbc”.




Step 5:  Creating a Desktop Shortcut to JDeveloper - To facilitate launching JDeveloper, create a desktop shortcut to jdevbin\jdev\bin\jdevW.exe. e.g. D:\fwksg2\jdevbin\jdev\bin\jdevW.exe.

Refer below screenshot





Step 6: Assigning ToolBox Responsibilities – As a part of the installation, we need to create front-end user in Oracle Apps and assign the following responsibilities:

·   OA Framework ToolBox Tutorial (responsibility key is FWK_TBX_TUTORIAL).
·   OA Framework ToolBox Tutorial Labs (responsibility key is FWK_TOOLBOX_TUTORIAL_LABS).

Access GPI01 front-end using the following link: GPI01 R12 Front-end..

Use Sys-Admin responsibility to create new user and assign responsibilities.

Refer below screenshot.

Note: Skip this step, if you already have an existing user having the above responsibilities.



·   Select the desktop shortcut created in Step 5 to launch Oracle JDeveloper. Note: If it asks to migrate – select “No”.
·   Select File > Open from the main menu, and then navigate to <JDEV_USER_HOME>\myprojects. Open the OA Framework ToolBox Tutorial workspace file (toolbox.jws). Refer below screenshot.





Note: If it asks to migrate – select “Yes”.
·   Select View > System navigator from main-menu.



·   Expand the toolbox.jws in the JDeveloper System Navigator, to display its contents. Select the Tutorial.jpr project, and then select Project > Project Settings. Refer below screenshot.


·   Expand the Oracle Applications node, which is In the Project Settings dialog, and select Runtime Connection. Locate the DBC file that you saved in Step 4 by using the Browse... button, which is In the Connection box. The file should be in the <JDEV_USER_HOME>\dbc_files\secure directory. Specify the User Name and Password for the front-end user. This is the user that you assigned the ToolBox responsibilities to in Step 6. Select OK. Refer below screenshot.


·   Repeat the above two steps for LabSolutions.jpr project.
·   Go to Connections Navigator tab in JDeveloper and then expand the Database node. Right-click on the Database node and select New Connection... to open the Connection Wizard. Follow the JDeveloper instructions to define a new database connection for the Oracle Applications database identified by the DBC file you selected above. Finally test the connections.



Note: For GPI01 - use the following values:                                                                                                                Name-GPI01 (or any other name)
Username/pwd- apps/apps
Connection: Host - locdb3009.xx.com
Port – 1521
Service-Name – GPI01

Refer below screenshots.









·   Navigate back to System Navigator and select the Tutorial.jpr project. Right-click and select Add to Project Content..                                                                                                                       
·   Select the Connection option in the Business Components Project Wizard and set the Connection Name to the connection you just defined. Select OK to save your changes.

Refer below screenshots.




·   Repeat the above step for LabSolutions.jpr project. 

Step 8: Embedded OC4J server settings

·   Go to Tools > Embedded OC4J server preferences. Refer below screenshot.




·   Click on “Startup” and set the Host Name or IP address radio-button to “Default Local IP Address”. Refer below screenshot.


Step 9: Compile Project and test run the setup

·   Go to System Navigator tab > Select toolbox.jws > right click and select Rebuild from menu.




·   To test run the setup you may run the page “HelloWorldPG.xml” under the tutorial.jpr project. To run – right click on the page and select run.

 Refer below screenshot for the navigation to “HelloWorldPG.xml”.

(Tutorial.jpr > oracle.apps.fnd > framework > toolbox > webui > HelloWorldPG.xml)




·   On successful execution, you should be able to view the “HelloWorld” page. Refer below screenshot.





Note: Follow step 10, only when connecting over VPN or while using proxy servers to access Oracle Apps front end.

Step 10: Configuration over VPN/proxy servers

·   Set the Host Name or IP address radio-button under “OC4J Embedded server preferences” to Specify Host name as “127.0.0.1”. Refer below screenshot. For navigation check step 8.


·   Set the Web-Browser and proxy setting under Preferences. Navigation: Tools > Preferences > Web Browser and Proxy. Check “Use HTTP Proxy Server” and include the proxy server details – Host name, port number and exceptions (this should be same as the proxy server settings on I.E)

Refer below screenshot.

Note: Dummy values are used in the below screenshot.  

















No comments:

Post a Comment