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
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