My Oracle Support Banner

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

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


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