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.
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