OTL Timecard Audit Trail Report Shows Timecard Is Submitted By Another User
(Doc ID 2734741.1)
Last updated on SEPTEMBER 23, 2024
Applies to:
Oracle Time and Labor - Version 12.2.8 and laterInformation in this document applies to any platform.
Symptoms
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.
Changes
Cause
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
Symptoms |
Changes |
Cause |
Solution |
References |