Performance Issue When Running IEX Strategy Management Program (Doc ID 2757607.1)

Last updated on MARCH 04, 2021

Applies to:

Symptoms

When running IEX: Strategy Management, the program is taking 10+ hours to complete when a large amount of strategies are being assigned.  The longest running sql statements are:

BEGIN IEX_STRATEGY_CNT_PUB.MAIN(:errbuf,:rc,:A0,:A1,:A2,:A3,:A4,:A5,:A6,:A7,
:A8,:A9,:A10,:A11,:A12); END;

SELECT STATUS_CODE, DECODE(SCORE_VALUE, NULL, 0, SCORE_VALUE), STRATEGY_ID,
STRATEGY_TEMPLATE_ID
FROM
IEX_STRATEGIES WHERE CUST_ACCOUNT_ID = :B4 AND JTF_OBJECT_ID = :B3 AND
JTF_OBJECT_TYPE = :B2 AND CHECKLIST_YN = :B1

Steps to Reproduce:

Responsibility: Collections Agent
Navigation: Collections

1. Submit the IEX: Strategy Management concurrent program.

Cause

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