[SICSR-8945] Consistency script ACB016 is not correct
Product Line:	P&C
Component/s:	Database Updating
Affects Version/s:	SICS 4.6 SSP13
Fix Version/s:	SICS 4.9.4
Customer:	Assicurazioni Generali S.p.A.

Problem:
DCT - ACB016 Not correct.

Solution:
Correct script
b1.frk_worksh_status <> b2.frk_worksh_status
AND NOT (p.FRK_PAIRING_TYPE IN ('PLATOACCT', 'BOOKTOPLA', 'ORIGTOBOOK', 'ORIGTOREVRS', 'CLMTOOCC','ASSTOFAC','XLCATOPLA', 'PLATOPLA', 'PLATOACCTERA' )
AND b1.frk_worksh_status = 'C' AND b2.frk_worksh_status = 'O')
AND NOT (p.FRK_PAIRING_TYPE IN ('ORIGTOREVRS', 'CLMTOOCC','BOOKTOPLA', 'PLATOACCT')
AND b1.frk_worksh_status = 'C' AND b2.frk_worksh_status = 'I')

Workaround:

Root Cause:

Extent of Impact:

Impact on Existing Data

Recovery Method for Existing Data Affected