Re: goldengate replication commit order capture

Posted by ErmanArslansOracleBlog on Oct 01, 2020; 7:32am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/goldengate-replication-commit-order-capture-tp8827p8828.html

As you mentioned, the following is to get a unique value which would help in determining the sequence of operation;

@COMPUTE(@COMPUTE(@NUMSTR(@GETENV ("RECORD", "FILESEQNO"))*100000000000)+@NUMSTR(@GETENV ("RECORD", "FILERBA")))

Reference: Godengate @GETENV ('RECORD', 'RSN') Returning SCN of the transaction (Doc ID 2036276.1)

Check this MOS note as well -> What Tokens need to included in the transaction to make it unique for Insertallrecords to be used in the replicat (Doc ID 1340823.1)

Other than these, I have nothing to recommend on this.