WO Search ''ORA-00904: "EWOD"."TARGET_COMPLETION_DATE": Invalid Identifier
(Doc ID 2365651.1)
Last updated on JULY 15, 2020
Applies to:
Oracle Enterprise Asset Management - Version 12.2.5 and laterInformation in this document applies to any platform.
Symptoms
On : 12.2.5 version, SETUP
When attempting to search the Work orders in Maintenance Super User
the following error occurs.
ERROR
-----------------------
wdj.DESCRIPTION,
wdj.STATUS_TYPE,
decode(wdj.FIRM_PLANNED_FLAG,1,'Yes','No') as firm_planned_flag, >
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Navigate --> Maintenance Super User responsibility .
2. Search for Work orders , Both Simple and Advanced .
3. Error is thrown.
4. This error is happening after applying 22821433R12.EAM.C
BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot search the Work orders and get the details .
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 |