[SICSR-17167] eMessaging ValdaiteFAINotInAnotherSettlement Performance  
Product Line: P&C
Component/s: eMessaging
Affects Version/s: SICS 4.9.3
Fix Version/s: SICS 4.9.5 SICS 4.9.3 SSP4
Customer: Swiss Re Zurich

Problem:
ValdaiteFAINotInAnotherSettlement performance is slow and should be improved due to multiple single queries for each FAI in the Settlement message,

Solution:
Perform a single query for all FAI in the message at once to return only data required to raise problems.

Workaround:

Root Cause:

Extent of Impact:

Impact on Existing Data

Recovery Method for Existing Data Affected