OTL Timecard Audit Trail Report Shows Timecard Is Submitted By Another User
(Doc ID 2734741.1)
Last updated on DECEMBER 07, 2020
Applies to:Oracle Time and Labor - Version 12.2.8 and later
Information in this document applies to any platform.
The OTL Audit Trail report shows that a timecard created by user xxx was submitted by user yyy.
Timecard Audit Trail report gets data from table HXC_RPT_TC_DETAILS_ALL which also shows wrong data.
Steps to Reproduce:
The issue can be reproduced at will with the following steps:
1. Sequence ID should have the value less than MAX(SUBMISSION_ID) - In this case, application always uses MAX(SUBMISSION_ID) and sequence will never be used
2. Care should be taken to submit time cards for 2 different screens for 2 different users simultaneously. If it is not simultaneous - then one transaction will beat the other and different max(submission_id) will be generated. If its submitted at the same time, the submission_id used will be the same and it will cause this issue.
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