FRM-40735: ON-ERROR trigger raised unhandle exception ORA-06508
Form Builder版本10,在本机编译、运行Form(此form基于Template.fmb基础上开发的),编译都没有问题,但是运行时报错。英文:FRM-40735: ON-ERROR trigger raised unhandle exception ORA-06508中文:FRM-40735: ON-ERROR 触发器提出了不能处理的异常状况 ORA-06508原因:基于Template.fmb无法在本机的Form Builder中运行,必须上传到服务器上,才能运行,否则一定会报上述错误。全新开发的Form(不基于Template.fmb)
java.lang.UnsupportedClassVersionError in Oracle Apps
After submitting inventory transaction, Oracle Applications show process error, Check inventory debug log, found out error:java.lang.UnsupportedClassVersionError. From log, The issue seems be related to LotTrxManager.class,Then run below script to check java file version in Database.beginfnd_aolj_util.getClassVersionfromDB(\'oracle.apps.inv.transaction.server.LotTrxManager\');end;Above script also error outLine Pos Text &nb
Unable to start Workflow Notification Mailer
\'Workflow Notification Mailer\' Service is under status:\'System Deactivated\'.Detailed Status Information like below:---------------------------------------------------------This automatic Service Component has been restarted the maximum of 10 times after stopping with error. Thus, it has been system deactivated -> oracle.apps.fnd.cp.gsc.SvcComponentContainerException: Could not start component; performing rollback -> oracle.apps.fnd.cp.gsc.SvcComponentException: Validation failed for
FRM-90926: Duplicate parameter on command line
After Logining Oracle EBS, System Error out with:FRM-90926: Duplicate parameter on command line.Then check URL of apps in IE,saw belowYou can see there are two "record=collect" in URL, That\'s why system tell us "Duplicate parameter"Solution:Login apps with other user and modify profile "ICX: Forms Launcher",remove "?record=collect" from value
Low-level Diagnostic Logging is turned on. This may temporarily reduce performance.
登陆EBS后,主界面有一个Warning:Low-level Diagnostic Logging is turned on. This may temporarily reduce performance.去除Warning的方法:Option 1: FND: Debug Log Enabled = NoOption 2:FND: Debug Lot Level级别设高些,比如Exception,Error,Unexpected就不会有这个warning了.如果设置级别为Statement,Procedure,Event就会有warning提示。
Error:'Please set up the forwarding function parameter "wipnp" in the workstation star
In JDev,Lanuch MES Home Page,Encounter a Error:\'Please set up the forwarding function parameter "wipnp" in the workstation startup function!\'Reason:In JDEV Project Properties,Runtime Connection information is not correct.Old Value:Application Short Name:INV,Responsibility Key:InventoryAfter correct to new value,the MES page got started successfully.New Value:Application Short Name:WIP,Responsibility Key:WIP_WS_SUPERVISOR
adpatch failed with error: "Missing file format id in file"
ERROR--------------------------------------------Defaults Feature Enabled = YES.Non-Interactive Mode = YES.Num Workers = 4.Flags = "hidepw".Options = "novalidate,norevcache,noprereq,hotpatch".Patch Top = "/slot/ems2962/appmgr/apps/apps_st/appl/patches/3413892/patches/16020972".AutoPatch error:Missing file format id in file:/slot/ems2962/appmgr/apps/apps_st/appl/admin/ml0yd213/restart/adpinit.rf9This version of AutoPatch requires a file format idon the first line o
javac encounter 'java.lang.ClassFormatError' error
Copied a Java source file to Oracle Apps Server, and Tried to use javac command to compile it. But javac raise below error:-bash-3.00$ javacException in thread "main" java.lang.ClassFormatError: com.sun.tools.javac.main.Main (erroneous method access flags) at _Jv_ClassReader.throw_class_format_error(byte) (/usr/lib/libgcj.so.5.0.0) at _Jv_ClassReader.handleMethod(int, int, int, int) (/usr/lib/libgcj.so.5.0.0) at _Jv_ClassReader.read_methods() (/usr
BNE_UIX_PHYSICAL_DIRECTORY is not configured.
Desktop Integration职责下 -> Create Document,遇到错误BNE_UIX_PHYSICAL_DIRECTORY is not configured.解决方法:1. Go into the responsibility: System Administrator2. Navigate to Profile -> System -> Profile:BNE UIX Physical Directory3. Remove any value in the profile BNE UIX Physical Directory (null value is the default)4. Bounce the web server and retest the issue.(see:http://blog.csdn.net/pan_tian/article/details/8135987)
OAException: Application: ICX, Message Name: ICX_SESSION_FAILED.
打完patch之后,重新登录Oracle EBS系统,报错 Exception Details: oracle.apps.fnd.framework.OAException: Could not load application module \'oracle.apps.fnd.sso.login.server.MainLoginPageAM\'. ... ... ## Detail 0 ## oracle.apps.fnd.framework.OAException: Application: ICX, Message Name: ICX_SESSION_FAILED. ... ... 解决方法: Restart Apps Server
Help > "About Oracle Application"里的信息不全
Oracle EBS中,"About Oracle Application"里的信息不全,Help > About Oracle Application,发现"Database Server","Forms Server"以及"Forms Server Environment Variables"的很多信息都没有打印全,比如Database Server PID,Session SID,SERIAL#,Forms Process ID... Oracle Applications Copyright (c) 2004 Oracle Corporation, Redwood Shores, California. All Rights Reserved. ---------------------------------------- Database Server --
Win7下,启动SQLTools,报:OCI8: Cannot allocate OCI handle
Win7下,启动SQLTools,报:OCI8: Cannot allocate OCI handle详细错误:Please make a post about this problem in the forum: http://www.sqltools.net/cgi-bin/yabb25/YaBB.plWe need the stack trace (see below) and short descriptionwhat were you doing when this problem occurred (desirable but optional).OCI8: Cannot allocate OCI handle.See http://sqltools.net/cgi-bin/yabb2/YaBB.pl?board=sqlt_faqProgram: SQLTools 1.6 Beta build 15Location: .\SQLTools.cpp(272).Platform: P
FRM-92095: Oracle Jnitiator version too low – please install version 1.1.8.2 or highe
打开EBS,系统报:FRM-92095: Oracle JInitiator 版本太旧。 请安装版本1.1.8.2或更高版本(英文的错误信息是:FRM-92095: Oracle JInitiator version too low. Please install version 1.1.8.2 or higher)解决方法1:因为今天升级了JRE到Version 7,但实际上现阶段EBS还不能跑在JRE7上。解决方法就是卸载JRE7,重装JRE6.Reference Note: FRM-92095 Error When Running Forms Using JRE 7 (JRE 1.7) (Doc ID 1348436.1)如何卸载JRE7
loadjava report error: java.lang.UnsupportedClassVersionError
使用loadjava命令load class到oracle数据库,这个时候报java.lang.UnsupportedClassVersionError错。 解决方法: UnsupportedClassVersionError错误是因为javac的版本问题,jvm默认为1.6,然而EBS的class的版本是1.5,所以直接javac编译的话,产生的class文件时1.6版本的class,这和EBS系统的版本不匹配,所以报错。 解决方法就是,在javac后边指定编译的版本为1.5. 命令:javac *.java -target 1.5
bad bind variable 'parameter.G_query_find'
编译Form时报bad bind variable \'parameter.G_query_find\'样的错误 PL/SQL ERROR 49 at line 1, column 1 bad bind variable \'parameter.G_query_find\' PL/SQL ERROR 49 at line 1, column 1 bad bind variable \'parameter.G_query_find\' PL/SQL ERROR 49 at line 3, column 1 bad bind variable \'parameter.G_query_find\' .... 解决方法: 出现这个错误的原因是因为环境变量FORMS_PATH(11i为FORMS60_PATH)没有设置正确导致的。 使用下边命令重新设置FORMS_PATH,
Debug Log没有生成?
客户遇到一问题,于是让客户收集INV的日志再分析原因,但不管怎么搞,日志都是收集不到(客户的设置没有问题)。 最后发现,原来客户的DB Server和Apps Server在不同的机器上,而日志是打到DB Server上的,而之前客户一直在Apps Server上找,所以没找到。 小问题,有时反倒让人容易忽略。
Profile:Flexfields:Validate On Server
Flexfields:Validate On Server Flexfield server-side validation is supplied with the base 10.7 install and as part of a 10SC patch for 10.6 releases.This profile option is set to "Yes" to enable server side, PL/SQL flexfields validation for Key Flexfields.This improves performance when using Key Flexfields over a wide area network by reducing the number of network round trips needed to validate the entered segment combinations.With this profile set to \'Y\', the validation request wil
OAException: Application: FND, Message Name: FND_NO_DATABASE_CONNECTION
打开Oracle Apps的主页,报下面的错误 Error Page You have encountered an unexpected error. Please contact the System Administrator for assistance. Click here for exception details. 点击Details,看到以下错误堆栈 Exception Details. oracle.apps.fnd.framework.OAException: Application: FND, Message Name: FND_NO_DATABASE_CONNECTION. at oracle.apps.fnd.framework.webui.OAPageErrorHandler.prepareException(OAPageError
AutoInvoice运行报错:You must supply an invoice number when your batch source indicates manual invoice nu
AutoInvoice运行报错,查看RA_INTERFACE_ERRORS_ALL,SELECT Message_text FROM RA_INTERFACE_ERRORS_ALL WHERE INTERFACE_LINE_ID = 1149459; 错误信息如下: You must supply an invoice number when your batch source indicates manual invoice numbering; otherwise you must leave invoice number blank 原因: RA_INTERFACE_LINES_ALL的trx_number有值, 但AR SETUP -> TRANSACTION -> SOURCES里,我们勾上Automatic Transaction Numbering,这表示,系统会自动
忘记了EBS登陆页面链接的地址怎么办
如果忘记了EBS登陆页面的链接怎么办,如果你还可以访问数据库,有尝试用下边两个SQL来查看登陆页面链接 方法1: SELECT home_url FROM icx_parameters; output like:http://xxx.com:8001/OA_HTML/AppsLogin 方法2:SELECT profile_option_value FROM fnd_profile_option_values WHERE profile_option_id= (SELECT profile_option_id FROM fnd_profile_options WHERE profile_option_name = \'APPS_FRAMEWORK_AGENT\')