My Oracle Support Banner

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

Last updated on FEBRUARY 03, 2019

Applies to:

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


On : 4.0.2 version, Installation

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.

Customer is expecting the to see the records that are up to midnight but not including midnight like the behaviour in OHMPI 1.1.8, OHMPI 4.0.2 is returning all 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.


 Subtract one millisecond from the end date in the custom client. This will guarantee that customer will never have an end date of midnight -- 23:59:59.999 avoiding the inclusion of the records for the next day.


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.