Question: When upgrading GoldenGate from 11 to 12c, on starting up the Replicat I get the following error. What caused this and how is it resolved?
OGG-01298 Column function diagnostic message: could not find column “TRANSACTION”.
Answer: The OGG-01298 error is returned on the Replicat startup after the GoldenGate is upgraded to 12c. This happens only when a MAPPING clause uses the TRANSACTION keyword.
Cause: It is due to a change in behavior of the GoldenGate where single quotes have to be used instead on double quotes.
Action: Simply change the Replicat parameter to use single quotes.