HCM ACA Data Extract Fails With Unexpected Token Error in ACA_EXTRACT.P55-ITMP.STEP080 (Doc ID 2227820.1)

Last updated on JANUARY 29, 2017

Applies to:

PeopleSoft Enterprise HCM eBenefits - Version 9.1 to 9.2 [Release 9.0 to 9]
Information in this document applies to any platform.

Symptoms

When attempting to run the ACA Data Extract, the following error occurs.

ERROR
-----------------------
Failed SQL stmt: DELETE FROM PS_ACA_EXT_TMP5 WHERE PROCESS_INSTANCE = 1287168 AND EXISTS ( SELECT 'X' FROM PS_ACA_EXT_TMP 4 X WHERE X.PROCESS_INSTANCE = 1287133 AND X.EMPLID = PS_ACA_EXT_TMP5.EMPLID AND X.EMPL_RCD = PS_ACA_EXT_TMP5.EMPL_RCD)


ACA_EXTRACT.P55-ITMP.Step080 Do select


%Select(ACA_EXTRACT_AET.P_PRCSINSTANCE,ACA_EXTRACT_AET.TABLENAME)
SELECT A.PROCESS_INSTANCE
, 'PS_' || A.RECNAME || A.CURTEMPINSTANCE
FROM PS_AETEMPTBLMGR A
WHERE A.PROCESS_INSTANCE IN ( SELECT P.PRCSINSTANCE FROM PSPRCSRQST P
WHERE P.PRCSNAME = 'ACA_EXTRACT'
AND P.RUNSTATUS IN ('3','4','7','10')
AND A.RECNAME = 'ACA_EXT_TMP'
AND A.PROCESS_INSTANCE <> %Bind(PROCESS_INSTANCE))

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