My Oracle Support Banner

Replication is Failing with Constraint Error "WAH_WAH_FK" in Target Import (Doc ID 2704367.1)

Last updated on AUGUST 31, 2020

Applies to:

Oracle Retail Merchandising Foundation Cloud Service - Version 19.0 and later
Information in this document applies to any platform.

Symptoms

Replication is failing at target side with below error:

Error:
WARNING OGG-01003 Repositioning to rba 30185917 in seqno 19.

 WARNING OGG-01154 SQL error 2292 mapping RMS1S006.RMSXX.WH to RHDASDEV_PDB1.RHDASDEV.WH OCI Error ORA-02292: integrity constraint (RHDASXXX.WAH_WAH_FK) violated - child record found (status = 2292), SQL .


Steps To Recreate:

Replication is failing at target side with below error:
  WARNING OGG-01003 Repositioning to rba 30185917 in seqno 19.
 
WARNING OGG-01154 SQL error 2292 mapping
RMS1S006.RMS01.WH to RHDASDEV_PDB1.RHDASDEV.WH OCI Error ORA-02292: integrity constraint (RHDASDEV.WAH_WAH_FK) violated - child record found (status = 2292), SQL .

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
References


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