My Oracle Support Banner

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

Last updated on JULY 16, 2018

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

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

This works is expected on 12.1 versions

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

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

Symptoms

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

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!


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