In bidirectional replication, oftenly i am seeing this parent key not found error. I think in replication, order of insert in parent table is not happen first and unfortunately we can't disable the foreign key .
ORA-02291: integrity constraint (HSS.FK9090) violated - parent key not found)
Tried with various option like DBOPTIONS DEFERREFCONST, DEFERAPPLYINTERVAL 30 SECS and also made a constraint defferable, still no use.
Also i checked with below CDR statements in replicat, but this piece of code can resolve only the data conflict issue not the order of data insertions.
MAP STT.TAX, TARGET STT.TAX,
COMPARECOLS (ON UPDATE ALL, ON DELETE ALL),
RESOLVECONFLICT (UPDATEROWEXISTS, (DEFAULT, USEMAX (ID))),
RESOLVECONFLICT (INSERTROWEXISTS, (DEFAULT, IGNORE)),
RESOLVECONFLICT (DELETEROWEXISTS, (DEFAULT, OVERWRITE)),
RESOLVECONFLICT (DELETEROWMISSING, (DEFAULT, DISCARD));
Can anybody advise me, how to write this kind of conflict resolution i.e ora-02291?