Value Set WSH_SRS_ORDER_NUMBERS Is Taking Time In R12 When Used In A Concurrent Program (Doc ID 2045885.1)

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.

Symptoms


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)
FROM
OE_ORDER_HEADERS_ALL WHERE ( ORDER_TYPE_ID=:b1 ) AND
FND_NUMBER.NUMBER_TO_CANONICAL(ORDER_NUMBER) = :X

EXPECTED BEHAVIOR

Parameter window should close immediately after clicking on 'OK' button.

OBSERVATION

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

STEPS
-----------------------
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'


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