My Oracle Support Banner

IMPORT BATCH TO TCA REGISTRY INSERTING MILLIONS ROWS IN HZ_IMP_RELSHIPS_SG (Doc ID 2737986.1)

Last updated on JANUARY 04, 2021

Applies to:

Oracle Trading Community - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

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.



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
Cause
Solution
 1. Bug Summary
 2. Fixed Files
 3. Recommended Patches
 4. Solution Steps
References


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