OHMPI Does Not Update SBYN_SYSTEMOBJECT And SBYN_SYSTEMSBR CREATE And UPDATE DATE Correctly. (Doc ID 2065776.1)

Last updated on OCTOBER 13, 2015

Applies to:

Oracle Healthcare Master Person Index - Version 2.0.9 and later
Information in this document applies to any platform.

Symptoms

On : 2.0.9 version with SQLServer, Master Index Data Quality

When adding or updating enterprise records in OHMPI, the CREATEDATE and UPDATEDATE columns in SBYN_SYSTEMOBJECT and SBYN_SYSTEMSBR are not maintained correctly.
For both fields, in both tables, the TIME portion of the field is always set to 12:00:00AM.

ACTUAL BEHAVIOR
---------------
For CREATEDATE and UPDATEDATE columns in SBYN_SYSTEMOBJECT and SBYN_SYSTEMSBR, the TIME portion of the field is always set to 12:00:00AM.

EXPECTED BEHAVIOR
-----------------------
The TIME value should be correctly displayed.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Add or update an entry in OHMPI MIDM
2. Go to SQL Server and check the 2 tables:

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