E-ORA: ORA-00920: INVALID RELATIONAL OPERATOR Error - LIKE and NOT LIKE are Replaced in Where Clauses (Doc ID 2259304.1)

Last updated on JUNE 29, 2017

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.54 and later
PeopleSoft Enterprise SCM Production Management - Version 8 SP3 and later
PeopleSoft Enterprise SCM eStore - Version 8 SP3 and later
PeopleSoft Enterprise SCM Quality - Version 9.2 and later
PeopleSoft Enterprise SCM Promotions Management - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

ENVIRONMENT
==============
PT 8.55
Upgrade from FSCM 9.1 to FSCM 9.2


When attempting to run dlupsyse.dms script during application upgrade the following error occurs.


ERROR
=======
Exporting EOEN_REG
 Message Set Number: 200
 Message Number: 0
 Message Reason: File: Data MoverSQL error. Stmt #: 0 Error Position: 328 Return: 920 - ORA-00920: invalid relational operator
Failed SQL stmt: SELECT EOEN_PRCS_NAME,EOEN_CATEGORY,DESCR,DESCRLONG,EOEN_NOTIFY_WRKLST,EOEN_NOTIFY_EMAIL,EOEN_NOTIFY_APPMSG,EOEN_CUSTOM_NOTIFY,PRE_QUALIFYPATH,PRE_APPCLASSID,POST_QUALIFYPATH,POST_APPCLASSID FROM PS_EOEN_REG WHERE EOEN_PRCS_NAME <> 'IN_ALERT' AND EOEN_PRCS_NAME <> 'MG_ALERT' AND EOEN_PRCS_NAME <> 'OM_ALERT' AND EOEN_PRCS_NAME niet zoals 'BI_%' (200,0)

SQL Error. Error Position: 328 Return: 920 - ORA-00920: invalid relational operator
SELECT EOEN_PRCS_NAME,EOEN_CATEGORY,DESCR,DESCRLONG,EOEN_NOTIFY_WRKLST,EOEN_NOTIFY_EMAIL,EOEN_NOTIFY_APPMSG,EOEN_CUSTOM_NOTIFY,PRE_QUALIFYPATH,PRE_APPCLASSID,POST_QUALIFYPATH,POST_APPCLASSID FROM PS_EOEN_REG WHERE EOEN_PRCS_NAME <> 'IN_ALERT' AND EOEN_PRCS_NAME <> 'MG_ALERT' AND EOEN_PRCS_NAME <> 'OM_ALERT' AND EOEN_PRCS_NAME niet zoals 'BI_%'
Error: SQL execute error for EOEN_REG
Ended: Fri Mar 31 09:49:08 2017
Unsuccessful completion


STEPS
======
The issue can be reproduced at will with the following steps:
1. Perform FSCM upgrade from 9.1 to 9.2 while you have as base language dutch
2. Run dlupsyse.dms script


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