TL Apply Rules Abend After Applying PUM 17
(Doc ID 2191946.1)
Last updated on JULY 22, 2020
Applies to:PeopleSoft Enterprise HCM Time and Labor - Version 9.2 and later
Information in this document applies to any platform.
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 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.
SQL 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
Process 100002598 ABENDED at Step TL_TA_RULES.AU-OUT.Step27 (SQL) -- RC = 805 (108,524)
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.
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