Oracle Application Framework

Here are current jdeveloper patch:

1.    Patch 4045639 - 9IJDEVELOPER WITH OA EXTENSION ARU FOR FWK.H

2.    Patch 4141787 - 9IJDEVELOPER WITH OA EXTENSION ARU FOR CU1

3.    Patch 4573517 - Oracle9i JDeveloper with OA Extension for 11.5.10 CU2

4.    Patch 4725670 - 9IJDEVELOPER WITH OA EXTENSION ARU FOR 11i10 RUP3

To determine which patch to use, you can simply check the framework version in your instance by using http://host:port/OA_HTML/OAInfo.jsp, then choose the matched one. If the version is 11.5.10K, please use patch 4045639, 11.5.101CU, then use patch 4141787, 11.5.102CU, then it should be patch 4573517, 11.5.103CU should be patch 4725670.

Setup jdeveloper

Use setting up jdeveloer on Windows as example:

Task 1: Configuring the JDEV_USER_HOME Environment Variable

Warning: This is a requirement for JDeveloper. Do not skip this task.

Configure the JDEV_USER_HOME environment variable using Windows XP or Windows 2000:

1.    Go to your desktop and select My Computer, right-click and select Properties.

2.    On the System Properties dialog, select the Advanced tab.

3.    On the Advanced page, select the Environment Variables... button.

4.    On the Environment Variables dialog, select the New... button from the User variables for <username> box.

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

6.    Select OK in each of the dialogs you opened to save the new user environment variable.

Warning: The variable value should not contain a leading space before the drive name. If it does, your environment will not work properly.

Task 2: Obtaining a Database Connection File

Obtain the FND database connection (.dbc) file from the system administrator who installed the OA Framework database where you want to do your development. Place this file in the <JDEV_USER_HOME>\dbc_files\secure directory.

Task 3: Creating a Desktop Shortcut to JDeveloper

To facilitate launching JDeveloper, create a desktop shortcut to jdevbin\jdev\bin\jdevw.exe.

Task 4: Assigning ToolBox Responsibilities

If you have not already done so as part of your installation verification, assign the following ToolBox Tutorial responsibilities to a test user. Refer to the Oracle Applications System Administrators Guide for information about creating users and assigning responsibilities to users.

Note: Use an existing user in your system or create a new test user.

1.    OA Framework ToolBox Tutorial (responsibility key is FWK_TBX_TUTORIAL).

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

Task 5: Launching JDeveloper and Configuring the Database Connection and User

Use this procedure to launch JDeveloper and configure the database connection and user:

1.    Select the desktop shortcut created in Task 3 to launch Oracle9i JDeveloper.

2.    Select File > Open from the main menu, then navigate to <JDEV_USER_HOME>\myprojects. Open the OA Framework ToolBox Tutorial workspace file (toolbox.jws).

3.    Expand the toolbox.jws in the JDeveloper System Navigator, to display its contents . Select the Tutorial.jpr project, then select Project > Project Settings.

4.    Expand the Oracle Applications node, which is In the Project Settings dialog, and select Runtime Connection.

5.    Locate the DBC file that you saved in Task 2 by using the Browse... button, which is In the Connection box. The file should be in the <JDEV_USER_HOME>\dbc_files\secure directory.

6.    Specify the User Name and Password for the test user. This is the user that you assigned the ToolBox responsibilities to in Task 4. Select OK.

7.    Select Tutorial.jpx in the System - Navigator pane, then select Edit Tutorial from the context menu. Verify that the Connection Name is set correctly. Select Apply, then OK.

8.    Repeat Steps 3 - 7 for the LabSolutions.jpr project.

9.    Expand the Connections node in the JDeveloper System Navigator 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.

10.  Select the Tutorial.jpr project In the System Navigator. Right-click and select Edit Business Components Project....

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

12.  Repeat steps 9 - 11 for the LabSolutions.jpr project.

Task 6: Test your Setup

Perform the following steps to test your setup:

Tip: Use Internet Explorer 5.0+ as your default browser if you want pages to look as they do in the OA Framework ToolBox Tutorial / Sample Library.

1.    Open the toolbox.jws workspace in the JDeveloper Navigator using the instructions in Task 5 above.

2.    Go to the System Navigator, select toolbox.jws and then select Project > Rebuild toolbox.jws from the main menu. You should get 0 errors (warnings are okay and expected).

3.    Go to the System Navigator, expand the Tutorial.jpr project again, then select Project > Show Categories from the main menu.
Note: this helps to organize the files in a large project.

4.    Expand the HTML Sources category beneath Tutorial.jpr. Select test_fwktutorial.jsp, then select Run > Run test_fwktutorial.jsp from the main menu. Perform the following:

      Select Hello, World! from the list of lesson links displayed on the Test Framework ToolBox Tutorial page. This runs a very simple page.

Note: If you can't run the Hello, World! page, revisit the steps listed above to ensure that you completed everything correctly. If the problem persists, follow the support procedure described in the Release Notes accompanying this ARU.

Check Point

1.    Check JDEV_USER_HOME

2.    Runtime Connection

·         Click the project which you want to run,
Project -> Project Settings -> Runtime Connection
DBC file name –  <JDEV_USER_HOME>\dbc_files\secure\~.dbc
User Name / Password – a valid apps user who has FWK_TBX_TUTORIAL responsibility
Application Short Name – default is AK
Responsibility Key – FWK_TBX_TUTORIAL

Known Issue

1. No Suitable Driver

Symptom:

oracle.apps.fnd.framework.OAException: Application: FND, Message Name: SYSTEM-ERROR. Tokens: MESSAGE = No suitable driver;  (Could not lookup message because there is no database connection)

Fix:

1.    Make sure it is middle tier dbc file not database tier, the file is under $FND_TOP/secure

2.    Turn AUTHENTICATION to OFF using following command:
 %<mount point>/util/java/1.4/j2sdk1.4.2_04/jre/bin/java \
> oracle.apps.fnd.security.AdminAppServer apps/apps AUTHENTICATION OFF \
> DBC=$FND_TOP/secure/<dbc file>

3.    Comment out entry APPS_JDBC_URL from dbc file under Jdeveloper directory.

2. Io exception: Got minus one from a read call

Symptom:

Exception Details. 
oracle.apps.fnd.framework.OAException: Application: FND, Message Name: SYSTEM-ERROR. Tokens: MESSAGE = Io exception: Got minus one from a read call; (Could not lookup message because there is no database connection)
at oracle.apps.fnd.framework.OACommonUtils.processAOLJErrorStack(OACommonUtils.java:884)
at oracle.apps.fnd.framework.server.OAUtility.getWebAppsContext(OAUtility.java:347)
at oracle.apps.fnd.framework.CreateIcxSession.getEncryptedSessId(CreateIcxSession.java:144)
at oracle.apps.fnd.framework.CreateIcxSession.createSession

Fix:

Refer note 294685.1 - Unable to connect  jdeveloper to 11.5.10 instance

3. OC4J setting in jdeveloper doesn't match the local PC setting

This issue can have 2 different symptoms:

Symptom 1:

After running the test_fwktutorial.jsp, the first page shows properly with all the page links.
But when click any link here, it throws error as:
java.lang.NullPointerException
at oracle.apps.fnd.common.WebRequestUtil.getCookieValue(WebRequestUtil.java:130)
at oracle.apps.fnd.common.WebRequestUtil.getSessionCookie(WebRequestUtil.java:622)
at oracle.apps.fnd.framework.webui.OAJSPHelper.getIcxCookie(OAJSPHelper.java:274)
at oracle.apps.fnd.framework.webui.OAJSPHelper.getIcxCookie(OAJSPHelper.java:239)
at oracle.apps.fnd.framework.webui.OAServerDelegate.getIcxSessionContext(OAServerDelegate.java:423)
at oracle.apps.fnd.framework.webui.OAJSPHelper.handleErrorStackDisplay(OAJSPHelper.java:1306)
at _OAErrorPage._jspService(OAErrorPage.jsp:68)
at com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:56)
at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:317)
at oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:465)
at oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:379)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:727)
at com.evermind.server.http.ServletRequestDispatcher.include(ServletRequestDispatcher.java:119)
at com.evermind.server.http.EvermindPageContext.handlePageThrowable(EvermindPageContext.java:547)
at com.evermind.server.http.EvermindPageContext.handlePageException(EvermindPageContext.java:518)
at _OA._jspService(OA.jsp:35)
at com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:56)
at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:317)
at oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:465)
at oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:379)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:727)
at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:306)
at com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:767)
at com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:259)
at com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:106)
at EDU.oswego.cs.dl.util.concurrent.PooledExecutor$Worker.run(PooledExecutor.java:803)
at java.lang.Thread.run(Thread.java:534)

Symptom 2:

·         Clicking Hello World link after running test_fwktutorial.jsp to bring 'HelloWorld page'

·         Enter any value in Input field and click Go button

      Then the page continuously being refreshed but the Page Does Not Display.

·         Information

·         Information - Hello, red_value>!

·         No error message.

Fix:

·         Change the OC4J setting in Jdev:
Go to Tools -> Preferences -> Embedded OC4J -> Host Name or IP Address Used to Refer to Embedded OC4J
Check either Default Local IP Address (Recommended) or Local Host's Full Name depends on your local PC setting

4. java.sql.SQLException: Io exception: The Network Adapter could not establish the connection

Symptom:

oracle.apps.fnd.framework.OAException: Application: FND, Message Name: FND_GENERIC_MESSAGE. Tokens: MESSAGE = java.sql.SQLException: Io exception: The Network Adapter could not establish the connection;  (Could not lookup message because there is no database connection)

at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:888)
at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:862)
at oracle.apps.fnd.framework.server.OAExceptionUtils.processAOLJErrorStack(OAExceptionUtils.java:980)
at oracle.apps.fnd.framework.server.OAUtility.getWebAppsContext(OAUtility.java:352)
at oracle.apps.fnd.framework.CreateIcxSession.getEncryptedSessId(CreateIcxSession.java:144)
at oracle.apps.fnd.framework.CreateIcxSession.createSession(CreateIcxSession.java:80)
at _test__fwktutorial._jspService(test_fwktutorial.jsp:45)
at oracle.jsp.runtime.HttpJsp.service(HttpJsp.java:139)
at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:317)
at oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:465)
at oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:379)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:727)
at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:306)
at com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:767)
at com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:259)
at com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:106)
at EDU.oswego.cs.dl.util.concurrent.PooledExecutor$Worker.run(PooledExecutor.java:803)
at java.lang.Thread.run(Thread.java:534)

It could be 2 reasons:

Cause 1: database is down

·         To verify, you can do following steps:

·         If the connected database is not defined, please follow Task 5 9) above to setup the database.

If the connected database is already defined under Connections -> Database in jdeveloper, right-click that database and choose Edit, click Test tab in launched Connection Wizard, click the Test Connection button, if you see the error about Network Adapter could not establish connection, then something is wrong with database. If it shows Success, then this is not the reason causes the problem.

Fix:

·           Bounce the database     

Cause 2: dbc file is not correct      

Fix:

1.    Check the dbc file and make sure it is middle tier one which is under $FND_TOP/secure

2.    In jdeveloper, the file should be at <JDEV_USER_HOME>\dbc_files\secure

3.    Comment out entry APPS_JDBC_URL in dbc file.

5. Could not find the specified responsibility

Symtoms

oracle.apps.fnd.framework.OAException: Application: ICX, Message Name: Could not find the specified

responsibility. 
 (Could not lookup message because there is no database connection)
 at oracle.apps.fnd.framework.CreateIcxSession.getEncryptedSessId(CreateIcxSession.java:158)
      

at oracle.apps.fnd.framework.CreateIcxSession.createSession(CreateIcxSession.java:80)
       at _test__fwktutorial._jspService(test_fwktutorial.jsp:46)
      

at oracle.jsp.runtime.HttpJsp.service(HttpJsp.java:139)
       at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:317)
      

at oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:465)
       at oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:379)
      

at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
       at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:727)
      

at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:306)
      

at com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:767)
       at

com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:259)
       at com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:106)
      

at EDU.oswego.cs.dl.util.concurrent.PooledExecutor$Worker.run(PooledExecutor.java:797)
       at java.lang.Thread.run(Thread.java:534)

Fix:

1.    Run the following query to check how many Application Short Name of FWK_TBX_TUTORIAL in your instance:
select resp.application_id, appl.application_short_name
from fnd_responsibility resp, fnd_application appl
where resp.application_id=appl.application_id
and resp.responsibility_key='FWK_TBX_TUTORIAL';

2.    If you have ICX returned in above query, change to ICX in Application Short Name (Project -> Project Settings -> Runtime Connection)

Default is AK, but this is not always the correct value. If you have ICX returned in above query, change to ICX in Application Short Name (Project -> Project Settings -> Runtime Connection)

Tips

1) Each time, after you make any changes, please rebuild project, clear browser cache, then rerun the project.

2) Before you run any project, terminate the previous running process if there is any. Run -> Terminate ->Embedded OC4J server 

Anil Passi

Add comment