Archive for the 'Oracle' Category
采购订单的小数点问题
如果采购订单的数量精度大于小数点后5位，如100.0000123，那么在做接收入库时，如果交货路线是要求检验的话，会发现接收后在检验时提示数字不对，无法入库或者退回。原因就在检验时，自动将数字四舍五入到100.00001，从而导致与来源数字无法匹配。
两个月前，我已将次BUG提交给Oracle，两个月后，换了N个工程师，终于给我答案，要求打5616611这个patch。
You must be on release 11.5.10 to apply this patch.
This patch fixes the issue of hardcoding rate type of ‘User’ for the user
conversion type in gl_interface table. After applying this patch the correct
user conversion type name is taken from the gl_daily_conversion_types table.
重新测试，发现在检验时，直接在form级就做了四舍五入，并且，可以入库和退货。不过……
多个form窗口
在浏览器主界面。
菜单 -> 工具 -> 关闭其它表单
这样就可以同时打开多个form表单了。
Oracle’s Application Server
Internal Server Error
The server encountered an internal error or misconfiguration and was unable to complete your request.
Please contact the server administrator, you@your.address and inform them of the time the error occurred, and anything you might have done that may have caused the error.
More information about this error may be available in the server error log.
Oracle-Application-Server-10g/10.1.2.0.2 […]
FND_ICX_ID_MISMATCH
不管做什么，都弹出一个窗口提示：FND_ICX_ID_MISMATCH。Metalink上只有一个知识条目提到，解决方法是：
Please make sure that there is only one Apps Session running.
You cannot run 2 Internet Explorers with 2 Apps Session is parallel.
照着做，关闭所有窗口，重启机器，然后只开一个窗口进form，问题重现。
于是杀毒，杀出很多毒；再杀流氓软件/插件， 又杀了一批。然后再进系统，问题解决。
嗯～嗯……，这也算涨了点经验值吧。
Metalink outage
因为五一的关系，并没有查看SR的处理进度。不过我也发现，Oracle的Global Support是全年无休的啊。今天第一时间访问metalink，不料却坏掉了：
MetaLink is currently experiencing an unscheduled outage.
We are working to resolve this outage as quickly as possible. If you have an urgent issue please call your local support center. Click here for a list of Oracle Support phone numbers.
Thank you in advance for your […]