TL Apply Rules Abend After Applying PUM 17 (Doc ID 2191946.1)

Last updated on JUNE 21, 2017

Applies to:

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

Symptoms

TL Apply Rules Still Abends After Applying PUM 17

We just applied PUM 17 to a test environment to test the fix for running time admin from the Submit button on the Timesheet page. The first test resulted in a similar error (not sure if it's exactly the same) as the previous error we got, that is described in bug 22543194. Three message windows pop up after clicking Submit. The rule mentioned in the error message, AU-IN is a template built rule based on template 240. Step 27 is where the error occurred. I attached a picture of the SQL for TMPL240_S27. The three messages are included below.


ERROR
-----------------------
First:
File: /vob/peopletools/src/psappeng/aedebug.hSQL error. Stmt #: 1703 Error Position: 0 Return: 805 - ORA-00001: unique constraint (SYSADM.PS_TL_WRK222) violated
Failed SQL stmt: INSERT INTO PS_TL_WRK222 (PROCESS_INSTANCE, EMPLID, EMPL_RCD, PUNCH_DTTM, SEQ_NBR, DUR, PUNCH_TYPE) SELECT A.PROCESS_INSTANCE, A.EMPLID, A.EMPL_RCD, A.PUNCH_DTTM, COUNT(DISTINCT B.PUNCH_DTTM), A.DUR, A.PUNCH_TYPE FROM PS_TL_WRK242 A, PS_TL_WRK242 B WHERE A.PROCESS_INSTANCE = B.PROCESS_INSTANCE AND A.EMPLID = B.EMPLID AND A.EMPL_RCD = B.EMPL_RCD AND A.PUNCH_DTTM >= B.PUNCH_DTTM GROUP BY A.PROCESS_INSTANCE, A.EMPLID,A.EMPL_RCD, A.PUNCH_DTTM, A.DUR,A.PUNCH_TYPE


Second:
Process 100002598 ABENDED at Step TL_TA_RULES.AU-OUT.Step27 (SQL) -- RC = 805 (108,524)


Third:
CallAppEngine: Application TL_CALL_TA: AppEngine error. (2,653) FUNCLIB_TL_WEEK.APPLY_RULES.FieldFormula Name:RunTimeAdmin PCPC:3607 Statement:37
Called from:TL_MSS_EE_SRCH_PRD.GBL.SavePostChange Statement:9

During a CallAppEngine builtin function call, the Application Engine detected an error. The Application Engine log may provide more information.


The issue can be reproduced at will with the following steps:
1. On TL installation page, time admin is selected to be run from submit button on timsheet
2. Go to manager self service, hit submit button that call time admin to run.

Changes

 

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