My Oracle Support Banner

TSFILDSDE Job Failing With Multi-threaded Configuration When TSFHEAD_PRG_HIST Tables Are Populated (Doc ID 2891924.1)

Last updated on AUGUST 25, 2022

Applies to:

Oracle Retail Insights Cloud Service Suite - Version 21.0 and later
Information in this document applies to any platform.


TSFILDSDE job failing with multi-threaded configuration when TSFHEAD_PRG_HIST tables are populated.
RDE job TSFILDSDE job failed with multi-threaded configuration with this error:
"ORA-00001: unique constraint (RDE19_DM01.PK_W_RTL_TSF_IT_LC_DY_FS) violated"

Steps To Recreate:
1. Setup multi-threading for scenario SDE_RETAILTRANSFERFACT in C_ODI_PARAM.
2. Make sure there are transfer records in TSF*_PRG_HIST tables in RMS.
3. Run TSFILDSDE job in RDE.
4. Notice the job failure after one of the threads runs successfully.


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.