Wednesday 17 September 2014

Setup OAF Development Enviornment

It is critically important that an OA Framework developer obtains the specific version of JDeveloper 10g with OA Extension for their version of E-Business Suite. JDeveloper 10g with OA Extension is used with R12 E-Business Suite instances.
It would be possible to include a table of the patch numbers that contain the specific versions of JDeveloper 10g with OA Extension. There is a very specific Oracle MetaLink Note that contains all the latest information on the released patches.
How to find the correct version of JDeveloper to use with E-Business Suite 11i or Release 12 – MetaLink Note: 416708.1

Release 11i

OA Framework 5.10 patchOracle 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
11i.ATG_PF.H.delta.7 (patch 6241631)Patch 8751878 9I JDEVELOPER WITH OA EXTENSION ARU FOR 11I RUP7

Release 12.0

ATG Release 12 VersionOracle JDeveloper 10g Patch
12.0.0Patch 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

Release 12.1

ATG Release 12.1 VersionOracle JDeveloper 10g Patch
12.1 (Controlled Release - only included for completeness)Patch 7315332 10G Jdev with OA Extension ARU for R12.1 (Controlled Release)
12.1.1 (rapidInstall or patch 7303030)Patch 8431482 10G Jdeveloper with OA Extension ARU for R12.1.1
12.1.2 (patch 7303033 or patch 7651091)Patch 9172975 10G JDEVELOPER WITH OA EXTENSION ARU FOR R12.1.2
12.1.3 (patch 9239090 or patch 8919491)Patch 9879989 10G JDEVELOPER WITH OA EXTENSION ARU FOR R12.1.3
12.1.3.1 (patch 11894708)Patch 9879989 10G JDEVELOPER WITH OA EXTENSION ARU FOR R12.1.3
12.1.3.2 (patch 15880118)Patch 9879989 10G JDEVELOPER WITH OA EXTENSION ARU FOR R12.1.3

Release 12.2

ATG Release 12.2 VersionOracle JDeveloper 10g Patch
12.2Patch 17513160 10G JDeveloper with OA Extension ARU for R12.2, certfied on Windows 7, Windows XP-SP2, and Linux. Preferred web browser is Microsoft Internet Explorer 6.0 or above.
12.2.3Patch 17888411 10G JDeveloper with OA Extension ARU for R12.2.3, certfied on Windows 7, Windows XP-SP2, and Linux. Preferred web browser is Microsoft Internet Explorer 8.0 or above for the Skyros Look-and-Feel and Internet Explorer 6.0 or above for the Swan Look-and-Feel.



When you download the proper patch for your E-Business Suite instance, the patch will be named similar to the following:
p5856648_R12_GENERIC.zip
JDeveloper 10g with OA Extension does not contain a installation routine. The installation process consists of unzipping the patch to a directory of your choice. For example, you could use the following:
On Linux – /JDev
On Windows – D:/JDev
When you unzip the patch, it will create three (3) subdirectories as follows:
jdevbin – This subdirectory contains all the executables, utilities, and supporting files for JDeveloper 10g with OA Extension.
jdevdoc – This subdirectory contains the OA Framework Developer’s Guide (OAFDG) along with the Javadoc files for the APIs.
jdevhome – This subdirectory is empty. But, it can be used as the base directory for your OA Framework files.
Installing and Setting Up JDeveloper
  1. Refer to MetaLink note 416708.1 to obtain the proper patch for your E-Business Suite instance.
  2. Download the proper JDeveloper patch.
  3. Install JDeveloper by unzipping it to a directory of your choice.
  4. Configure your environment variables.
  5. Obtain the database connection file (.dbc) for your E-Business Suite instance.
  6. Create a shortcut to the JDeveloper executable.
  7. Create a Framework Development user and responsibility for OA Framework testing.
  8. Uncompress Tutorial.zip into your JDEVHOME directory.
  9. Launch JDeveloper 10g.
  10. Configure the connections.
  11. Test your install and configuration.
Configure Your Environment Variables
  1. JDEV_USER_HOME is a mandatory environment variable that points to the base directory where your development files are stored.
  2. JDEV_JAVA_HOME is an optional environment variables that points to a specific Java SDK.
Get the DBC File
The file is located in:
$INST_TOP/appl/fnd/12.0.0/secure
Put the file into your:
JDEV_USER_HOME/dbc_files/secure
Create a Shortcut
The executable for JDeveloper is located as follows:
  • Windows – D:\JDev\jdevbin\jdev/bin\jdevW.exe
  • Linux – \JDev\jdevbin\jdev\bin\jdev
Note: Linux does not run the .exe (Windows) executable.
Creating a shortcut varies by operating system as follows:
  • Windows – create a desktop shortcut to the JDeveloper executable noted above.
  • Linux – create an alias or shell script the points to the JDeveloper executable noted above.
Uncompress Tutorial.zip
In the JDEVBIN directory, there is a file named, Tutorial.zip. Uncompress this file into your JDEVHOME directory.
Because the .zip file contains the ./jdev/… and other directories, it will create the proper structure for you as it is uncompressed.
Launch JDeveloper 10g
The method to launch JDeveloper with vary depending on operating system, operating system version, and the shell.
Note: The first time JDeveloper 10g is launched you see the Start Page. It is something you should close.

Configure the Connections and Test
The steps to configure the connections and test are as follows:
  1. Configure the database connection.
    • Connections tab on Navigator panel.
    • Right-click Database, select New Database Connection
    • Name the connection
    • Username = apps (This is the database user to which you are going to connect. Within E-Business Suite, the master database user that has access to all the E-Business Suite database objects is apps.)
    • Password = apps (The default password for the apps database user is apps. Note: On production servers or any server requiring security, it is important that this password has been changed.)
    • Set the host name and SID. If you don’t know the settings, look at the DBC file.
    • Test the connection
    • Finish
  2. Click the Applications Navigator tab.
  3. Choose File > Open > myprojects > toolbox.jws.
  4. Expand toolbox in the Applications Navigator panel.
  5. Double-click Tutorial to open Project Properties window.
  6. Expand the Oracle Applications menu entry.
  7. Choose Oracle Applications > Runtime Connection.
  8. Set the DBC File Name to the directory and name for your DBC file.
  9. Click the Save All icon to save your progress
  10. Expand Tutorial.
  11. Expand the Web Content folder.
  12. Right-click test_fwktutorial.jsp, and choose Run.
  13. You should see the test_fwktutorial.jsp page as follows:

  14. You should see the Hello, World! Page as follows:



    At this point, if you have seen both the test_fwktutorial.jsp page and the Hello, World! page, you know several things.

    • You have connected to a database, or else test_fwktutorial.jsp would not have worked.
    • You have connected to an R12 E-Business Suite applications instance, or else Hello, World! would not have worked.
    • You have a user on that E-Business Suite instance named, FWKTESTER, with a password of FWKDEV, assigned to the AK product, and given the FWK_TBX_TUTORIAL responsibility.
    • Your installation and configuration is complete.