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

Last updated on SEPTEMBER 06, 2023

Applies to:

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.

Cause

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