Target table column with systimestamp datatype displays that data was applied 1 second later than specified in the "stop post at sourcetime" command.
Example:
On Target the following post command was issued:
sp_ctrl> stop post at sourcetime HH:MM:SS ----> Example 12:00:00
sp_ctrl> stop post at sourcetime 12:00:00
The target table column with datatype "systimestamp" shows that data posted 1 second later ----> example 12:00:01
In other words, select from the target table shows that the data was posted one second later than specified in the "stop post at sourcetime" command.
WORKAROUND:
Change target column datatype from systimestamp to sysdate.
