Performance issue with Pick Selection List Generation SRS at BEGIN WSH_PICK_LIST.RELEASE_BATCH_SRS (Doc ID 2107782.1)

Last updated on JULY 23, 2017

Applies to:

Oracle Shipping Execution - Version 12.2.3 and later
Information in this document applies to any platform.
*** checked for relevance July 23 , 2017 ***

Symptoms

On : 12.2.3 version, Pick Release

Pick Selection List Generation is encountering poor performance.

The following SQL was identified as poorly performing:

 

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