2023年12月21日 星期四

Oracle EBS: 修正PO interface資料重轉

 Oracle EBS: 修正PO interface資料重轉


select * from po_headers_interface

 where ...


select * from po_lines_interface

 where interface_header_id = ?19248184


update po_headers_interface

  set process_code = null,

      processing_id = null

 where interface_header_id = ?19248184


update po_lines_interface

  set process_code = null,

      processing_id = null

 where interface_header_id = ?19248184


select * from po_interface_errors

  where interface_header_id = ?19248184

  


Oracle EBS: 修改RCV interface資料以重收貨

Oracle EBS: 修改RCV interface資料以重收貨


update rcv_headers_interface rhi

 set processing_request_id=null ,

receipt_header_id=null ,

validation_flag = 'Y' ,

processing_status_code = 'PENDING'

where 1=1 --group_id = 2634307

  and processing_status_code = 'ERROR'

  and exists  (select header_interface_id 

                 from rcv_transactions_interface rti

                where rhi.HEADER_INTERFACE_ID=rti.HEADER_INTERFACE_ID )


  

update rcv_transactions_interface

  set request_id=null ,

processing_request_id=null ,

order_transaction_id=null ,

primary_quantity=null ,

primary_unit_of_measure=null ,

interface_transaction_qty=null ,

validation_flag = 'Y' ,

processing_status_code = 'PENDING' ,

transaction_status_code = 'PENDING' 

 where 1=1 --group_id = 2634307

   and (processing_status_code = 'ERROR' or transaction_status_code = 'ERROR')

      

--------------------------------------------------------------------------------------


update rcv_headers_interface rhi

 set processing_request_id=null ,

receipt_header_id=null ,

validation_flag = 'Y' ,

processing_status_code = 'PENDING'

where group_id = ?2638496

  and processing_status_code = 'ERROR'

  and exists  (select header_interface_id 

                 from rcv_transactions_interface rti

                where rhi.HEADER_INTERFACE_ID=rti.HEADER_INTERFACE_ID )


  

update rcv_transactions_interface

  set request_id=null ,

processing_request_id=null ,

order_transaction_id=null ,

primary_quantity=null ,

primary_unit_of_measure=null ,

interface_transaction_qty=null ,

validation_flag = 'Y' ,

processing_status_code = 'PENDING' ,

transaction_status_code = 'PENDING' 

 where group_id = ?2638496