ECTRIGO SQL -Duplicate Lines For Consolidated Shipment
(Doc ID 2769889.1)
Last updated on SEPTEMBER 20, 2021
Applies to:
Oracle Shipping Execution - Version 12.1.3 and laterInformation in this document applies to any platform.
Goal
Below is one of the SQL statements that is triggered by the ECTRIGO process.
SELECT
TO_CHAR(delivery_detail_id),
TO_CHAR(parent_delivery_detail_id),
TO_CHAR(delivery_id),
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL
FROM
wsh_delivery_assignments
WHERE delivery_detail_id = (
SELECT
wdd.delivery_detail_id
FROM
wsh_delivery_details wdd
WHERE
wdd.delivery_detail_id = wsh_delivery_assignments.delivery_detail_id
AND wdd.container_flag = 'Y'
AND wdd.container_flag = 'Y'
)
START WITH parent_delivery_detail_id IS NULL
AND delivery_id = :delivery_id
AND parent_delivery_id IS NULL --bug fix dupplicate items
CONNECT BY PRIOR delivery_detail_id = parent_delivery_detail_id;
Would it be possible to get a patch applied to our Oracle production instance for this issue?
Solution
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Goal |
Solution |
References |