My Oracle Support Banner

ECTRIGO SQL -Duplicate Lines For Consolidated Shipment (Doc ID 2769889.1)

Last updated on APRIL 19, 2021

Applies to:

Oracle Shipping Execution - Version 12.1.3 and later
Information 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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.