20150707 Created By BaoXinjian
一、摘要
设置WebADI的工作日志，EBS R12.1.3 以sysadmin登入， 然后通过 %BNE%LOG% 对应的三项，然后正确设置了路径，然后 Log Level 设置为 Trace ，logfile name 改为一个特定的文件名 ，然后重新启动了整个应用 。
1. 设定过程要注意：
(1). 设定过程最好是在英文环境下。
(2). 相应目录的权限需设定为777。
(3). 修改完成后需要重新启动应用 。
2. Metalink 解决方式
1.Login to the System Administrator Responsibility.
2.Open the System -> Profiles form.
3.Search for profiles using '%BNE%LOG%'
This should return three profiles.
- BNE Server Log Level - This should be set to "Trace".
- BNE Server Log Filename - Specify the log file name here (eg: "bneissue.log").
- BNE Server Log Directory - Provide the path of the log file directory here.
In older versions the profiles may be named:
- BNE Debug Log Level
- BNE Debug Log Filename
- BNE Debug Log Directory
4.Set the above three values (use a unique file name, to insure only information for your problem is included)
5.Bounce the Web server (so that the changes take effect)
6.Reproduce the issue
7.Change the file name profile option value after reproducing the issue, so that the BNE log file will have log messages related to this issue only.
8.If the log file is being generated for a related Service Request then also upload the BNE log to that SR.
二、解决方式
1. 设置以下Profile：
File name: bneisssue.log
Levle: ERROR
Path: /u2/VIS/visappl/apps/apps_st/appl/bne/12.0.0/log
2. 重启应用服务器
3. 查看所创建的日志文件
三、出现问题查看工作日志
1. WebADI出现错误如下
2. 查看WebADI工作日志，确定问题详情
--tail -100 bneissue.log 9/7/15 9:29 AM AJPRequestHandler-HTTPThreadGroup-7 CRITICAL ERROR BneAbstractXMLServlet.doRequest(),
fatal exception: oracle.apps.bne.exception.BneInvalidException: The value $PARAM$.FLEXID
for OA_FLEX_NUM in the flexfield definition is invalid or empty for the interface column identified by Integrator code:
801:PAY_BATCH_LINES_CRT_INTG, Interface Code 801:PAY_BATCH_LINES_CRT_INTF and sequence number 60 9/7/15 9:29 AM AJPRequestHandler-HTTPThreadGroup-7 CRITICAL ERROR Nested Exception, Level 0: Stack Trace: oracle.apps.bne.exception.BneInvalidException: The value $PARAM$.FLEXID
for OA_FLEX_NUM in the flexfield definition is invalid or empty
for the interface column identified by Integrator code: 801:PAY_BATCH_LINES_CRT_INTG, Interface Code 801:PAY_BATCH_LINES_CRT_INTF and sequence number 60 at oracle.apps.bne.repository.BneInterfaceCol.getOaFlexNum(BneInterfaceCol.java:1246) at oracle.apps.bne.repository.BneRenderableLayoutCol.applyFlexSegmentRules(BneRenderableLayoutCol.java:1447) at oracle.apps.bne.repository.BneRenderableLayoutCol.applyRulesForChildColumns(BneRenderableLayoutCol.java:1662) at oracle.apps.bne.repository.BneRenderableLayout.loadLayoutColumnData(BneRenderableLayout.java:998) at oracle.apps.bne.repository.BneRenderableLayout.loadLayoutHierarchyData(BneRenderableLayout.java:767) at oracle.apps.bne.repository.BneRenderableLayout.<init>(BneRenderableLayout.java:175) at oracle.apps.bne.repository.BneLayout.getRenderableLayout(BneLayout.java:2030) at oracle.apps.bne.integrator.document.viewers.msoffice.excel.BneAbstractMSExcelViewer.validateViewerParameters(BneAbstractMSExcelViewer.java:515) at oracle.apps.bne.integrator.document.BneOAExcelViewer.validateViewerParameters(BneOAExcelViewer.java:352) at oracle.apps.bne.integrator.document.BneOAExcelViewer.getViewerBean(BneOAExcelViewer.java:199) at oracle.apps.bne.integrator.document.BneViewerXMLService.handleRequest(BneViewerXMLService.java:187) at oracle.apps.bne.framework.BneAbstractXMLServlet.doRequest(BneAbstractXMLServlet.java:502) at oracle.apps.bne.framework.BneAbstractXMLServlet.doPost(BneAbstractXMLServlet.java:170) at javax.servlet.http.HttpServlet.service(HttpServlet.java:763) at javax.servlet.http.HttpServlet.service(HttpServlet.java:856) at com.evermind.server.http.ResourceFilterChain.doFilter(ResourceFilterChain.java:64) at oracle.apps.jtf.base.session.ReleaseResFilter.doFilter(ReleaseResFilter.java:26) at com.evermind.server.http.EvermindFilterChain.doFilter(EvermindFilterChain.java:15) at oracle.apps.fnd.security.AppsServletFilter.doFilter(AppsServletFilter.java:318) at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:621) 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.AJPRequestHandler.run(AJPRequestHandler.java:313) at com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:199) 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:619)
Thanks and Regards
技术交流，技术讨论，欢迎加入
Technology Blog Created By Oracle ERP - 鲍新建
