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
|
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.
·
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