Oracle EBS:PO行接收关闭后修改其它行自动打开
作者:admin 日期:2010-08-26
Oracle EBS:PO行接收关闭后,因更改交期或其它元素，修改重新送审后，接收关闭状态会自动打开.这对于更改采购计划的时候会造成比较大的困扰。
可以通过作取消动作来代替接收关闭，但对取消后的需求要比较清确的明确供需情况。
搞来搞去,原来是个bug。在11.5.0出现的bug，在12照样出现了。。
记录一下,方便碰到此问题的同仁可以参考。
ArticleID:469330.1
https://support.oracle.com/CSP/main/article?cmd=show&type=NOT&doctype=PROBLEM&id=469330.1
Applies to:
oracle Purchasing - Version: 11.5.10
This problem can occur on any platform.
Symptoms
Any line on a Purchase order that has been "Closed for Receiving" will be reopened if the PO is later re-approved. This differs from the results if the line is just Closed, where the lines will remain closed through all subsequent re-approvals.
The issue is seen regardless if the changes that caused the the re-approval touched the line or did not.
All Closed for Receiving lines are reopened upon submission for Approval again.
Cause
In pocup.lpc a condition is missing on the po_line_locations, to make sure that the commit only updates those records that are not already approved.
Solution- Apply Patch 5089729
- Updated key file: pocup.lpc - 115.10.11510.6
Version Check
strings -a $PO_TOP/bin/POXCON | grep '$Header' | grep pocup.lpc- Stop the PO Document Approval Manager
- Relink all PO executable:
1. Go to $AD_TOP/bin and relink the PO executable.
2. adrelink.sh force=y "PO ALL"
- Start the PO Document Approval Manager
- Retest issue
This patch is applicable only on top of oracle Applications Release 11.5.10 and/or Procurement Family Pack J.
References
BUG:5089729 - CLOSED PURCHASE orDER LINES ARE RE OPENED
BUG:6146142 - MANUALLY CLOSED FOR RECEIVING LINES OPENS UPON PO REAPPROVAL.
一点积累，与大家分享。欢迎指正.
可以通过作取消动作来代替接收关闭，但对取消后的需求要比较清确的明确供需情况。
搞来搞去,原来是个bug。在11.5.0出现的bug，在12照样出现了。。
记录一下,方便碰到此问题的同仁可以参考。
ArticleID:469330.1
https://support.oracle.com/CSP/main/article?cmd=show&type=NOT&doctype=PROBLEM&id=469330.1
Applies to:
oracle Purchasing - Version: 11.5.10
This problem can occur on any platform.
Symptoms
Any line on a Purchase order that has been "Closed for Receiving" will be reopened if the PO is later re-approved. This differs from the results if the line is just Closed, where the lines will remain closed through all subsequent re-approvals.
The issue is seen regardless if the changes that caused the the re-approval touched the line or did not.
All Closed for Receiving lines are reopened upon submission for Approval again.
Cause
In pocup.lpc a condition is missing on the po_line_locations, to make sure that the commit only updates those records that are not already approved.
Solution- Apply Patch 5089729
- Updated key file: pocup.lpc - 115.10.11510.6
Version Check
strings -a $PO_TOP/bin/POXCON | grep '$Header' | grep pocup.lpc- Stop the PO Document Approval Manager
- Relink all PO executable:
1. Go to $AD_TOP/bin and relink the PO executable.
2. adrelink.sh force=y "PO ALL"
- Start the PO Document Approval Manager
- Retest issue
This patch is applicable only on top of oracle Applications Release 11.5.10 and/or Procurement Family Pack J.
References
BUG:5089729 - CLOSED PURCHASE orDER LINES ARE RE OPENED
BUG:6146142 - MANUALLY CLOSED FOR RECEIVING LINES OPENS UPON PO REAPPROVAL.
一点积累，与大家分享。欢迎指正.
[本日志由 admin 于 2010-08-26 08:22 AM 编辑]
上一篇: 《22条商规》读后感
下一篇: 异常:HRESULT: 0x80070057 (E_INVALIDARG) 的处理
文章来自: 本站原创
引用通告: 查看所有引用 | 我要引用此文章
Tags: 
相关日志:
评论: 1 | 引用: 0 | 查看次数: 10050
redfly[2012-12-12 10:35 AM | 
| 
| 183.16.194.186 | 
| 通过审核 | 
回复][此评论正在审核中,只有博主及评论作者可见]
发表评论
