Overview

The order is stuck in the ‘Confirmed’ state, but was actually completed; thus it needs to have a new Dispatch and a Pick so that the order can be charged.

Solution

Please reach out to the Support Team and provide the Order(s) ID(s) and the support team will investigate the issue and get back to you with the root cause and the solution.

<supportagent>

Solution Steps:

1. Reproduce the issue
   1. Check scripts.
   2. Create backup.
   3. Update scripts.
2. Find the pick that is preventing the allocation
   1. Find the picks that are in the ‘Warn’ state.
   2. Find the related despatches.
   3. Check despatches for movement and identify the orphaned pick.
3. Remove the pick that is preventing the allocation
4. Confirm the related order.
5. Remove the orphaned pick.

Reproduce the issue

Check Scripts:

select sor_num, sor_ref, mail.get_order_status(sor_num) status
from sor_defs where sor_ref in ('50074912','50075201')

select * from gtrans_items
where sor_num in (
  select sor_num  from sor_defs
  where sor_ref in (  '50075201'  )
)

Create backup:

create table sup.zd2905078_sor_items as
select * from sor_items where sor_num in (
  select sor_num  from sor_defs
  where sor_ref in ( '50075201')
)

create table sup.zd2905078_sor_payment as
select * from sor_payments where sor_num in (
  select sor_num  from sor_defs
  where sor_ref in ( '50075201' )
)

Update Scripts:

update sor_payments set dsp_num = null where sor_num in (
  select sor_num  from sor_defs
  where sor_ref in ( '50075201' )
);

update sor_items  set dsp_state = 'NONE'  where sor_num in (
  select sor_num
  from sor_defs
  where sor_ref in( '50075201' )
) ;

Find the pick that is preventing the allocation

Find the picks that are in the ‘Warn’ state:

select d.gtrans_state, i.* from gtrans_items i inner join gtrans_defs d on i.gtrans_num = d.gtrans_num
where 
season = '100A' and sty_num = 'MS36' and sty_qual = '53775' and bf_mat_char_val = '1WHT-WHITE'
and sty_size = '4LG' and d.gtrans_state = 'WARN'
and gsource_bin = 'CLP001'
and qty7 is not null

Using the previous, find the related despatch:

select * from gtrans_items where orig_dsp_num in (
29442069, 29778328
)
and season = '100A' and sty_num = 'MS36'
and sty_qual = '53775' and bf_mat_char_val = '1WHT-WHITE'
and sty_size = '4LG’

Check despatches for movement and identify the orphaned pick:

select tot_item_qty, i.* from gtrans_items i where orig_dsp_num  = 29442069

Remove the pick that is preventing the allocation

Confirm the related order:

select sor_state from sor_defs where sor_num = 4270329

Remove the orphaned pick:

--backup
create table sup.zd2905078_pick1 as 
select * from gtrans_items where gtrans_num = 29442069
--deletion
delete from gtrans_items where gtrans_num = 29442069

Testing

Ask the customer to confirm whether the issue is resolved.

</supportagent>