Active Detail / Inactive Day data corruption

(Doc ID 2335722.1)

Last updated on FEBRUARY 07, 2018

Applies to:

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


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

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


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