ETL9.2:TL_TIMEADMIN Fails When Inserting Into Temp Tables (Doc ID 2250669.1)

Last updated on AUGUST 02, 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,TL_TIMEADMIN Fails when inserting into temp tables

We are receiving these errors when running TL_TIMEADMIN in our production database:


 

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



2017-03-16-08.11.13.000000: Starting TL_TA000900 Validate Balances. (13507,13)

File: e:\pt85508b-retail\peopletools\src\psappeng\aedebug.hSQL error. Stmt #: 1723 Error Position: 12 Return: 600 - ORA-00600: internal error code, arguments: [kkogbro: no kkoaptyp], [0], [], [], [], [], [], [], [], [], [], []
Failed SQL stmt: INSERT INTO PS_TL_ESTGRS_TAO6 (PROCESS_INSTANCE, EMPLID, EMPL_RCD, DUR, SEQ_NBR, EST_GROSS, TRC, COMPRATE) SELECT A.PROCESS_INSTANCE, A.EMPLID, A.EMPL_RCD, A.DUR, A.SEQ_NBR, C.COMPRATE, A.TRC, 0 FROM PS_TL_IPT16 A , PS_TL_TRC_TBL B , PS_COMP_RATECD_TBL C WHERE A.PROCESS_INSTANCE=740977 AND A.TL_QUANTITY = 0 AND A.COMP_RATECD<>' ' AND B.TRC = A.TRC AND B.EFF_STATUS = 'A' AND B.TRC_TYPE = 'A' AND B.EFFDT = ( SELECT MAX(B_ED.EFFDT) FROM PS_TL_TRC_TBL B_ED WHERE A.TRC = B_ED.TRC AND B_ED.EFFDT <= A.DUR) AND C.COMP_RATECD=A.COMP_RATECD AND C.COMP_RATE_TYPE='FA' AND C.EFFDT=( SELECT MAX(C1.EFFDT) FROM PS_COMP_RATECD_TBL C1 WHERE C1.COMP_RATECD=A.COMP_RATECD AND C1.EFFDT<=A.DUR)

Process 740977 ABENDED at Step TL_TA000900.MB000.Step020 (SQL) -- RC = 600 (108,524)

Process %s ABENDED at Step %s.%s.%s (Action %s) -- RC = %s

The errors usually happen on table PS_TL_IPT2x (any IPT2 temp instance), but it has started to happen on other temp tables as well. We can rebuild the temp table and that instance of TL_TIMEADMIN will finish, but the next instance of TL_TIMEADMIN will encounter the same error.

We are on PeopleTools 8.55.08, HR 9.2 Image 8, Oracle 12.1.0.2 (on OEL 6.1). Batch server is Windows 2012 R2.



STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Navigate to Time and Labor> process time> request time administration
2. Run the process


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