Puszczamy skrypt patch 4488261 usuwa zbędne spacje z wysyłek.
ten sql pokazuje ze mamy problem
SELECT count(*)
FROM wsh_delivery_details wdd
WHERE ( length(wdd.item_description) <>
nvl(length(rtrim(wdd.item_description)),0)
OR length(wdd.shipping_instructions) <>
nvl(length(rtrim(wdd.shipping_instructions)),0)
OR length(wdd.packing_instructions) <>
nvl(length(rtrim(wdd.packing_instructions)),0)
OR length(wdd.cust_po_number) <>
nvl(length(rtrim(wdd.cust_po_number)),0)
OR length(wdd.serial_number) <>
nvl(length(rtrim(wdd.serial_number)),0)
OR length(wdd.customer_dock_code) <>
nvl(length(rtrim(wdd.customer_dock_code)),0)
OR length(wdd.tracking_number) <>
nvl(length(rtrim(wdd.tracking_number)),0)
OR length(wdd.TP_ATTRIBUTE15) <>
nvl(length(rtrim(wdd.TP_ATTRIBUTE15)),0)
OR length(wdd.customer_job) <> nvl(length(rtrim(wdd.customer_job)),0)
OR length(wdd.cust_model_serial_number) <>
nvl(length(rtrim(wdd.cust_model_serial_number)),0) )
AND wdd.source_code = 'OE'
AND wdd.released_status in ('R','B','X','N','Y','S')
AND wdd.container_flag = 'N';