My Oracle Support Banner

@DATE function with @COMPUTE does not work in OGG 12.3.x (Doc ID 2417687.1)

Last updated on FEBRUARY 27, 2019

Applies to:

Oracle GoldenGate - Version 12.3.0.1.2 and later
Information in this document applies to any platform.
@DATE function with @COMPUTE does not work in OGG 12.3.x.

It works on OGG 12.1.2.x branch, but not in OGG 12.3.0.1.0


Following configuration is not working in version OGG 12.3.x

= @DATE ('YYYY-MM-DD HH:MI:SS', 'JTS',@COMPUTE
(@DATE ('JTS', 'YYYY-MM-DD HH:MI:SS', ) - 32400000000
)),

This works is expected on 12.1 versions

2018-04-16 08:20:19 WARNING OGG-01335 Error mapping data from
. to .
in function DATE.

2018-04-16 08:20:20 ERROR OGG-01296 Error mapping from
.
to .
.

Symptoms

2018-04-16 10:12:27 WARNING OGG-01335 Error mapping data from <SCHEMA>.<TABLE> to <SCHEMA>.<TABLE>  in function DATE.

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


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