KYC ECM Batch Task 53 – DT Correlation Task Fails (Doc ID 2948605.1)

Last updated on MAY 16, 2023

Applies to:

Goal

ECM Batch Task #53 – DT Correlation Task fails when the ECM batch is run after the KYC Batch to create KYC ECM Cases.
Error : 942, Position : 20, Sql = select PATH_ID from tmp_path_config, OriginalSql = select PATH_ID from tmp_path_config, Error Msg = ORA-00942: table or view does not exist
Examining the database package “pkg_correlation”, temp table “tmp_path_config “ does not get created. Looks like the statement in the package highlighted in yellow is not getting executed.

We are having to manually create the temp table for the task to complete successfully but are not sure if there are any impacts in AML or other batches that also execute ECM batch.
 

Solution

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