urgent help -- REPERROR (DEFAULT, EXCEPTION) is discarding, not writing to exception tables.
We are doing the bi-directional replicaiton, to handle the conflicts we are trying to write the all conflict data in exception tables. So that it can be dealt manually.
From oracle knowledge base, i came to know the REPERROR (DEFAULT, EXCEPTION) command will capture all ora errors raised in the conflict and write into exception table.
i tested by inserting the duplicate data manually, i can see the exception in exceptions table. But when we run the application which is high transactional, simply it's discarding the conflict data and no exception written to exception tables.
when i checked discard files, it has written below message format in discard file with ora no errors