SICSR-17324

[SICSR-17324] Recovery Order duration severely increased
Product Line:	Cede
Component/s:	Accounting Non-Prop Recovery
Affects Version/s:	SICS 4.9.2
Fix Version/s:	SICS 20.1 SICS 4.9.2 SSP1 ITA2
Customer:	Reale Mutua Assicurazioni

Problem:
Recovery order duration severely increased

Solution:
Remove unnecessary "DISTINCT" from query used in Recovery Calculation:
_SELECT DISTINCT t1.OBJECT_ID, t1.DTL_AMT, t1.OCC_YR, t1.UW_YEAR, t1.AC_YEAR, t1.AC_START_DATE, t1.AC_END_DATE, t1.IS_ESTIMATE, t1.HAS_SUM, t1.DATE_OF_BOOKING,
t1.ACC_AS_OF_DATE, t1.BOOKING_YEAR, t1.BOOKING_YEAR_2, t1.BOOKING_YEAR_3, t1.IDENTIFIER, t1.TITLE, t1.DTL_COMMENT, t1.CREATE_TIMESTAMP, t1.OCC_ID,
t1.IS_IN_CP_ORDER, t1.TRANS_GEN_LDGR_DT, t1.IS_TO_BE_CEDED, t1.FK_CURR, t1.FK_BUSINESS, t1.FK_INS_PER, t1.FK_SOC, t1.FK_ACCT_CLASS, t1.FK_ENTRY_CODE,
t1.FK_CLAIM,t1.FK_HEADLINE_LOSS, t1.FRK_AC_REF_PERIOD, t1.FSK_AC_REF_PERIOD, t1.FRK_BOOKING_PERIOD, t1.FSK_BOOKING_PERIOD, t1.FRK_BOOKING_PER_2,
t1.FSK_BOOKING_PER_2,t1.FRK_BOOKING_PER_3, t1.FSK_BOOKING_PER_3, t1.FK_BASE_COMPANY
FROM SOC_TO_LGH_CLM_REL t2, CLAIM_PROTPROG t3, AC_DETAIL_LIGHT t1
WHERE (t2.FK_CLAIM = t1.FK_CLAIM AND t3.FK_LIGHT_CLAIM = t2.OBJECT_ID
AND (((t3.FK_SOC = :"SYS_B_00" AND t1.DTL_AMT <> :"SYS_B_01")
AND ((t1.BOOKING_YEAR =:"SYS_B_02"
AND t1.FRK_BOOKING_PERIOD IN (:"SYS_B_03", :"SYS_B_04", :"SYS_B_05", :"SYS_B_06", :"SYS_B_07", :"SYS_B_08", :"SYS_B_09", :"SYS_B_10",
:"SYS_B_11",:"SYS_B_12", :"SYS_B_13", :"SYS_B_14", :"SYS_B_15", :"SYS_B_16", :"SYS_B_17", :"SYS_B_18", :"SYS_B_19", :"SYS_B_20"))
OR t1.BOOKING_YEAR < :"SYS_B_21")) ANDt1.FK_ENTRY_CODE IN (:"SYS_B_22", :"SYS_B_23", :"SYS_B_24", :"SYS_B_25", :"SYS_B_26", :"SYS_B_27",
:"SYS_B_28", :"SYS_B_29", :"SYS_B_30", :"SYS_B_31", :"SYS_B_32",:"SYS_B_33", :"SYS_B_34", :"SYS_B_35", :"SYS_B_36", :"SYS_B_37", :"SYS_B_38",
:"SYS_B_39", :"SYS_B_40", :"SYS_B_41", :"SYS_B_42", :"SYS_B_43", :"SYS_B_44",:"SYS_B_45", :"SYS_B_46", :"SYS_B_47", :"SYS_B_48")))
ORDER BY t1.OBJECT_ID ASC_

Workaround:

Root Cause:

Extent of Impact:

Impact on Existing Data

Recovery Method for Existing Data Affected