Oracle EBS:PO行接收关闭后修改其它行自动打开

Oracle EBS:PO行接收关闭后,因更改交期或其它元素，修改重新送审后，接收关闭状态会自动打开.这对于更改采购计划的时候会造成比较大的困扰。
http://www.dezai.cn/blog/article.asp?id=354
可以通过作取消动作来代替接收关闭，但对取消后的需求要比较清确的明确供需情况。

搞来搞去,原来是个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.

一点积累，与大家分享。欢迎指正.

转载于:https://www.cnblogs.com/eastjazz/archive/2010/08/27/1809746.html