My Oracle Support Banner

ETL92: TL_LCOMP_RPT (App Engine) Fails In MAIN - Step08 (Doc ID 2447850.1)

Last updated on FEBRUARY 06, 2019

Applies to:

PeopleSoft Enterprise HCM Time and Labor - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

On : 9.2 version, Time Reporting

It appears the following error is encountered when user tries to run delivered Leave and Compensatory Time report.

Error:
SQL Error in Compile. (2,277) TL_LCOMP_RPT.MAIN.GBL.default.1900-01-01.Step08.OnExecute PCPC:407 Statement:3
2017-08-18-12.55.08.787943 DoStepActions [1956] Exception logged: RC=100.

Process 2936164 ABENDED at Step TL_LCOMP_RPT.MAIN.Step08 (PeopleCode) -- RC = 8 (108,524)

Process %s ABENDED at Step %s.%s.%s (Action %s) -- RC = %s
2017-08-18-12.55.08.787967 DoMessageLogError [1119] Exception logged: RC=4.
2017-08-18-12.55.08.787967 ExecuteStep [1059] Exception logged: RC=100.
2017-08-18-12.55.08.787967 ExecuteSection [713] Exception logged: RC=100.
2017-08-18-12.55.08.787967 AeExecExecute [326] Exception logged: RC=100.
2017-08-18-12.55.08.787968 ProcessRequest [1863] Exception logged: RC=100.

Timings written to trace file (/psoft/pt855_server_cfg/hrtec/appserv/prcs/HRTEC/log_output/AE_TL_LCOMP_RPT_2936164/AE_TL_LCOMP_RPT_2936164_0818125505.AET)
2017-08-18-12.55.08.787969 AeMainFromCommandLine [829] Exception logged: RC=100.


Actual Behavior:
The ÚteDiff in our DB2 environment indicates that the "DAYS" (translation of ÚteDiff) fails when attempting to compile the SQL.

Expected Behavior:
Report should run without error

Steps to Recreate:
The issue can be reproduced at will with the following steps:
1. Navigation: Time and Labor > Reports > Leave and Compensatory Time
2. Provide year and month
3. Enter employee to process
 

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.