OGG @GETENV ("TRANSACTION", "TIMESTAMP") Does Not Populate Target Column. (Doc ID 1400102.1)

Last updated on APRIL 12, 2017

Applies to:

Oracle GoldenGate - Version 10.4.0.19 to 12.2.0.1.0 [Release 10.4.0 to 12.2]
Information in this document applies to any platform.

Goal

Oracle GoldenGate (OGG) command @GETENV ("TRANSACTION", "TIMESTAMP") does not populate the target column on versions older to 12.2.0.1.160223

GETENV ("TRANSACTION","TIMESTAMP") is only valid for extract on the source side.
In OGG reference guide:
"Use the TRANSACTION option of @GETENV to return information about a source transaction. This option is valid for the Extract process."
Do not use it in replicat


Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms