Audit Log Date/Time Column Shows Blank When a Code List Value is Added from Argus Console (Doc ID 1577362.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Argus Safety Japan - Version 6.0.5.1 and later
Information in this document applies to any platform.

Symptoms

When a new value for Code List is added, the Utilities >> Logs >> View Audit Log screen
shows the corresponding record but its 'Date/Time' column shows blank.

When this symptom is occuring, if user selects the CMN_AUDIT_LOG.LOG_DATETIME_STAMP, it returns illegal year value.
For example,
select to_char(LOG_DATETIME_STAMP,'YYYY/MM/DD') from CMN_AUDIT_LOG;
returns like
to_char(LOG_DATETIME_STAMP,'YYYY/MM/DD') = 0003/07/24



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