NOT ALL TIMECARDS BEING PICKED UP BY APPROVAL WORKFLOW AND REMAIN IN SUBMITTED STATUS (DEFERRED QUEUE)
Last updated on JULY 26, 2017
Applies to:Oracle Time and Labor - Version 11.5.10 to 188.8.131.52 [Release 11.5]
Information in this document applies to any platform.
On 184.108.40.206 in Production:
When users submit timecard through Self Service the workflow sits at the start node and does not move further. Even after running the workflow background process the process does not start. The timecards seem to be stuck. If the process is Expedited via Workflow (WF) Monitor, the process completes and the timecard then moves to the next approval stage.
Steps To Reproduce:
The issue can be reproduced at will with the following steps:
- Submit a new timecard or update an existing one and then run the workflow background process.
- View Status monitor and you will observe that the background process does not pick up the
- If the process is Expedited via Workflow (WF) Monitor, the process completes and the
timecard then moves to the next approval stage.
The issue is first noticed when you upgrade or migrate your Database to 10.2.0.3 or higher version or migrate from a different platform. This solution is applicable to Database versions 10.2.0.3 or higher. For database version 220.127.116.11 / 18.104.22.168 please refer note 263357.1
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms