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;