OA Framework Personalization and extensions

 

An OA Framework requirement in Oracle Applications comes in 3 ways:

· Personalization of OA Framework pages

· Customization via personalization of OA Framework pages

· Development of new OAF Page and integrate with the application First we need to identify whether the requirement is personalization/customization/ new development.

Pre-Requisites:

· Access to following responsibilities:

· Functional Administrator

· System Administrator

· OA Framework Toolbox Tutorial

· OA Framework Toolbox Tutorial Labs

· <Any other responsibility> on which OAF pages needs to be deployed.

· Database access to Apps schema

· Access to custom_top/java_top of UNIX box with 777 privilege to deploy the new applications

ex: (/u01/app/visappl/fnd/11.5.0/)

· Get .dbc file from UNIX box (application server) from '$FND_TOP\secure\' folder

· Following profiles options to be set at user level

o Personalize Self-Service Defn Yes (To get Personalize link for OAF Pages)

o FND: Diagnostics Yes (To get 'About This Page' link to get page details)

· Get the responsibility key and application short name for the responsibility to which you are developing OAF page using following query and make sure that responsibility is added to the Application front end user.

o SELECT r.responsibility_key,fa.APPLICATION_SHORT_NAME

FROM

fnd_responsibility r,

fnd_application fa

WHERE

fa.APPLICATION_ID = r.APPLICATION_ID

JDeveloper Setup for OA Framework:

· Find the correct version of JDeveloper to use with eBusiness Suite 11i or Release 12.x [ID 416708.1]

· Extract the JDeveloper into your local machine ex: <<Drive:\JDeveloper\jdevhome\jdev>>

· Setup JDev user home environment variable:

· Copy the path of <<Drive:\JDeveloper\jdevhome\jdev>>

· Right click My Computer --> Properties --> Advanced Tab --> Click on 'Environment Variables' button at the bottom

o In the user variables section, click on new button, input following details:

o Variable Name: JDEV_USER_HOME

o Variable Value: Paste the path of <<Drive:\JDeveloper\jdevhome\jdev>>

o Click on Ok, Ok, Ok.

o Above steps are for the Jdeveloper9i and for some 10g versions.

o For latest 10g and 11g JDeveloper versions, you can map the JDev user home to your own folder/path so that your source code can be isolated from Jdeveloper setup.

· Place the .dbc file extracted from UNIX box into     <<Drive:\JDeveloper\jdevhome\jdev\dbc_files\secure>>

· Create a shortcut on desktop for jdevw.exe from the folder <<Drive:\JDeveloper\jdevbin\jdev\bin\>>

· Run the JDeveloper by clicking on jdevw.exe shortcut on the desktop.

o In JDeveloper Click on File--> Open Open the file

<<Drive:\JDeveloper\jdevhome\jdev\myprojects\>>toolbox.jws

o Right click the Tutorial.jpr and set its project settings as follows:

o Under Common--> Oracle Applications --> Runtime Connection

o Select the .dbc file using browse button from the path

<<Drive:\JDeveloper\jdevhome\jdev\dbc_files\secure>>

o Input application front end username/password

o Input application short name and responsibility key

o Make sure that respective responsibility is added to the Application front end user

o And then OK

o Rebuild the Tutorial.jpx and Run test_fwktutorial.jsp

· If the page runs without error, the JDeveloper setup is configured

correctly. Make sure other links are also working fine from test_fwktutorial.jsp file