IMPORT BATCH TO TCA REGISTRY INSERTING MILLIONS ROWS IN HZ_IMP_RELSHIPS_SG
(Doc ID 2737986.1)
Last updated on JANUARY 04, 2021
Oracle Trading Community - Version 12.1.3 and later Information in this document applies to any platform.
Import Batch to TCA Registry runs daily and processes hundreds of records. However, occasionally, "Worker 2 (TCA Import - Data Load Stage 2)" inserts hundreds of millions of records in the table AR.HZ_IMP_RELSHIPS_SG while processing a batch file with less than 1500 party records from DNB.
This is causing two issues:
1) "Import Batch to TCA Registry" runs for several hours 2) The Sequence HZ_RELATIONSHIPS_S already breached the max seeded value of ~2 billion.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!