SECURITY DEPLOYMENT TOOL Error - EOPM_SUPD_WRK.FUNCLIB.FIELDFORMULA "1and" is not valid. SQLSTATE=42604 (Doc ID 2145525.1)

Last updated on JUNE 13, 2016

Applies to:

PeopleSoft Enterprise HCM Human Resources - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

Applying PUM Image 17, Tax Update 16-B.

Enterprise Components, Security Deployment, Update Permission Lists

 
ERROR
---------------
SQL statement is incorrect: [IBM][CLI Driver][DB2/AIX64] SQL0103N The numeric literal "1and" is not valid. SQLSTATE=42604 .

(SQLSTATE 42604) -103
Failed SQL stmt:


SELECT CLASSID, EOPM_SUPD_TYPE, EOPM_SUPD_ITEM1, EOPM_SUPD_ITEM2, PTIASPRPTNO, PROJECTNAME, EOPM_SELECTED, EOPM_STATUS, EOPM_STATUS_DT, ACTION_ADD, ACTION_UPDT_DISP, ACTION_UPDTDISPALL, ACTION_CORRECTION, EOPM_SUPD_ACTION, EOPM_SUPD_LOADED, PROCESS_INSTANCE, LASTUPDOPRID, LASTUPDDTTM, DESCRLONG FROM PS_EOPM_SUPD_DTL where 1 = 1and     EOPM_STATUS in ('1','2','3','6','7') ORDER BY CLASSID, EOPM_SUPD_TYPE, EOPM_SUPD_ITEM1, EOPM_SUPD_ITEM2, PTIASPRPTNO

PSAPPSRV.18212 (259) [2016-05-27T11:40:40.081 PS@sn90656.roushnet.com (IE 11.0; WIN7) ICPanel](0) Error in PeopleCode ScrollSelect processing. (2,213) EOPM_SUPD_WRK.FUNCLIB.FieldFormula Name:FilterResult PCPC:1803 Statement:44

Called from:EOPM_SUPD_WRK.EOPM_FILTER_PB.RowInit Statement:19

 

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