ETL9.x: App Engine: TL_TIMEADMIN Abending At Step TL_SCHRES_AE.RSLV01.UpOverE (Doc ID 1476627.1)

Last updated on JULY 13, 2016

Applies to:

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

Symptoms

On :  9.1 version, NA Payroll Integration/TL Load

Upgrading from HCM 9.0 to 9.1. PT from 8.49.05 to 8.52.05. FP DEC 2010 MP5.
TA abends with following error message for employee having alternate schedules

ERROR
-----------------------

App Engine: TL_TIMEADMIN abending at Step TL_SCHRES_AE.RSLV01.UpOverE  

App Engine: TL_TIMEADMIN abending at Step TL_SCHRES_AE.RSLV01.UpOverE
File: e:\pt852-903-r1-retail\peopletools\src\psappeng\aedebug.hSQL error. Stmt #: 1620  Error Position: 43  Return: 1427 - ORA-01427: single-row subquery returns more than one row
Failed SQL stmt:UPDATE PS_WRK_ADHOC_TAO4 SET SCHED_HRS = ( SELECT S.SCHED_HRS FROM PS_SCH_MNG_SCH_TBL S WHERE PS_WRK_ADHOC_TAO4.PROCESS_INSTANCE = 109472 AND S.EMPLID = PS_WRK_ADHOC_TAO4.EMPLID AND S.EMPL_RCD = PS_WRK_ADHOC_TAO4.EMPL_RCD AND S.DUR = PS_WRK_ADHOC_TAO4.DUR AND S.SEQ_NO = PS_WRK_ADHOC_TAO4.SEQ_NO) WHERE EXISTS ( SELECT 'X' FROM PS_SCH_MNG_SCH_TBL S1 WHERE PS_WRK_ADHOC_TAO4.PROCESS_INSTANCE = 109472 AND S1.EMPLID = PS_WRK_ADHOC_TAO4.EMPLID AND S1.EMPL_RCD = PS_WRK_ADHOC_TAO4.EMPL_RCD AND S1.DUR = PS_WRK_ADHOC_TAO4.DUR AND S1.SEQ_NO = PS_WRK_ADHOC_TAO4.SEQ_NO) AND PS_WRK_ADHOC_TAO4.PUNCH_TYPE='0'


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Setup an exception time reporter with elapsed schedule and alternate schedule
2.Run TA the process abends with above error message.

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