ECM Batch : Transfers Are Not Moved To Kdd_case_wire_trxn
(Doc ID 2680983.1)
Last updated on OCTOBER 21, 2020
Applies to:Oracle Financial Services Enterprise Case Management - Version 8.0.7 and later
Information in this document applies to any platform.
ECM Batch : Transfers are not moved to kdd_case_wire_trxn The task t2t_KDD_CASE_WIRE_TRXN is not moving fcc_wire_trxn into kdd_case_wire_trxn and hence cases in the UI are without transfers which complicates a lot the work of local compliance officer.
Delete is not required.
We have handled it in the query itself. Made changes to INSERT FCC_EVENT_ENTITY_MAP. Attached the modified Script.
Below lines were added
under from clause:
left outer join Fcc_Event_Entity_Map on Fcc_Event_Entity_Map.N_ENTITY_SKEY=FCC_FRONTOFFICE_TRXN_LOOKUP.FRONTOFFICETRXN_SKEY and Fcc_Event_Entity_Map.V_ENTITY_TYPE='WIRE_TRXN' and Fcc_Event_Entity_Map.N_RUN_SKEY=rec_batch.n_run_skey and Fcc_Event_Entity_Map.N_EVENT_SKEY=FCC_EVENT_LOOKUP.N_EVENT_SKEY
under where clause:
and FCC_EVENT_ENTITY_MAP.N_ENTITY_SKEY is null
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document