EBS:采购接收失败

EBS采购接收失败

 

EBS 采购接收，接口表提示错误信息：错误： 指定的值 1 无效。 (COLUMN=LINE_NUM) 【英文：Error: The value specified 1 is invalid. (COLUMN=LINE_NUM) 】

错误代码：RCV_INVALID_ROI_VALUE_NE

原因：接收单题头已经创建，接收单行没有创建成功。

产生原因：可能是程序运行过程中，被用户强迫中止导致。

-- 检查有接收单题头记录，没有接收单行记录 

-- 检查有接收单题头记录，没有接收单行记录 
select b.document_num /*采购号*/,b.document_line_num, /*采购行*/
       b.document_shipment_line_num,b.INTERFACE_TRANSACTION_ID,
       b.AUTO_TRANSACT_CODE,
       a.interface_type, a.column_name, a.error_message,b.SHIPMENT_HEADER_ID, b.SHIPMENT_LINE_ID
from PO.PO_INTERFACE_ERRORS a, PO.RCV_TRANSACTIONS_INTERFACE b
where 1=1  --a.ERROR_MESSAGE = 'Error: The value specified 1 is invalid. (COLUMN=LINE_NUM)'
  AND A.ERROR_MESSAGE = '错误： 指定的值 1 无效。 (COLUMN=LINE_NUM)'
  and a.ERROR_MESSAGE_NAME = 'RCV_INVALID_ROI_VALUE_NE'
  and a.TABLE_NAME = 'RCV_HEADERS_INTERFACE'
  and b.AUTO_TRANSACT_CODE IN ( 'RECEIVE' , 'DELIVER')
  and a.INTERFACE_LINE_ID = b.INTERFACE_TRANSACTION_ID
  and b.DOCUMENT_LINE_NUM IS NOT NULL
  and b.DOCUMENT_SHIPMENT_LINE_NUM IS NOT NULL
  and (b.shipment_header_id IS NULL
       or (b.shipment_header_id IS NOT NULL
          and not exists (select 1 from PO.RCV_SHIPMENT_LINES RSL
                          where RSL.SHIPMENT_HEADER_ID = b.SHIPMENT_HEADER_ID
                            and RSL.SHIPMENT_LINE_ID = b.SHIPMENT_LINE_ID)) 
                            );

　　解决方式一：

SELECT RTI.SHIPMENT_HEADER_ID, RTI.SHIPMENT_LINE_ID,
RTI.PACKING_SLIP,
RTI.GROUP_ID, RTI.*
FROM PO.RCV_TRANSACTIONS_INTERFACE RTI
WHERE RTI.DOCUMENT_NUM = '102301740193'; /*采购单号*/

是否清空 

RTI.SHIPMENT_HEADER_ID, RTI.SHIPMENT_LINE_ID,
RTI.PACKING_SLIP,
RTI.GROUP_ID 等字段 ，

UPDATE PO.RCV_TRANSACTIONS_INTERFACE RTI
SET RTI.SHIPMENT_HEADER_ID = NULL, RTI.SHIPMENT_LINE_ID = NULL,
RTI.PACKING_SLIP = NULL,
RTI.GROUP_ID = NULL,
RTI.TRANSACTON_STATUS_CODE ='PENDING',
RTI.PROCESSING_STATUS_CODE = 'PENDING'
WHERE RTI.INTERFACE_TRANSACTION_ID = 34040112
AND RTI.DOCUMENT_NUM = '102301740193'; /*采购单号*/

或直接删除 表（ PO.RCV_HEADERS_INTERFACE RHI）记录

SELECT RHI.*
FROM PO.RCV_HEADERS_INTERFACE RHI
WHERE GROUP_ID = 19261516 /* 关联 RTI.GROUP_ID */
AND RECEIPT_HEADER_ID = 12987174 /* 关联 RTI.SHIPMENT_HEADER_ID */
AND PACKING_SLIP = 9491600 /*关联 RTI.PACKING_SLIP*/

有待验证以上解决方式。