Last updated on SEPTEMBER 02, 2016
Applies to:Oracle Database - Enterprise Edition - Version 184.108.40.206 and later
Oracle Incentive Compensation - Version 11.5.10 to 12.1.3 [Release 11.5 to 12.1]
Information in this document applies to any platform.
Update statement takes a long time on RDBMS Release 220.127.116.11 after having upgraded from Release 10.2.0.4.
From Oracle Incentive Compensation perspective, the following update statement shows very high I/O performance issue on RDBMS Release 18.104.22.168
(SELECT COUNT(1) FROM CN_COMMISSION_LINES WHERE
CREDITED_SALESREP_ID = A.SALESREP_ID AND PROCESSED_PERIOD_ID BETWEEN
A.PERIOD_ID AND A.END_PERIOD_ID AND PROCESSED_DATE BETWEEN A.START_DATE AND A.END_DATE), A.COMMISSION_HEADERS_COUNT = (SELECT COUNT(1) FROM
CN_COMMISSION_HEADERS WHERE DIRECT_SALESREP_ID = A.SALESREP_ID AND
PROCESSED_PERIOD_ID BETWEEN A.PERIOD_ID AND A.END_PERIOD_ID AND
PROCESSED_DATE BETWEEN A.START_DATE AND A.END_DATE) WHERE
A.LOGICAL_BATCH_ID = :B1
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms