ETL9.2: Auto Enrollment Process Abends at Step TL_AENRL_LIB.ER000.Step03 (Doc ID 2187840.1)

Last updated on AUGUST 09, 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

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

 

 

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