ETL9.2: Auto Enrollment Process Abends at Step TL_AENRL_LIB.ER000.Step03
(Doc ID 2187840.1)
Last updated on DECEMBER 14, 2023
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
Auto Enroll Process Abended with the error
INSERT INTO PS_TL_AENRL_ER_TBL(EMPLID ,EMPL_RCD ,EFFDT ,EFFSEQ ,LASTUPDDTTM
,TL_PRCS_ERR_FLG ,DESCRLONG) SELECT DISTINCT A.EMPLID ,A.EMPL_RCD ,A.EFFDT
,A.EFFSEQ ,GETDATE() ,'NE' ,:1 FROM PS_TL_AENRL_TAO4 A WHERE
A.process_instance =81291 AND NOT EXISTS ( SELECT 'X' FROM PS_TL_AENRL_ER_TBL
B WHERE B.EMPLID = A.EMPLID AND B.EMPL_RCD =A.EMPL_RCD AND B.EFFDT = A.EFFDT
AND B.EFFSEQ = A.EFFSEQ ) AND NOT EXISTS ( SELECT 'X' FROM PS_TL_AE_STG_TAO4
E WHERE E.EMPLID = A.EMPLID AND E.EMPL_RCD =A.EMPL_RCD AND E.EFFDt = A.EFFDT
AND E.EFFSEQ = A.EFFSEQ AND E.process_instance =81291 )
/
-- Bind variables:
-- 1) Employee Not eligible for any Enrollment Group
-- Row(s) affected: 0
-- 13:17:17.119 Process 81291 ABENDED at Step TL_AENRL_LIB.ER000.Step03 (Action SQL) -- RC = 8601
ROLLBACK
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. RUN auto enrollment 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 |