My Oracle Support Banner

Performance Issue with Standard API Gmd_samples_pub.create_samples. (Doc ID 2519859.1)

Last updated on DECEMBER 28, 2020

Applies to:

Oracle Process Manufacturing Product Development - Version 12.1.2 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.2 version,

ACTUAL BEHAVIOR
---------------
Performance issue while calling the standard API gmd_samples_pub.create_samples

It can be seen that the SQL that is taking the most time is:

SELECT 1
FROM
MTL_LOT_NUMBERS WHERE INVENTORY_ITEM_ID = :B5 AND((:B4 = 'Y' AND :B3 IS NOT
 NULL AND LOT_NUMBER = :B3 ) OR (:B4 = 'Y' AND :B3 IS NULL) OR (:B4 = 'N'
 AND LOT_NUMBER = :B3 )) AND ORGANIZATION_ID = :B2 AND ((:B1 IS NULL ) OR
 (PARENT_LOT_NUMBER = :B1 ))

Assistance to optimize SQL.

Changes

 

Cause

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
Symptoms
Changes
Cause
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.