My Oracle Support Banner

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

Last updated on MAY 16, 2023

Applies to:

Oracle Financial Services Know Your Customer - Version 8.0.0 and later
Information in this document applies to any platform.


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.


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

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