My Oracle Support Banner

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

To view full details, sign in with your My Oracle Support account.

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


In this Document
Goal
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.