Query USR_VI_PS_SHIP_IFACE to ensure that the order(s) exist in the view


SELECT * FROM USR_VI_PS_SHIP_IFACE WHERE TKT_NO = 'TICKET#'


  •  If the order does not exist the CP dealer will need to troubleshoot the SQL code of the view to determine why and correct.
  •  If the order does exist retry transferring the order by updating the last modified date on the order

UPDATE PS_DOC_HDR

SET RS_UTC_DT = GETUTCDATE()

WHERE TKT_NO = 'MISSINGORDER#'


Note: If the order still does not transfer there will need to be an escalation to engineering to perform a code trace