Why can't the Pm_route_no be queried from the PM Master Search Screen?
Last updated on OCTOBER 16, 2016
Applies to:Oracle Utilities Work and Asset Management - Version: 220.127.116.11
Information in this document applies to any platform.
When we open the PM Master search screen,select custom Sql under Actions and input the following query:
Query: pm_route_no is not null
The following error message is returned:
Oracle error: unable to perform query. ORA 00904: PM_ROUTE_NO: invalid identifier.
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