My Oracle Support Banner

Transaction Search Returning Incorrect Results When End Date Is Midnight (Doc ID 2304571.1)

Last updated on APRIL 02, 2021

Applies to:

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


The Transaction Search is not returning correct records when the END TIME is set as (00:00:00). It is returning records including the results for the next day.

The issue can be reproduced at will with the following steps:
1) Login to OHMPI 4.0.2

2) Select Transaction Tab

3) Enter the following parameter

From Date: 2017/08/11 To Date: 2017/08/12
From Time: 00:00:00 To Time: 00:00:00

4) Click on Search button and get the following:

Total Records Found: 0

5) Enter the following parameter:

From Date: 2017/08/12 To Date: 2017/08/13
From Time: 00:00:00 To Time: 00:00:00

4) Click on Search and you get the following result:

TransactionNumber EUID EUID2 SystemCode LID LID2 Function SystemUser TimeStamp
00000000000000000000 0000000000 HOS 000-000-0001 Add mpi 2017/08/14 00:52:36.779

00000000000000000001 0000000001 HOS 000-000-0002 Add mpi 2017/08/14 00:54:09.368

00000000000000000002 0000000000 0000000001 HOS 000-000-0002 000-000-0002 System mpi 2017/08/14 00:57:54.141
 Record Transfer

 As you can see the records above were for 2017/08/14.




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

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