EBS:采购接收失败
EBS采购接收失败
EBS 采购接收,接口表提示错误信息:错误: 指定的值 1 无效。 (COLUMN=LINE_NUM) 【英文:Error: The value specified 1 is invalid. (COLUMN=LINE_NUM) 】
错误代码:RCV_INVALID_ROI_VALUE_NE
原因:接收单题头已经创建,接收单行没有创建成功。
产生原因:可能是程序运行过程中,被用户强迫中止导致。
-- 检查有接收单题头记录,没有接收单行记录
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 | -- 检查有接收单题头记录,没有接收单行记录 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*/
有待验证以上解决方式。
【推荐】国内首个AI IDE,深度理解中文开发场景,立即下载体验Trae
【推荐】编程新体验,更懂你的AI,立即体验豆包MarsCode编程助手
【推荐】抖音旗下AI助手豆包,你的智能百科全书,全免费不限次数
【推荐】轻量又高性能的 SSH 工具 IShell:AI 加持,快人一步
· 全程不用写代码,我用AI程序员写了一个飞机大战
· MongoDB 8.0这个新功能碉堡了,比商业数据库还牛
· 记一次.NET内存居高不下排查解决与启示
· DeepSeek 开源周回顾「GitHub 热点速览」
· 白话解读 Dapr 1.15:你的「微服务管家」又秀新绝活了