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: 126.96.36.199
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
Million Knowledge Articles and hundreds of Community platforms