Active Detail / Inactive Day data corruption

(Doc ID 2335722.1)

Last updated on APRIL 24, 2018

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 :

1. 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.

 

2.Duplicate Translation display keys

Translation_Display_Key - Duplicates
Active Detail / Inactive Day
and potentially due to the above errors also see:
These Expenditure Item Ids are linked to an Object Version Number of a Time
Building Block ID that do not exist in the original OTL Timecard

3.Translation display keys for the wrong line

Translation_Display_Key - Wrong Line
Time_Building_Block_Id Translation_Display_Key Detail_Row Attribute_Category
Attribute1 Attribute2 Attribute3 Attribute4 Attribute5 Attribute6 Attribute7
12792737 12822|1|5 1 PROJECTS 134 358016 Time GB ST N
12792731 12822|1|1 1 PROJECTS 152 6632 Lunch GB ST N
12792734 12822|1|3 1 PROJECTS 152 6632 Lunch GB ST N
...
 
Error: You have data corruption issue in this timecard. Please refer to the
following notes:
Note: 1547463.1 Profile OTL: Debug Check Enabled
Note: 1462822.1 After Editing Timecard by Nulling Out Hours, Timecard Gets
Corrupted
And we strongly recommend that you log a service request with Oracle Support
showing them this section in the output.

 

4.Translation_Display_Key - Wrong Day
TIMECARD_ID RESOURCE_ID START_TIME TIME_BUILDING_BLOCK_ID DAY DAY_TDK DET_TDK
CORRECT_SEGMENT3
20313393 8087 10-SEP-2017 00:00 20313399 16-SEP-2017 00:00 13822|0|3
13822|2|3 6
20313393 8087 10-SEP-2017 00:00 20313400 15-SEP-2017 00:00 13822|0|2
13822|1|2 5
20313393 8087 10-SEP-2017 00:00 20313401 14-SEP-2017 00:00 13822|0|1
13822|1|1 4
20313393 8087 10-SEP-2017 00:00 20313398 13-SEP-2017 00:00 13822|0|0
13822|1|0 3

Error: You have data corruption issue in this timecard.

Findings and Recommendations:
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
To avoid data corruption, user should set the profile OTL: Debug Check Enabled to yes, as this will cut down on these types of corruptions as well.

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

Changes

 

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