The API gme_api_pub.create_material_txn is Having Performance Issues
(Doc ID 2423419.1)
Last updated on JULY 16, 2018
Applies to:Oracle Process Manufacturing Process Execution - Version 12.1.3 and later
Information in this document applies to any platform.
On : 12.1.3 version, Performance
The API gme_api_pub.create_material_txn is having performance issues. It is taking sometimes more than two minutes time to process for some particular items
A tkprof from a trace with waits and binds shows that the following query is taking a long time:
MTL_OBJECT_GENEALOGY WHERE OBJECT_ID = :B2 AND OBJECT_ID2 IS NULL AND
PARENT_OBJECT_ID = :B1 AND PARENT_OBJECT_ID2 IS NULL AND END_DATE_ACTIVE IS
NULL AND GENEALOGY_TYPE <> 5
Expect API to take less time
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!