ORA-00904: "SELECT_NAME": Invalid Identifier Error When Creating Record In Resource Addresses And Subinventory Form

(Doc ID 2274108.1)

Last updated on JUNE 06, 2017

Applies to:

Oracle Spares Management - Version 12.1.3 and later
Information in this document applies to any platform.


On : 12.1.3

When attempting to create a subinventory for a new resource in the resource address and subinventory form the following error occurs.

ORA-00904: "SELECT_NAME": invalid identifier


The error occurs when the resource is defined as 'Other resource' type.

The issue can be reproduced at will with the following steps:
1. open the resource address and subinventory form
2. enter Resource type = Other resource
    Enter resource name = %<resource_name>%
3. error occurs


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