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 MAY 13, 2022

Applies to:

Oracle Communications MetaSolv Solution - Version 6.2.1 and later
Information in this document applies to any platform.


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


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.


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

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