Performance Issue with Standard API Gmd_samples_pub.create_samples.
(Doc ID 2519859.1)
Last updated on NOVEMBER 21, 2022
Applies to:
Oracle Process Manufacturing Product Development - Version 12.1.2 and laterInformation 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 |