in AVDF Timezone -06:00 Does Not Work (Doc ID 2249517.1)

Last updated on MAY 16, 2017

Applies to:

Oracle Audit Vault and Database Firewall - Version 12.1.2.5 and later
Information in this document applies to any platform.

Symptoms

Audit Vault Console:

When we change the timezone to -06:00 the alerts configured not work at all.

We have one alert when a user do insert, this alert displays the #AlertBody# and it shows the date with 6 hours from difference, the timezone when the alerts work fine is set to +00:00.

The System Date is changed  Manually.

The alert is the following:

:EVENT_NAME='INSERT' AND :TARGET_OBJECT='PRUEBAY',

then a mail is send to us for verification and with the actual configuration timezone +00:00 came with the hours wrong specifying,
the #AlertBody# gets the hours difference, but if we change the time zone at -06:00 just the mail never send but the alert is registered in the server.

Cause

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