My Oracle Support Banner

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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.