You can create a task to consume External Case Management feedback into the
KYC system.
Copy the existing KYCClearProcessingData task in the KYCDaily batch and give an
appropriate new task name, new task code and $JOBNAME$ as Load External
System Feedback To KYC.
Adjust the precedence by moving the newly created task associated to Load
External System Feedback To KYC between the LoadKYCCustomerRiskScore and
EndDataPipelineBatch tasks.
Run the KYCDaily batch.
Note:
The N_REQUEST_ID, N_RA_ID and FIC_MIS_DATE are composite primary keys.
Make sure to check the following points while feeding External Case
Management feedback into KYC via STG_FCC_KYC_EXT_SYS_FEEDBACK.csv file.
The N_REQUEST_ID, N_RA_ID and FIC_MIS_DATE columns can never be
null.
The N_REQUEST_ID, N_RA_ID and FIC_MIS_DATE columns together must be
unique such that for a given FIC_MIS_DATE, the N_RA_ID and
N_REQUEST_ID combination cannot be repeated.
All batch RA records must always have the N_REQUEST_ID column value
as 0.