ORA-00904: "SELECT_NAME": Invalid Identifier Error When Creating Record In Resource Addresses And Subinventory Form
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