OA Framework 学习求助

realakuma

呵呵，希望有大侠能够讲一讲如何对已经存在的VO进行修改。如果用jdeveloper来完成这件事情呢？希望有个详细的教程。

Harry_shan

我也正在寻找这方面的资料，有什么可以共享的资料提供出来？

Harry_shan

我现在运行test_fwktutorial.jsp，出现如下错误：
  
  
   


   
Error Page  

   
You have encountered an unexpected error. Please contact the System Administrator for assistance.  
Click here for exception details.

Harry_shan

详细资料如下：

Error Page  

   
Exception Details.  
   
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)
        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(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:797)
        at java.lang.Thread.run(Thread.java:534)
## Detail 0 ##
oracle.apps.fnd.framework.OAException: Application: FND, Message Name: FND_GENERIC_MESSAGE. Tokens: MESSAGE = java.sql.SQLException: No suitable driver;  (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.OACommonUtils.processAOLJErrorStack(OACommonUtils.java:876)
        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(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:797)
        at java.lang.Thread.run(Thread.java:534)
## Detail 0 ##
java.sql.SQLException: No suitable driver
        at java.sql.DriverManager.getConnection(DriverManager.java:532)
        at java.sql.DriverManager.getConnection(DriverManager.java:140)
        at oracle.apps.fnd.security.ConnectionManager.dbConnect(ConnectionManager.java:753)
        at oracle.apps.fnd.security.ConnectionManager.dbConnect(ConnectionManager.java:704)
        at oracle.apps.fnd.security.AppsConnectionManager.makeGwyuidConn(AppsConnectionManager.java:609)
        at oracle.apps.fnd.security.AppsConnectionManager.getGwyuidConn(AppsConnectionManager.java:681)
        at oracle.apps.fnd.security.AppsConnectionManager.makeGuestConnection(AppsConnectionManager.java:552)
        at oracle.apps.fnd.security.DBConnObj.<init>(DBConnObj.java:206)
        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
        at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
        at java.lang.reflect.Constructor.newInstance(Constructor.java:274)
        at oracle.apps.fnd.common.Pool.createObject(Pool.java:1187)
        at oracle.apps.fnd.common.Pool.borrowObject(Pool.java:946)
        at oracle.apps.fnd.security.DBConnObjPool.borrowObject(DBConnObjPool.java:661)
        at oracle.apps.fnd.security.AppsConnectionManager.borrowConnection(AppsConnectionManager.java:211)
        at oracle.apps.fnd.common.Context.borrowConnection(Context.java:1671)
        at oracle.apps.fnd.common.AppsContext.getPrivateConnectionFinal(AppsContext.java:2363)
        at oracle.apps.fnd.common.AppsContext.getPrivateConnection(AppsContext.java:2301)
        at oracle.apps.fnd.common.AppsContext.getJDBCConnection(AppsContext.java:2172)
        at oracle.apps.fnd.common.AppsContext.getJDBCConnection(AppsContext.java:1986)
        at oracle.apps.fnd.common.AppsContext.getJDBCConnection(AppsContext.java:1890)
        at oracle.apps.fnd.profiles.Profiles.getConnection(Profiles.java:1482)
        at oracle.apps.fnd.profiles.Profiles.getProfileOption(Profiles.java:996)
        at oracle.apps.fnd.profiles.Profiles.getProfile(Profiles.java:360)
        at oracle.apps.fnd.profiles.ExtendedProfileStore.getSpecificProfileFromDB(ExtendedProfileStore.java:225)
        at oracle.apps.fnd.profiles.ExtendedProfileStore.getSpecificProfile(ExtendedProfileStore.java:184)
        at oracle.apps.fnd.profiles.ExtendedProfileStore.getProfile(ExtendedProfileStore.java:147)
        at oracle.apps.fnd.common.logging.DebugEventManager.configureUsingDatabaseValues(DebugEventManager.java:1107)
        at oracle.apps.fnd.common.logging.DebugEventManager.configureLogging(DebugEventManager.java:971)
        at oracle.apps.fnd.common.logging.DebugEventManager.reInitialize(DebugEventManager.java:940)
        at oracle.apps.fnd.common.logging.DebugEventManager.reInitialize(DebugEventManager.java:907)
        at oracle.apps.fnd.common.AppsLog.reInitialize(AppsLog.java:570)
        at oracle.apps.fnd.common.AppsContext.initLog(AppsContext.java:1025)
        at oracle.apps.fnd.common.WebAppsContext.init(WebAppsContext.java:3486)
        at oracle.apps.fnd.common.WebAppsContext.<init>(WebAppsContext.java:537)
        at oracle.apps.fnd.framework.server.OAUtility.getWebAppsContext(OAUtility.java:346)
        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:797)
        at java.lang.Thread.run(Thread.java:534)
oracle.apps.fnd.framework.OAException: Application: FND, Message Name: FND_GENERIC_MESSAGE. Tokens: MESSAGE = java.sql.SQLException: No suitable driver;  (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.OACommonUtils.processAOLJErrorStack(OACommonUtils.java:876)
        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(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:797)
        at java.lang.Thread.run(Thread.java:534)
## Detail 0 ##
java.sql.SQLException: No suitable driver
        at java.sql.DriverManager.getConnection(DriverManager.java:532)
        at java.sql.DriverManager.getConnection(DriverManager.java:140)
        at oracle.apps.fnd.security.ConnectionManager.dbConnect(ConnectionManager.java:753)
        at oracle.apps.fnd.security.ConnectionManager.dbConnect(ConnectionManager.java:704)
        at oracle.apps.fnd.security.AppsConnectionManager.makeGwyuidConn(AppsConnectionManager.java:609)
        at oracle.apps.fnd.security.AppsConnectionManager.getGwyuidConn(AppsConnectionManager.java:681)
        at oracle.apps.fnd.security.AppsConnectionManager.makeGuestConnection(AppsConnectionManager.java:552)
        at oracle.apps.fnd.security.DBConnObj.<init>(DBConnObj.java:206)
        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
        at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
        at java.lang.reflect.Constructor.newInstance(Constructor.java:274)
        at oracle.apps.fnd.common.Pool.createObject(Pool.java:1187)
        at oracle.apps.fnd.common.Pool.borrowObject(Pool.java:946)
        at oracle.apps.fnd.security.DBConnObjPool.borrowObject(DBConnObjPool.java:661)
        at oracle.apps.fnd.security.AppsConnectionManager.borrowConnection(AppsConnectionManager.java:211)
        at oracle.apps.fnd.common.Context.borrowConnection(Context.java:1671)
        at oracle.apps.fnd.common.AppsContext.getPrivateConnectionFinal(AppsContext.java:2363)
        at oracle.apps.fnd.common.AppsContext.getPrivateConnection(AppsContext.java:2301)
        at oracle.apps.fnd.common.AppsContext.getJDBCConnection(AppsContext.java:2172)
        at oracle.apps.fnd.common.AppsContext.getJDBCConnection(AppsContext.java:1986)
        at oracle.apps.fnd.common.AppsContext.getJDBCConnection(AppsContext.java:1890)
        at oracle.apps.fnd.profiles.Profiles.getConnection(Profiles.java:1482)
        at oracle.apps.fnd.profiles.Profiles.getProfileOption(Profiles.java:996)
        at oracle.apps.fnd.profiles.Profiles.getProfile(Profiles.java:360)
        at oracle.apps.fnd.profiles.ExtendedProfileStore.getSpecificProfileFromDB(ExtendedProfileStore.java:225)
        at oracle.apps.fnd.profiles.ExtendedProfileStore.getSpecificProfile(ExtendedProfileStore.java:184)
        at oracle.apps.fnd.profiles.ExtendedProfileStore.getProfile(ExtendedProfileStore.java:147)
        at oracle.apps.fnd.common.logging.DebugEventManager.configureUsingDatabaseValues(DebugEventManager.java:1107)
        at oracle.apps.fnd.common.logging.DebugEventManager.configureLogging(DebugEventManager.java:971)
        at oracle.apps.fnd.common.logging.DebugEventManager.reInitialize(DebugEventManager.java:940)
        at oracle.apps.fnd.common.logging.DebugEventManager.reInitialize(DebugEventManager.java:907)
        at oracle.apps.fnd.common.AppsLog.reInitialize(AppsLog.java:570)
        at oracle.apps.fnd.common.AppsContext.initLog(AppsContext.java:1025)
        at oracle.apps.fnd.common.WebAppsContext.init(WebAppsContext.java:3486)
        at oracle.apps.fnd.common.WebAppsContext.<init>(WebAppsContext.java:537)
        at oracle.apps.fnd.framework.server.OAUtility.getWebAppsContext(OAUtility.java:346)
        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:797)
        at java.lang.Thread.run(Thread.java:534)


有哪位知道这可能是什么原因造成的？

Harry_shan

最初由 chinchine 发布
[B]我简单的说一下如何配置一个OAF开发环境，希望对大家有些用户有些帮助。
1。首先需要一个从Metalink上下载一个Jdevelop with OAExtension的压缩包（需要Oracle Applications许可帐号）。
2。假设把JdevOAExtension11.5.10解压到d:\JdevOAExtension11.5.10，在这个文件夹下会有三个文件夹，分别为：
    jdevbin 为Oracle Jdeveloper903的IDE
       jdevdoc为文档目录
    jdevhome为OAF的开发根目录
开发环境的配置文档应该位于jdevdoc\devguide\gs\gs_setup.htm，这个文档说的是比较详细的。我把主要的步骤说一下，具体请大家参考gs_setup.htm文档。
3。设置JDEV_USER_HOME环境变量，设置JDEV_USER_HOME=d:\JdevOAExtension11.5.10\jdevhome\jdev
4。从Oracle Applications安装节点上下载dbc文件，具体位置应该类似在$APPL_TOP/fnd/secure/prod的位置（记不清了）。把这个dbc文件拷贝到$JDEV_USER_HOME\dbc_files\secure
5.启动Jdevelop IDE，配置IDE的运行参数，请参考gs_setup.htm。
6。完成以上这些步骤之后就应该可以运行例子中的程序了。
注意：在有些环境中运行例子中的程序会报No Suitable Driver的错误信息，这个错误可以修改dbc文件就可以绕过这个错误。具体做法是注释掉dbc文件中的APPS_JDBC_URL项就可以了。

祝大家配置顺利。 [/B]

去掉APPS_JDBC_URL后通过了，继续学习下去

Harry_shan

有没有开发一个新的WEB查询的例子？用OAF开发的。

Harry_shan

最初由 chinchine 发布
[B]我最近倒是做了不少的OAF的开发。大家有什么问题，可以把具体的问题提出来，最好同时给我发邮件。我没有太多的时间上论坛。不过很愿意与大家一起研究OAF。
OAF总体来说是一个非常不错的应用框架，Oracle会把下一代的ERP程序都迁移到OAF框架上。
我的邮件：chinchine@hotmail.com [/B]

有没有这方面的简单例子，可以提供给我们？

Harry_shan

chinchine，开发出来的程序怎么挂到ORACLE ERP中呢？

realakuma

我正在整理一些东西。等最近这个工作完成后就发到论坛上来，大家一起学习。

Harry_shan

最初由 realakuma 发布
[B]我正在整理一些东西。等最近这个工作完成后就发到论坛上来，大家一起学习。 [/B]

什么时候可以传上来啊，现在急着要