My Oracle Support Banner

iSupport: Performance Issue Viewing Service Requests After Applying Patch 9538286 (Doc ID 1138314.1)

Last updated on DECEMBER 09, 2020

Applies to:

Oracle iSupport - Version 12.0.6 and later
Information in this document applies to any platform.

Symptoms

On 12.0.6:

After applying patch 9538286, there is a performance issue displaying an Service Request in iSupport (2 to 4 minutes) due to this query performing badly:

SELECT PERSON_ID
FROM
per_workforce_current_x EMP WHERE EMP.party_id= ( select person_party_id
from fnd_user where user_id = :1)

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.