My Oracle Support Banner

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.

Symptoms

On : 12.1.3 version, Performance

ACTUAL BEHAVIOR
---------------
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:

SELECT COUNT(*)
FROM
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

EXPECTED BEHAVIOR
-----------------------
Expect API to take less time

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!


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.