Performance issue with Pick Selection List Generation SRS at BEGIN WSH_PICK_LIST.RELEASE_BATCH_SRS

(Doc ID 2107782.1)

Last updated on DECEMBER 15, 2017

Applies to:

Oracle Shipping Execution - Version 12.2.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.3 version, Pick Release

Pick Selection List Generation is encountering poor performance.

The following SQL was identified as poorly performing:

 

Changes

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms