采购审批，错误3

lkfi

metalink上有一个相同错误信息问题的解决方案，Blanket release approval fails with Document manager Error 3 :POXDM-280 RVSRQ-125 RVSUT-085 [ID 553874.1]

请先按照这篇Note的方法先检查一下原因是否相同，如果是的话，按照其中的方案解决即可：

Cause

The releases have shipments with an invalid promised date. The promised date is set to 12/31/9999.

This can be checked by executing the following script:

SELECT pha.segment1, pha.po_header_id, pha.authorization_status
, pra.po_release_id, pra.release_num
, pla.line_num, pla.po_line_id, pda.po_distribution_id
, pll.line_location_id, pll.promised_date
FROM po_headers_all pha
, po_lines_all pla
, po_distributions_all pda
, po_line_locations_all pll
, po_releases_all pra
WHERE pra.release_num = &release_num
AND pra.po_release_id = pll.po_release_id
AND pll.line_location_id = pda.line_location_id
AND pda.po_line_id = pla.po_line_id
AND pla.po_header_id = pha.po_header_id
AND pha.segment1 = '&blanket_num'
AND pha.org_id = &org_id;

----------------------------------------以上原因分析，下面是解决方案-------------------------------
Solution

To implement the solution, please execute the following steps:

1. Run the script poresrel.sql in the $PO_TOP/sql to reset the release to status Incomplete. For more information see Note 390023.1: How To Reset a Document To Incomplete/Requires Reapproval For Isolated Cases
2. Navigate to Purchase Orders > Releases
3. Query the involved release
4. Correct the promised date and save the changes
5. Resubmit the release for approval

[ 本帖最后由 lkfi 于 2011-3-15 10:56 编辑 ]

Oracle安装工

这个没用，我试过该方案

在PO审批环节中，如果审批人通过未结单据进入FORM后改了PO后，特别容易出现错误单据－3的这种错误，审批人修改PO我们这边主要是财务去核对PO借记账号

流泪战神

SELECT pha.segment1, pha.po_header_id, pha.authorization_status
, pra.po_release_id, pra.release_num
, pla.line_num, pla.po_line_id, pda.po_distribution_id
, pll.line_location_id, pll.promised_date
FROM po_headers_all pha
, po_lines_all pla
, po_distributions_all pda
, po_line_locations_all pll
, po_releases_all pra
WHERE pra.release_num = &release_num
AND pra.po_release_id = pll.po_release_id
AND pll.line_location_id = pda.line_location_id
AND pda.po_line_id = pla.po_line_id
AND pla.po_header_id = pha.po_header_id
AND pha.segment1 = '&blanket_num'
AND pha.org_id = &org_id;
===
没有结果返回，应该不是这个原因。。。