My Oracle Support Banner

ORA-00933 Error Searching Engineering Work Order; "ORA-00933: SQL command not properly ended" (Doc ID 2284685.1)

Last updated on FEBRUARY 21, 2019

Applies to:

Oracle Communications MetaSolv Solution - Version 6.2.1 and later
Information in this document applies to any platform.
*** Reviewed for relevance 28-JAN-2019 ***

Symptoms

Problem Summary:

Users unable to search/query existing EWO orders by order-numbers starting with ‘IN’. Doing so results in the ORA-00933 error below.

Work Around/Resolution: Use the LIKE query functionality

STEPS

The issue can be reproduced at will with the following steps:
1. Go to Engineering Work Order screen
2. Enter some EWO number starting with "IN" (ex: IN-123456-1, IN-1234-012 or IN-23456-1)
3. Hit Search.





Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.