WORKFORCE_FULLSYNC HCM To ELM: EOP_PUBLISHT Fails With Error: "Fetching Array Element 0: Index is Not in Range 1 to 21 (180,252)" (Doc ID 1593092.1)

Last updated on MARCH 29, 2016

Applies to:

PeopleSoft Enterprise HCM Human Resources - Version 9 to 9.2 [Release 9]
PeopleSoft Enterprise ELM Enterprise Learning Management - Version 9 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

WORKFORCE_FULLSYNC HCM to ELM - EOP_PUBLISHT fails with error

Error:
Initial error : Fetching array element 0: index is not in range 1 to 21. (180,252) EOL_PUBLISH.PUBDTL.GBL.default.19 00-01-01.Step05.OnExecute PCPC:15520 Statement:238
Updated to be the same as the message version (VERSION_2) per Oracle incident.
UPDATE PSMSGDEFN SET DEFAULTVER = '' WHERE MSGNAME = ''

When running the job again, received the SQL error below:

SQL error. Function: CreateSQL Error Position: 101 Return: 942 - ORA-00942: table or view does not exist Statement: select a.emplid, a.empl_rcd, a.cobra_event_id, to_char(a.effdt,'yyyy-mm-dd'), a.bene fit_program froM PS_BEN_PRGPARTC_V2 A ORDER BY A.EMPLID, A.EMPL_RCD, A.COBRA_EVENT_ID, A.EFFDT Original Statement: Select A.EMPLID, A.EMPL_RCD, A.COBRA_EVENT_ID, %DateOut(A.EFFDT), A.BENEFIT _PROGRAM from %Table(:1) A order by A.EMPLID, A.EMPL_RCD, A.COBRA_EVENT_ID, A.EFFDT

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