My Oracle Support Banner

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.

Symptoms

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.

Changes

 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

Cause

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
Symptoms
Changes
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.