ITPub博客

首页 > 数据库 > Oracle > OAF错误

OAF错误

Oracle 作者:774256182 时间:2014-04-03 09:16:36 0 删除 编辑

OAF错误

oracle.apps.fnd.framework.OAException: Application: FND, Message Name: FND_NO_REGION_DATA. Tokens: REGIONCODE = /oracle/apps/ak/employee/server/webui /EmpSearchPG; 

 

后面发现自己把myproject的文件上传到服务器了,应该把myclass的文件上传的。

Project的目录结构

在我们做FORMSREPORTS,只需要把相应的FMX文件及RDF文件放入$XXX_TOP/forms/ZHS(US)$XXX_TOP/reports/ZHS(US)即可

简单明了.OAF的项目所包含的文件种类较多,其所对应的目录也就较复杂,一不小心,真的容易搞错,而一旦搞错,很可能布署时就会出错

 

安装Jdev,有这样一个目录:

Jdevhome\Jdev(我的电脑上是C:\OAF\jdevhome\jdev)

还记得那个环境变量的设置吗,这个目录就是我们开发的工作目录了.下面介绍里面的目录结构:

 

Dbc_files:里面有个secure目录,还记得我们需要从服务器Download一个dbc文件放在里面用来做为DB联接用的吗?

Myclasses:编译文件目录,对应Myprojects,在进行项目的编译后,会生成相应的子目录

Myhtml: 当你联接EBS,会从服务器上自动Download一些图片做为开发素材放在这里面,你在开发时可以引用

Myprojects:项目文件夹.最重要的一个目录,我们所建的项目中的所有文件均应放在些目录中.

 

在我们进行OAF开发时,建立的一些对象都需要定义路径,以便项目运行时可通过这个路径找到相应的CLASS文件及XML文件.这些路径的定义是有一定的规范的,一般情况下:

 

建立Workspace:  Myprojects/Mycompany根目录

建立Projects:       Myprojects/Mycompany根目录

 

而在建立Projects里面的一些对象时,它们的路径就比较讲究了….

 

在联机帮助中,有如下的一张图:


 

这张图上有几个重要的路径是我们开发中常用的.转换成OAF标准路径后是这样的:

 

Oracle.apps...webui

Used for : Page and Controller

 

Oracle.apps...server

Used for : AM and VO and VL

 

Oracle.apps...schema.server

Used for : EO and AO

 

Oracle.apps..lov.server

Used for : AM and VO for LOV

 

Oracle.apps..lov.webui

Used for : Page and Controller for LOV

 

Oracle.apps..poplist.server

Used for : AM and VO for POPLIST

 

 

从这些路径我们可以得出如下几点:

  1. Oracle.apps.Oracle标准,所有的Project都必须用这样的路径来定义对象.
  2. Component name往往是我们所建的Project的名字,比如我做一个客户管理的应用,可定义名称为"ManageCust”
  3. webui一般放Clint端的东西server一般放server端的东西.
  4. LOVPOPLIST是可以共享给多个Projects.所以目录层次与Component name一致.
  5. Oracle.apps前是可以加入个性化的上层目录的,比如用公司名称用来代替那个MyCompany…

 

 

举个例子:

假设我公司的名字叫Abeam,

Jdev home path"C:\OAF\jdevhome\jdev”,

我新建一个Project ,功能是进行客户管理,名字为"ManageCust”

应用为ICX(这里的应用所发挥的作用还有待研究)

 

则你的目录结构会是如下:

myprojects

|____abeam

         |__oracle

              |__ apps

                    |__icx

                         |__managecust

                         |    |___webui

                         |    |___server

                         |    |___schema

                         |           |___server

                         |__lov

                         |    |__webui

                         |    |__server

                         |__poplist

                              |__server


 

不基于EO的数据处理

主要功能:

手工建立PAGE及上面的ITEM,所有ITEM均为普通的ITEM,VOATTRIBUTE.然后在ITEM中输入信息,并保存到表中.

主要使用的包及方法:

Import oracle.apps.fnd.framework.OAApplicationModule;

  1. 方法

getTransaction().executeCommand(“string”)

作用:提交SQL语句,可为任意

getTransaction().commit()

作用:执行COMMIT动作.

pageContext.getparameter()

作用:获取ITEM中的值

pageContext.getuserid()

作用:获取USER ID,做为WHO信息

pageContext.getCurrentDBDate()

作用:获取当前时间,做为WHO信息

代码流程:

ROOT REGION中建立CODE:

  

  1. 捕获按钮是否被点击

语句:

if (pageContext.getParameter("Save") != null)

  1. 实例化AM,因无EO,我没建AM,用的是ORACLE默认的那个AM.

语句:

OAApplicationModule am = pageContext.getApplicationModule(webBean);

  1. 组合SQL语句:

String sqlstr = “ insert into….”

注意:时间型的东东可能要先获取字符串,然后加上TO_DATETIME转换

  1. 提交SQL语句:

am.getTransaction().executeCommand(sqlstr);

  1. 执行COMMIT:

am.getTransaction().commit();

  1. 返回信息:

pageContext.putDialogMessage(new OAException("Save successfully!",OAException.INFORMATION));


OAF jar包引用产生错误

HSSFCell not found.

右键OAProject->属性->libraries->添加poi的jar包

Error Page

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

 




Error Page

Exception Details. oracle.apps.fnd.framework.OAException: oracle.jbo.InvalidDefNameException: JBO-25004: ??? ?? ???? ?? at oracle.apps.fnd.framework.webui.OAPageErrorHandler.prepareException(Unknown Source) at oracle.apps.fnd.framework.webui.OAPageBean.renderDocument(Unknown Source) at oracle.apps.fnd.framework.webui.OAPageBean.renderDocument(Unknown Source) at _OA._jspService(_OA.java:87) at com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:59) at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:462) at oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:594) at oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:518) at javax.servlet.http.HttpServlet.service(HttpServlet.java:856) at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:713) at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:370) at com.evermind.server.http.ServletRequestDispatcher.unprivileged_forward(ServletRequestDispatcher.java:259) at com.evermind.server.http.ServletRequestDispatcher.access$100(ServletRequestDispatcher.java:51) at com.evermind.server.http.ServletRequestDispatcher$2.oc4jRun(ServletRequestDispatcher.java:193) at oracle.oc4j.security.OC4JSecurity.doPrivileged(OC4JSecurity.java:283) at com.evermind.server.http.ServletRequestDispatcher.forward(ServletRequestDispatcher.java:198) at com.evermind.server.http.EvermindPageContext.forward(EvermindPageContext.java:392) at _OA._jspService(_OA.java:80) at com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:59) at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:462) at oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:594) at oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:518) at javax.servlet.http.HttpServlet.service(HttpServlet.java:856) at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:713) at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:370) at com.evermind.server.http.HttpRequestHandler.doProcessRequest(HttpRequestHandler.java:871) at com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:453) at com.evermind.server.http.HttpRequestHandler.serveOneRequest(HttpRequestHandler.java:221) at com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:122) at com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:111) at oracle.oc4j.network.ServerSocketReadHandler$SafeRunnable.run(ServerSocketReadHandler.java:260) at com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:303) at java.lang.Thread.run(Thread.java:595) ## Detail 0 ## oracle.apps.fnd.framework.OAException: oracle.jbo.InvalidDefNameException: JBO-25004: ??? ?? ???? ?? at oracle.apps.fnd.framework.OAException.wrapperException(Unknown Source) at oracle.apps.fnd.framework.webui.OAPageErrorHandler.prepareException(Unknown Source) at oracle.apps.fnd.framework.webui.OAPageBean.renderDocument(Unknown Source) at oracle.apps.fnd.framework.webui.OAPageBean.renderDocument(Unknown Source) at _OA._jspService(_OA.java:87) at com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:59) at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:462) at oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:594) at oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:518) at javax.servlet.http.HttpServlet.service(HttpServlet.java:856) at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:713) at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:370) at com.evermind.server.http.ServletRequestDispatcher.unprivileged_forward(ServletRequestDispatcher.java:259) at com.evermind.server.http.ServletRequestDispatcher.access$100(ServletRequestDispatcher.java:51) at com.evermind.server.http.ServletRequestDispatcher$2.oc4jRun(ServletRequestDispatcher.java:193) at oracle.oc4j.security.OC4JSecurity.doPrivileged(OC4JSecurity.java:283) at com.evermind.server.http.ServletRequestDispatcher.forward(ServletRequestDispatcher.java:198) at com.evermind.server.http.EvermindPageContext.forward(EvermindPageContext.java:392) at _OA._jspService(_OA.java:80) at com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:59) at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:462) at oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:594) at oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:518) at javax.servlet.http.HttpServlet.service(HttpServlet.java:856) at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:713) at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:370) at com.evermind.server.http.HttpRequestHandler.doProcessRequest(HttpRequestHandler.java:871) at com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:453) at com.evermind.server.http.HttpRequestHandler.serveOneRequest(HttpRequestHandler.java:221) at com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:122) at com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:111) at oracle.oc4j.network.ServerSocketReadHandler$SafeRunnable.run(ServerSocketReadHandler.java:260) at com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:303) at java.lang.Thread.run(Thread.java:595) oracle.apps.fnd.framework.OAException: oracle.jbo.InvalidDefNameException: JBO-25004: ??? ?? ???? ?? at oracle.apps.fnd.framework.OAException.wrapperException(Unknown Source) at oracle.apps.fnd.framework.webui.OAPageErrorHandler.prepareException(Unknown Source) at oracle.apps.fnd.framework.webui.OAPageBean.renderDocument(Unknown Source) at oracle.apps.fnd.framework.webui.OAPageBean.renderDocument(Unknown Source) at _OA._jspService(_OA.java:87) at com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:59) at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:462) at oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:594) at oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:518) at javax.servlet.http.HttpServlet.service(HttpServlet.java:856) at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:713) at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:370) at com.evermind.server.http.ServletRequestDispatcher.unprivileged_forward(ServletRequestDispatcher.java:259) at com.evermind.server.http.ServletRequestDispatcher.access$100(ServletRequestDispatcher.java:51) at com.evermind.server.http.ServletRequestDispatcher$2.oc4jRun(ServletRequestDispatcher.java:193) at oracle.oc4j.security.OC4JSecurity.doPrivileged(OC4JSecurity.java:283) at com.evermind.server.http.ServletRequestDispatcher.forward(ServletRequestDispatcher.java:198) at com.evermind.server.http.EvermindPageContext.forward(EvermindPageContext.java:392) at _OA._jspService(_OA.java:80) at com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:59) at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:462) at oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:594) at oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:518) at javax.servlet.http.HttpServlet.service(HttpServlet.java:856) at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:713) at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:370) at com.evermind.server.http.HttpRequestHandler.doProcessRequest(HttpRequestHandler.java:871) at com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:453) at com.evermind.server.http.HttpRequestHandler.serveOneRequest(HttpRequestHandler.java:221) at com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:122) at com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:111) at oracle.oc4j.network.ServerSocketReadHandler$SafeRunnable.run(ServerSocketReadHandler.java:260) at com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:303) at java.lang.Thread.run(Thread.java:595)


原因:item属性设置错误。

messagelovchoice ->messagelovinput

对OAF开发中的MDS的初步研究(转)

近日总有人问我什么是MDS,说实话,我也没怎么仔细关心过,只知道叫“元数据仓库”(Meta. Data Services),今天抽了点时间研究了一把,有了点研究成果,贴上来共享一下,^_^。

首先,我的切入点是研究了一下导入的那个命令,我在的Windows操作系统下执行的bat文件是在D:\p6509325_R12_GENERIC\jdevbin\oaext\bin这个目录下,找到export.bat、import.bat、jpximport.bat、xliffimport.bat,其他的几个今天没顾上看,以后有时间再研究了。

研究了一下import.bat,前面是一堆的验证,最终有用的就是java oracle.jrad.tools.xml.importer.XMLImporter %PARAMS%这一句了。

懒得在本地找了,直接登录到应用环境,然后cd $JAVA_TOP/oracle,把jrad子目录中的所有类都打成tar包下载了下来,用JDecompiler打开

oracle.jrad.tools.xml.importer.XMLImporter.class

看,经过一番java代码的追踪,最终指向的后台对象有以下一些:

----table
applsys.jdr_attributes            --存储OAF组件的attribute
applsys.jdr_attributes_trans--存储OAF组件的翻译,多语言或国际化的实现基础
applsys.jdr_components     --存储OAF组件树
applsys.jdr_paths                 --存储OAF页面路径(目录树)
----scripts
jdr_mds_internal
jdr_utils
jdr_custom_internal
jdr_docbuilder

具体的关系还没怎么仔细看,但是发现jdr_mds_internal这个包很关键了,各位有兴趣的朋友可以自己去看看。

 

ORACLE EBS中OAF屏蔽的错误

ORACLE EBS R12中引入了XML Publisher,Oracle Application Framework等新东西,利用网页/JSP技术增强Form/Report等的功能和表现力。

当运行网页出现错误时,ORACLE经常会出现如下抽象的提示:-
You have encountered an unexpected error. Please contact the System Administrator for assistance.

 

用下面的步骤可以让系统显示详细的错误信息

1. Set below profiles:
FND: Diagnostics = Yes 
FND: Message Level Threshold = "Debug High" 
2. Re-produce the error. The error message would be:
You have encountered an unexpected error. Please contact the System Administrator for assistance. 
Click here for exception details. 
3. Click "here" link to search the detail information
4. If still can not see the "here" link, then need to clear the cache and try again.


来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/25164132/viewspace-1135134/,如需转载,请注明出处,否则将追究法律责任。

上一篇: Webadi 问题集锦
下一篇: 没有了~
请登录后发表评论 登录
全部评论

注册时间:2011-03-16

  • 博文量
    64
  • 访问量
    255535