How do Shareplex replicate a DML that refers to a pseudocolumn on source side? (4301267)

It is possible to formulate a DML that references a pseudocolumn on source side. This  article explains how the DML is replicated to the target side, given that pseudocolumn was used to construct it on the source.

General information.

Shareplex will first determine the value of the pseudocolumn on source, determine the expression by substituting the pseudocolumn just computed, and finally assign the value of the expression to the source column.  It will only replicate the assigned value(s) and not the pseudocolumn. For example, if the following INSERT is executed on source:

INSERT into SCHEMA1.TABLENAME (CREATE_DATE) values (SYSDATE);

Assuming that today’s date is 05-OCT-2016 when the above statement is executed on source.

Then Shareplex will replicate the following to the target:

INSERT into SCHEMA1.TABLENAME  (CREATE_DATE) values (05-OCT-2016);

And not:

INSERT into SCHEMA1.TABLENAME (CREATE_DATE) values (SYSDATE);