Work Orders Saved Search Error: ORA-00907: missing right parenthesis at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:462)
(Doc ID 2994300.1)
Last updated on JULY 18, 2024
Applies to:
Oracle Enterprise Asset Management - Version 12.2.9 and laterInformation in this document applies to any platform.
Symptoms
When attempting to use Work Order saved search in the Work Orders page, the following error occurs.
ERROR
## Detail 0 ## java.sql.SQLSyntaxErrorException: ORA-00907: missing right parenthesis at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:462) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:405) at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:931)
CHANGE
The issue seems to have started after applying patch 34093813:R12.EAM.C.
STEPS
1. Maintenance Superuser responsibility
2. Go to Work Orders > Save Search button
3. Create save search according required fields > Apply and View Results button
4. Error occurs
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 |
Cause |
Solution |
References |