Overview

You found out that some of the Picks in CIMS are not sent-to/picked-up by JDA and you would like those Picks to be reflagged. 

Requirements

The customer needs to provide either sor_num or sor_ref for the Sales Order or the gtrans_num of the picking note.

Solution

In order for such Picks to be picked up by JDA, changes to the database tables need to be made, so create a support ticket and provide details of the Pick Movement number or sor_num or sor_ref number.

select * from sor_defs where sor_ref='UKF1001914354'; 

 select orig_dsp_num from gtrans_items where sor_num='15623784';

 create table sup.zd<Zendesk ticket ID>_gtrans_num
 as 
 select * from gtrans_defs where gtrans_num=25219798; --< this is orig_dsp_num from above query

 update gtrans_defs
 set hh_state = null
 where gtrans_num in (
 <Pick movement numbers provided by the client or found in the steps above>
 );

commit;