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.
On : 12.1.2 version,
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:
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.
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