学步园

RTP报错信息: RVTPT-020: Subroutine rvtoe_RmaPushApi() - EDelivered quantity cannot exceed received quantity. returned error

 

原因:部分接收时,系统没有自动split这个RMA订单行;

 

现假设RMA订单行数量为10个,先前已成功接收5个,现再接收余下5个时报上面的错误.

 

解决方法(假设RMA行的id为1234567):

 

 BEGIN

  dbms_application_info.set_client_info(123);--假定OU为123
  oe_rma_receiving.push_receiving_info(p_rma_line_id             => 1234567
                                      ,p_quantity                => 5    --之前成功接收的5个要进行split;
                                      ,p_parent_transaction_type => NULL
                                      ,p_transaction_type        => 'RECEIVE'
                                      ,p_mismatch_flag           => NULL
                                      ,x_return_status           => x_return_status
                                      ,x_msg_count               => x_msg_count
                                      ,x_msg_data                => x_msg_data
                                      ,p_quantity2               => NULL
                                      ,p_r2cust_parent_trn_type  => NULL);

  oe_order_wf_util.update_flow_status_code(p_line_id          => 1234567
                                          ,p_flow_status_code => 'RETURNED'
                                          ,x_return_status    => x_return_status);
END;