Active Detail / Inactive Day data corruption

(Doc ID 2335722.1)

Last updated on DECEMBER 07, 2017

Applies to:

Oracle Time and Labor - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On :  All version, Oracle Time and Labor Rules

In OTL Analyzer the following error is found :

Active Detail / Inactive Day


Time_Building_Block_Id    Object_Version_Number Det_Date_To              Day_Date_To
1717821                         1                                31-DEC-4712 00:00   14-NOV-2017 14:49
1717819                         1                                31-DEC-4712 00:00   14-NOV-2017 14:49

2 Rows Selected
Error: You have data corruption issue in this timecard.
Please log a service request with Oracle Support showing them this section in the output to ask a data fix from development.

 

Datafix is required


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run OTL Analyzer
2. Check the output

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