Last updated on AUGUST 22, 2015
Applies to:Oracle Shipping Execution - Version 12.1.1 and later
Information in this document applies to any platform.
Find the request submission takes a long time for a concurrent program that makes use of the Value Set 'WSH_SRS_ORDER_NUMBERS'.
A delay of 10 seconds is observed when parameters are entered and 'OK' button is clicked.
Performance causing sql query is
SELECT FND_NUMBER.NUMBER_TO_CANONICAL(ORDER_NUMBER),ORDER_NUMBER VALUE,
TO_CHAR(ORDER_NUMBER) DESCRIPTION, NVL('N', 'N'), NVL(TO_NUMBER(NULL), -1),
NULL, NVL('Y', 'Y'), NVL(TO_CHAR(TO_DATE(NULL), 'J'), 0),
NVL(TO_CHAR(TO_DATE(NULL), 'J'), 0)
OE_ORDER_HEADERS_ALL WHERE ( ORDER_TYPE_ID=:b1 ) AND
FND_NUMBER.NUMBER_TO_CANONICAL(ORDER_NUMBER) = :X
Parameter window should close immediately after clicking on 'OK' button.
In 11i this performance delay is not seen and sql query does not use the FND_NUMBER.NUMBER_TO_CANONICAL function in the where clause
The issue can be reproduced at will with the following steps:
1. Use WSH_SRS_ORDER_NUMBERS value set in a concurrent program.
2. Go to responsibility , that has this program attached the request group. Click on View-->Requests-->Submit a new Request.
3. Select the Concurrent Program and press tab
4. Enter parameters and click on 'OK'
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms