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

(Doc ID 2274108.1)

Last updated on APRIL 16, 2018

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 ( A 'Group resource'  or 'Other 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' or a 'Group 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 / Group
    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