Recurring Permanent Lock on HXC_LOCKS for One Timecard
Last updated on OCTOBER 11, 2017
Applies to:Oracle Time and Labor - Version 12.0.6 and later
Information in this document applies to any platform.
For a specific user for a specific period, unable to enter the timecard. The symptom is that the standard lock is in effect, indicating that "Timecard For Xxxxxx Is Locked By Another Process", but looking in hxc_locks to monitor the lock, and it is locked by the same user, process_id and locker_type_id, but the lock time and transaction_lock_id is renewed approximately every hour, i.e. the timecard is never released before a new lock is created.
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