Slow Performance Of Details Button On Strategy Tab (Doc ID 1918804.1)

Last updated on AUGUST 24, 2016

Applies to:

Oracle Advanced Collections - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

 After the upgrade to Release 12.1.3 from 11.5.10, we are seeing a performance issue when clicking on the details button in the Strategy Tab.   It may take 90 seconds for the details box to appear.

Following statement is slow:
SELECT FAILURE_REASON
FROM
IEX_XML_REQUEST_HISTORIES   WHERE OBJECT_ID =  :b1  AND OBJECT_TYPE =  
 'IEX_STRATEGY'  

Changes

Upgraded from 11.5.10 to 12.1.3

Cause

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 hundreds of Community platforms