ETL9.X:TL_TIMEADMIN Does Not Finish If Negative Time Is Entered For A Leave Plan

(Doc ID 2316001.1)

Last updated on OCTOBER 17, 2017

Applies to:

PeopleSoft Enterprise HCM Time and Labor - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

On : 9.2 version, Time Administration

ACTUAL BEHAVIOR
---------------
TL_TIMEADMIN does not finish if negative time is entered for a leave plan

We have a very strange issue where if negative time is entered on a leave plan and TLX00010 exception needs to be generated, timeadmin does not finish. It appears to be continually doing iterations of the TL_TA000900.GD000.Step010 do select as you will see in the trace files. Thought it was possibly because there is a state record value that is continuously changing during the do select loop. Interestingly enough from my testing once I move the step into another app engine and call the step in this new app engine from TL_TA000900 instead of using the same step in TL_TA000900 it's fine.

 

EXPECTED BEHAVIOR
-----------------------
Time admin should complete

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Enter negative time on a leave plan to generate TLX00010 exception
2. Time admin does not complete


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