View EAM_WORK_ORDERS_V is Missing Columns, like TARGET_COMPLETION_DATE, Throws Error ORA-00904 or Shows Invalid Packages

(Doc ID 2361497.1)

Last updated on FEBRUARY 20, 2018

Applies to:

Oracle Enterprise Asset Management - Version 12.2.7 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.7 version,


When attempting to find work orders in Close Work Orders form, the following error occurs.


The issue can be reproduced at will with the following steps:
1. [R] Enterprise Asset Management
2. [N] Close Work Orders
3. Search for work orders and observ error


Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms