数据卡在接口表。解决方案:
1、更新接口表:RCV_TRANSACTIONS_INTERFACE中的以下字段值为:
processing_status_code: PENDING
processing_mode_code: BATCH
transaction_status_code: PENDING
2、运行请求:PO超级用户/.....提前新请求/接收事务处理处理器
3、做接收入库(接收事务处理)
4、在事务处理状态汇总那=>查出来,把错误的记录删除。
select interface_transaction_id, processing_status_code,processing_mode_code,transaction_status_code from RCV_TRANSACTIONS_INTERFACE ti where ti.po_line_location_id=331811
update RCV_TRANSACTIONS_INTERFACE
set processing_status_code = 'PENDING'
, processing_mode_code = 'BATCH'
, transaction_status_code = 'PENDING'
where interface_transaction_id =839926