How To Setup OA Framework in oracle applications 12.2.4

Task 1: Download and Extract the JDeveloper OA Extension zip file

1. Download Patch 19170592: 10G JDEVELOPER WITH OA EXTENSION ARU FOR R12.2.4
2. Extract the archive to c:\jdeveloper_1224
3. Make sure c:\jdeveloper_1224 has the following subdirectories:
jdev
jdevbin
jdevdoc
jdevhome

Task 2: Configure the JDEV_USER_HOME Environment Variable

On a Windows 7 Desktop, right click Computer icon > Properties > Advanced system settings > Environment Variables button > New button
Variable name = JDEV_USER_HOME
Variable value = c:\jdeveloper_1224\jdevhome\jdev

 

Task 3: Obtain the Database Connection file

Create the c:\jdeveloper_1224\dbc_files\secure directory
Ftp the dbc file located at $FND_SECURE to c:\jdeveloper_1224\dbc_files\secure directory

Task 4: Create a Desktop Short to JDeveloper

Right click on Windows desktop > New > Shortcut > Browse > c:\jdeveloper_1224\jdevbin\jdev\bin\jdevW.exe > Next > Finish

 

 

Task 5: Assign Toolbox Responsibilities to an Applications User

Assign the following responsibilities to a user:
- OA Framework ToolBox Tutorial
- OA Framework ToolBox Tutorial Labs

Task 6: Launch JDeveloper and Configure the Database Connection and the User

From JDeveloper main menu > File > Open and select c:\jdeveloper_1224\jdevhome\jdev\myprojects\toolbox.jws
Expand toolbox from the Applications Navigator tab

 

Select LabSolutions > right click > Project Properties > Oracle Applications > Runtime Connection
Set DBC File Name = c:\jdeveloper_1224\dbc_files\secure\<SID>.dbc
Set Username and Password to the user you assigned the 2 responsibilities

Select Tutorial > right click > Project Properties > Oracle Applications > Runtime Connection
Set DBC File Name = c:\jdeveloper_1224\dbc_files\secure\<SID>.dbc
Set Username and Password to the user you assigned the 2 responsibilities

Click Connections tab and expand Database

Right click Database > New Database Connection to open Connection Wizard > Next

Enter values for the following:
Connection Name
Username = apps
Password = <password>
Host Name
JDBC Port
Service Name
Click Next button > Test Connection > Make sure the Status indicates Success! > Next > Finish
Remove the existing fwk12dev > Right click > Delete

Click Applications Navigator tab
Right click LabSolutions > Project Properties > Business Components
Make sure Connection is set to the Connection Name you defined earlier > OK
Right click Tutorial > Project Properties > Business Components
Make sure Connection is set to the Connection Name you defined earlier > OK

Task 7: Test Your Setup

Right click LabSolutions > Rebuild > Make sure you get Compilation complete: 0 errors
Right click Tutorial > Rebuild > Make sure you get Compilation complete: 0 errors

Right click LabSolutions > Run
This should open this page in the browser: http://mkmoreno-au.au.oracle.com:8988/OA_HTML/test_fwklabsolutions.jsp
Right click Tutorial > Run
This should open this page in the browser: http://mkmoreno-au.au.oracle.com:8988/OA_HTML/test_fwktutorial.jsp