Thanks Chris,

I immediately implemented the AUTONOMOUS_TRANSACTION.

The problem that we had with sequences is with Advanced Replication. We fixed that in some cases with:

Start 1 increment by 2 at site1 (odd keys)
Start 2 increment by 2 at site2 (even keys)

but order number mattered in some PK cases.

-----
But what is NDS? - I could not find in doc.