RCVOTLR Retrieve Time from OTL Error In Progress in Table HXC_TRANSACTIONS (Doc ID 1941631.1)

Last updated on JULY 15, 2016

Applies to:

Oracle Time and Labor - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On Production instance : 12.1.3 version, Receiving Functions

ACTUAL BEHAVIOR
---------------
Retrieve Time from OTL (RCVOTLR) process has been stopped midway.
After service are restarted RCVOTLR  completes in error stating process is
already running.
Records are stuck IN PROGRESS in table hxc_transactions
This IN PROGRESS record causes error in next "Retrieve Time from OTL (RCVOTLR)" run.
A datafix has to be run on hxc_transactions to set the IN PROGRESS to ERROR so that the next "Retrieve Time from OTL (RCVOTLR)" works successfully again

EXPECTED BEHAVIOR
-----------------------
Expect no issue occurs in "Retrieve Time from OTL (RCVOTLR)" when the program is running at the time the application services are stopped

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1) Scheduled RCVOTLR program that's supposed to start at 5:00 PM. Previous run was not in error.
2) DBA stopped the application services at 5:14 PM. The database stayed up and the RCVOTLR program continued running.
3) Application services were restarted at around 5:29 PM
4) RCVOTLR completed in error at 5:56 PM. Same error as reported:

Your request could not complete because an earlier request is still being processed. Either submit your request later, or contact your system administrator.

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