Recurring Permanent Lock on HXC_LOCKS for One Timecard

(Doc ID 1094403.1)

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.

Symptoms

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.

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